C2090-621 Online Practice Questions and Answers

A report author wants to nest a chart within a list and filter the chart data to relate to the row of the list that it is displayed in.

How can this be done?

A. Enable share result set on the list object.

B. Create a join in the Query explorer to merge the data.

C. Select the list and define a Master detail relationship.

D. Select the chart and define a Master detail relationship.

An Active Report contains a data deck with the following values on multi select controls:

How many cards would be generated?

A. 5

B. 9

C. 14

D. 20

A report author has been asked to create a list report with multiple facts from across the business. The desired outcome must ensure correlated and predictable results.

Which item must be included in the list report?

A. Repeater table

B. Conditional fact

C. Model Query subject

D. Conformed dimension

What can be done when using a SQL object when not using a stored procedure?

A. Update a database.

B. Insert rows into database.

C. Delete rows in a database.

D. Select rows from a database.

A report author created the following list report and wants to filter all order methods which generated total revenue less than one billion.

Which filter should be used?

A. A detail filter as [Revenue] >= 100000000 with application set to before auto aggregation.

B. A detail filter as [Revenue] >= 100000000 with application set to after auto aggregation.

C. A detail filter for Total([Revenue]) >= 100000000 with application set to before auto aggregation.

D. A detail filter for Total([Revenue]) >= 100000000 with application set to after auto aggregation.

Data Lineage is supported by which of the following?

A. Reports based on packages.

B. Only on reports based on Lists.

C. Reports based on Data modules.

D. Only data items defined in a Master data glossary.

A report needs to modify the Interactive Behavior within an Active Report.

Which button can be used?

A.

B.

C.

D.

Which properties must be set when using a SQL object?

A. Data source and SQL

B. Package name and SQL

C. Cardinality and namespace

D. Primary Key and namespace

A report author is building an Active Report for mobile use on an iPad. The report contains a list object. The report author wants to ensure the entire list has a consistent size so that it does not affect the report layout.

Which techniques should be used to ensure this? (Choose two.)

A. Specify the exact width for all columns in the list.

B. Specify the exact width for only the measure columns in the list.

C. Surround the list in a defined size block with "Content is not clipped".

D. Limit the number of rows returned with the use of a style variable on the list.

E. Surround the list in a defined size block with the "Use scrollbars only when necessary" property chosen.

A user wants to ensure that the visualizations in a tabbed Dashboard appear exactly as they were sized and placed, regardless of the screen size of the device that they are viewed in.

Which template should be used?

A. Canvas

B. Freeform

C. Infographic

D. Single page