- (Exam Topic 4)
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Solution:
Text Description automatically generated
Box 1: Yes
The Related function returns a related value from another table.
The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship.
Box 2: Yes
Box 3: No
TX only occurs in the Sales table, but not in the CityData table. Reference:
https://docs.microsoft.com/en-us/dax/related-function-dax https://docs.microsoft.com/en-us/dax/calculate-function-dax

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You have a report in Power Bl named report1 that is based on a shared dataset.
You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.
What should you do?

1. A. Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.
2. B. Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.
3. C. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.
4. D. Apply row-level security (RLS) to the shared dataset.

Correct Answer: C

- (Exam Topic 4)
A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.
You need to use the dataflow in a report. The solution must meet the following requirements:
• Minimize online processing operations.
• Minimize calculation times and render times for visuals.
• include data from the current year, up to and including the previous day. What should you do?

1. A. Create a dataflows connection that has Import mode selected and schedule a dairy refresh.
2. B. Create a dataflows connection that has DirectQuery mode selected.
3. C. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset
4. D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

Correct Answer: A

- (Exam Topic 4)
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen,
You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel. Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A
Instead modify the source step of the queries to use DataSourceExcel as the file path.
Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

- (Exam Topic 3)
You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

1. A. Add the sales department as a member of the reports workspace
2. B. Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.
3. C. Distribute an app to the users in the Azure Active Directory group of the sales department.
4. D. Share each report to the Azure Active Directory group of the sales department.

Correct Answer: B