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

When optimizing a Power BI report for Power BI Report Server, it's crucial to avoid visualizations that require external components or are not fully supported without additional configuration. R visuals (A) require an R engine and specific R packages to be installed and configured on the Report Server, which is often not feasible or straightforward. 'Breadcrumbs' (C) is not a standard Power BI visualization; if it refers to a custom visual, many custom visuals from AppSource may not be fully compatible with or easily deployable to Power BI Report Server, potentially hindering consumption.

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

Natural language queries (Q&A) in Power BI rely heavily on the underlying dataset for accurate responses. To ensure users can effectively find data using Q&A, you must modify the Q&A and Cortana settings within the properties of the relevant datasets. These settings allow you to define synonyms, suggest questions, and configure field properties, all of which enhance the Q&A engine's ability to understand and respond to user queries.

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

The Q&A feature in Power BI is powered by the underlying datasets that feed the dashboard. To present users with sample questions and improve the overall Q&A experience, you need to configure these settings at the dataset level. Within the dataset's properties in the Power BI service, you can define suggested questions, add synonyms, and manage other Q&A-related options to guide users in their natural language queries.

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

The most efficient way to add a table from an Excel spreadsheet as a tile to a Power BI dashboard is by using the Power BI tab (or add-in) directly within Excel. This feature allows users to select a range, chart, or table in their Excel workbook and 'Pin' it to an existing Power BI dashboard. This creates a live tile that updates as the Excel data changes, without requiring a full import of the workbook into the Power BI service.

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

To develop customized visualizations for Power BI, developers utilize the Power BI Custom Visuals SDK. This SDK relies on Node.js and its package manager (npm) for setting up the development environment, managing dependencies, and building the visual. Therefore, installing Node.js is a fundamental prerequisite and typically the very first step in the custom visual development process.

Power BI 778 Practice Test

Power BI 778 Practice Test

Power BI 778 Test 2