You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

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

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?

• A.Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
• B.Create one workspace for development. From the new workspace, publish an app for production.
• C.Create a workspace for development and a workspace for production. From the production workspace, publish an app.
• D.In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

Comment: *

Name: *

Email: *

Verification: *

Hotspot Question
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate.
You have a data model that contains the following tables.
The affiliate has a one to-many relationship to the Transactions table based on the AffiliatelD column.
You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You assign all the users the Viewer role to the workspace.
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

1 - Create a query that uses Common Data Service as a data source.
2 - Specify the following query.= Table.Distinct(#"SalesDetail")
3 - Create a visual for the query table.

Comment: *

Name: *

Email: *

Verification: *