Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.

B. a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.

C. a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.

D. a pie chart that shows balances by account category without filters.

E. a ribbon chart that shows balances by quarter and accounts in the legend.

You are creating a Power Bl report by using Power Bi Desktop. You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals. Which type of visual should you use?

A. key influencers

B. decomposition tree

C. QandA

D. smart narrative

You have the following table named Location.

The GeoCode column represents the country where each customer is located.

You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations. What should you do?

A. Replace the values in the GeoCode column with postal codes or zip codes.

B. Change the name of the GeoCode column to Country.

C. Change the name of the Location table to Country.

D. Change the Default Summarization of the GeoCode column.

E. Add a Geoportal column to the Location table.

F. Change the Data Type of the GeoCode column.

A manager can represent only a single country.

You need to use row-level security (RLS) to meet the following requirements:

The managers must only see the data of their respective country.

The number of RLS roles must be minimized.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

B. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.

C. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

D. Create one role for each country.

E. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

HOTSPOT

You have a Power BI imported dataset that contains the data model 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.

Hot Area:

HOTSPOT

You have the Azure SQL databases shown in the following table.

You plan to build a single PBIX file to meet the following requirements:

1.

Data must be consumed from the database that corresponds to each stage of the development lifecycle.

2.

Power Bl deployment pipelines must NOT be used.

3.

The solution must minimize administrative effort.

What should you do? To answer, select the appropriate options in the answer area.

Hot Area:

HOTSPOT

You need to create a visualization to meet the reporting requirements of the sales managers.

How should create the Visualization? TO answer, select the appropriate options in the answer area.

Hot Area:

HOTSPOT

You have the Power BI data model shown in the following exhibit.

Select the appropriate yes or no.

Hot Area:

DRAG DROP

You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.

You need to build the dashboard.

Which four 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.

Select and Place:

DRAG DROP

You have a folder that contains 100 CSV files.

You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.

Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.

NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Select and Place: