New Questions 2

You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data.

Which data source you should use?

A. Microsoft Azure Data Lake Store

B. Microsoft Azure Table Storage

C. Microsoft Azure HDInsight

D. Microsoft Azure SQL Database

View Answer

New Questions 3

HOTSPOT

You open powerbi.com as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

View Answer

New Questions 4

HOTSPOT

You have the following tables.

You need to create a measure to calculate a running total of TransactionQuantity.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

View Answer

New Questions 5

You plan to embed multiple visualization in a public website.

Your Power BI infrastructure contains the visualizations configured as shown in the following table.

Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.

NOTE: Each correct selection is worth one point.

A. Visual1

B. Visual2

C. Visual3

D. Visual4

E. Visual5

View Answer

New Questions 6

You plan to create several datasets by using the Power BI service. You have the files configured as shown in the following table.

You need to identify which files can be used as datasets.

Which two files should you identify? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Data 1

B. Data2

C. Data 3

D. Data4

E. Data 5

View Answer

New Questions 7

You have a Power BI model for sales data.

You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period.

Which DAX function should you use?

A. PARALLELPERIOD

B. SAMEPERIODLAST YEAR

C. DATESYTD

D. PREVIOUSYEAR

View Answer

New Questions 8

Note: This question is a 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.

Your company has 1,000 users in a Microsoft Office 365 subscription.

A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users.

You discover that a use name User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards.

Solution: From the Power BI Admin portal, you modify the Dashboard settings. Does this meet the goal?

A. Yes

B. No

View Answer

New Questions 9

Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that contains the following tables.

The following columns contain data information:

u2711 Date[Month] in the mmyyyy format

u2711 Date[Date_ID] in the ddmmyyyy format

u2711 Date[Date_name] in the mm/dd/yyyy format

u2711 Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

The Store table has relationship to the Monthly_returns table on the Store_ID column. This

is the only relationship between the tables.

You plan to use Power BI desktop to create an analytics solution for the data. End of repeated scenario.

You plan to create a chart that displays total Order [Order_amount] by Store [Name]. You need to modify the model to ensure that you can create the chart.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. To the Order table, add a column that uses the RELATED(u2021Storeu2021 [Store_ID]) DAX formula.

B. Create a relationship between the Order table and the Store table.

C. To the Order table, add a measure that uses the COUNT (u2021Orderu2021[Order_amount]) DAX formula.

D. To the order table, add a measure that uses the SUM (u2021Orderu2021 [Order_amount]) DAX formula.

View Answer

New Questions 10

From Power BI Desktop, you create a query that imports the following table.

You need to configure the table to appear as shown in the following table.

What should you do?

A. From the Extract menu, click Last Characters.

B. From the Extract menu, click Text After Delimiter.

C. From the Format menu, click Trim.

D. From the Split Column menu, click BY Delimiter.

View Answer

New Questions 11

You manage a Power BI model has a table named Sales.

You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.

What should you do from Power BI Desktop?

A. From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= u201cUnited Statesu201d && [ProductCategory]= u201cClothingu201d

B. Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing

C. From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= u201cUnited Statesu201d

D. Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

View Answer