Power BI 778 Test 2

Question 1

You intend to build a report with Power BI Desktop, which is optimized for Power BI Report Server. Power BI Report Server will be used to publish the report. You must ensure that users can consume all of the report's visualizations.
Which of the following two types of visualizations should you leave out of the report?

Accepted Answer

R visuals

Answer

funnel charts

Answer

bubble maps

Question 2

You have ten dashboards in your workplace. Sales Data is a dashboard that shows data from two sources. You realize that users can't find what they're looking for.
Natural language queries are used to populate the dashboard with data.
You must ensure that consumers may utilize natural language searches to find data.
What are your options?

Accepted Answer

Modify the Q&A and Cortana settings in the datasets' properties

Answer

Set the Sales Data dashboard as a Favorite from the dashboard menu

Answer

Modify the Language Settings in the workspace's settings

Answer

Modify the Q&A settings in the dashboard's properties

Question 3

You have a Power BI dashboard that shows several sales representations for your company.
On the dashboard, you enable Q&A.
When using Q&A, you should present users with sample questions to ask.
From the Power BI Settings, which settings should you change?

Accepted Answer

Datasets

Answer

Subscriptions

Answer

Workbooks

Answer

Dashboards

Question 4

You have a Microsoft Excel spreadsheet with a Sales table in it.
The Sales table must be added as a tile to a Power BI dashboard.
What is the best way to set up the tile?

Accepted Answer

Pin the table from the Power BI tab in Excel

Answer

Upload the Excel workbook to the Power BI service

Answer

Import the data from the Excel workbook into the Power BI service

Answer

Publish the workbook to the Power BI service from Excel

Question 5

You've created a Power Pivot model with a KPI.
As illustrated in the exhibit, you must develop a visualization based on the Power Pivot model. (Select Exhibit from the drop-down menu.)
Which visualization technique should you employ?

Accepted Answer

KPI

Answer

matrix

Answer

table

Answer

multi row card

Question 6

The visualization in the following display is available to you. The values must be displayed as shown in the following exhibit.
What are your options?

Accepted Answer

Create a metric that includes the percent sign in the values

Answer

Change the Data Type to Percentage in the data source's query

Answer

Create a calculated column in which the numbers are multiplied by the percent symbol

Answer

Change the Data Type to Percentage under the Modeling tab

Question 7

To display data from a PubNub source, you must create a dashboard in the Power BI service.
What are your options?

Accepted Answer

A custom streaming data tile can be added to a dashboard

Answer

Create a report with a Microsoft SQL Server Analysis Services (SSAS) data source that leverages Connect live. The report can be pinned to a dashboard

Answer

Create a workspace for an app and publish it to a dashboard.

Answer

Create a report with a Microsoft Azure SQL database data source that uses DirectQuery. The report can be pinned to a dashboard

Question 8

You create a table named Sales from the Home tab in Power BI Desktop by clicking Enter Data.
When you add Region and Sales to a visualization, the following data appears.
Why are there just four rows of data in the visualization instead of six?

Accepted Answer

the Default Summarization on Region

Answer

the Default Summarization on Sales

Answer

the Data Category of Region

Answer

the Data Category of Sales

Question 9

For Power BI, you'll need to make a customized visualization.
What do you think should be the first thing you install?

Accepted Answer

Node.js

Answer

jQuery

Answer

Microsoft.NET

Answer

Microsoft Azure PowerShell