- (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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: B

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

1. A. Create production reports in a separate workspace that uses a shared dataset from the development workspac
2. B. Grant the end users access to the production workspace.
3. C. In the same workspace, create separate copies of the assets and append DEV to the names of the copied asset
4. D. Grant the end users access to the workspace.
5. E. Create separate workspaces for development and productio
6. F. Grant the end users access to the production workspace.
7. G. Create one workspace for developmen
8. H. From the workspace, publish an app for production.

Correct Answer: C

- (Topic 4)
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

1. A. A user pressed F5
2. B. A new transaction was added to the data source.
3. C. A user added a comment to a tile.
4. D. The dashboard tile cache refreshed.

Correct Answer: A
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

HOTSPOT - (Topic 4)
You need to create a Power Bl report. The first page or the report must contain the following two views:
* Sales By Postal Code
* Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 4)
You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.
Which type of visualization should you use?

1. A. key influences
2. B. ribbon chart
3. C. line chart
4. D. scatter chart

Correct Answer: C