Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

What is the minimum number of datasets and storage modes required to support the reports?

A.

two imported datasets

B.

a single DirectQuery dataset

C.

two DirectQuery datasets

D.

a single imported dataset

You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power B1 dataset that contains quarterly sales performance data.

You need to enable managers to review the data in a format that meets the following requirements:

• Is optimized for printing.

• Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.

What should you create?

A.

a paginated report

B.

a template app

C.

an interactive report

D.

a dashboard

You import a large dataset to Power Query Editor.

You need to identify whether a column contains only unique values.

Which two Data Preview options can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point

A.

Show whitespace

B.

Column distribution

C.

Column profile

D.

Column quality

E.

Monospaced

You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue.

Solution: You Normalize casing in the source query or Power Query Editor.

Does this meet the goal?

A.

Yes

B.

No

You need to create a visual that compares profit across 10 product categories for a selected quarter.

What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select the BEST answer.

A.

an area chart

B.

a clustered bar chart

C.

a line chart

D.

a funnel chart

You are creating a dashboard by using the Power Bl service.

You have an existing report page that contains three charts.

You need to add the charts to the dashboard while maintaining the interactivity between the charts.

What should you do?

A.

Pin each chart as a tile.

B.

Edit interactions in the report and set all interactions to Filter

C.

Edit the dashboard theme and pin each chart as a file.

D.

Pin the report page as a live page.

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

A.

SQL Server Profiler

B.

Performance Analyzer in Power BI Desktop

C.

Query Diagnostics in Power BI

D.

Microsoft Edge DevTools

You are developing a sales report that will have multiple pages. Each page will answer a different business question.

You plan to have a menu page that will show all the business questions.

You need to ensure that users can click each business question and be directed to the page where the

question is answered. The solution must ensure that the menu page will work when deployed to any

workspace.

What should you include on the menu page?

A.

Create a text box for each business question and insert a link.

B.

Create a button for each business question and set the action type to Bookmark.

C.

Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business

questions.