Answer keys

This section contains the answer keys for both the practice tests.

Practice Test 1

1. C – Focus mode is when a visual is shown over the entire canvas.
2. C – Trend lines in visuals change when data changes.
3. C – Categorical analysis is required in this example.
4. C – Power BI is a popular BI tool with both enterprise and citizen developers.
5. B – Sort ascending will sort from lowest to highest.
6. B – The RANKX function requires table, expression, and order parameters.
7. D – Responsive slicers must contain a selection list of values.
8. B – Supported cardinalities are many-to-one, one-to-many, many-to-many, and one-to-one.
9. C – Table visual is the most similar to a database table.
10. B – Drillthrough is set up on the target page.
11. C – Row-level security requires a DAX expression.
12. C – Development pipelines support development, test, and production stages.
...