In Cognos Which of the following statements about queries are TRUE?

Question $5$ Select one or more:

A$.$

A report can only have one associated query, but that query can be a join of multiple queries

B$.$

A data item in a query does not have to appear on the report

C$.$

A left outer join returns only rows that exist in one of the two joined queries

D$.$

Queries can only be joined when working with dimensionally$-$modeled data

E$.$

An inner join returns only rows that exist in both queries

How can you add a prompt to a report?

Question $6$ Select one or more:

A$.$

Add a Prompt item to a report

B$.$

Create a parameter for an item on the report

C$.$

Use the filter$()$ function in a query expression

D$.$

Add a Variable Text Item to the report page

E$.$

Use the Properties of the report object

How would you incorporate data into a report from a personal data source, such as a Microsoft Excel spreadsheet?

Question $7$ Select one:

A$.$

Drag the spreadsheet into the report area

B$.$

Use the Upload files feature and create a Data module from the uploaded file

C$.$

Data must be converted to a CSV format, and then uploaded to IBM Cognos Analytics using the Upload files feature

D$.$

Personal data files cannot be imported into IBM Cognos Analytics due to the security risk