Microsoft 70-778 Exam Practice Test Instant Access

Question 1

You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database. From Power BI Desktop, you can query the database.

When you publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should you do to resolve the issue?

ALocate the published dataset for the project in the Power BI service and configure the data source credentials.

BInstall the on-premises data gateway (personal mode) and republish the project.

CInstall the on-premises data gateway and configure a data source.

DConfigure a Microsoft Azure ExpressRoute connection between the on-premises network and the Power BI service.

Answer : A

Question 2

Your company has a security policy stating that proprietary data must not be transferred over the Internet. During a security audit, auditors discover that executives use the Power BI service for reporting. You need to recommend a solution to ensure that the company adheres to the security policy. What should you include in the recommendation?

AMicrosoft SQL Server column encryption

BMicrosoft Azure ExpressRoute

Ca site-to-site VPN to Microsoft Azure

Dthe on-premises gateway for Power BI

Answer : B

References:

https://docs.microsoft.com/en-us/power-bi/service-admin-power-bi-expressroute

Question 3

You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit.

You need to ensure that when you click the bar of a country, only the values for that country are shown on the Revenue by Year and Manufacturer chart.

AClick the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Filter.

BClick the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Highlight.

CClick the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Filter.

DClick the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Highlight.

Answer : C

References:

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Question 4

You need to create a custom visualization for Power BI. What should you install first?

AjQuery

BNode.js

CMicrosoft Azure PowerShell

DMicrosoft.NET

Answer : B

References:

https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools

Question 5

From the Home tab in Power BI Desktop, you click Enter Data and create a table named Sales that contains the following data.

You add Region and Sales to a visualization and the visualization displays the following data.

What causes the visualization to display four rows of data instead of six?

Athe Data Category of Region

Bthe Default Summarization on Region

Cthe Default Summarization on Sales

Dthe Data Category of Sales

Answer : B

Question 6

You plan to use Power BI Desktop to import 100 CSV files.

The files contain data from different stores. The files have the same structure and are stored in a network share.

You need to import the CSV files into one table. The solution must minimize administrative effort.

What should you do?

AAdd a folder data source and use the Combine Files command.

BAdd a folder data source and use the Merge Queries command.

CAdd a Microsoft Excel data source and use the Merge Queries command.

DAdd text/CSV data sources and use the Append Queries command.

Answer : A

References:

https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries

Question 7

You are creating a Power BI Desktop report that has several bar charts and a date slicer.

You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts filtered for a different year.

What should you do before you publish the report?

AConfigure report level filters, and then create groups that use the List group type.

BConfigure drillthrough filters for each bar chart, and then select Selection Pane.

CFilter the bar charts by using the slicer, and then create bookmarks.

DConfigure page level filters, and then create groups that use the Bin group type.

Answer : C

References:

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

Microsoft 70-778 Analyzing and Visualizing Data with Microsoft Power BI Exam Practice Test