Power BI 778 Test 1

Question 1

In Power BI Desktop, you create a KPI visualization using the month as the trend axis. However, you realize that the data is not sorted by month. The visualization's sort order must be changed.

What should you start with?

Accepted Answer

Remove the trend axis from the visualization.

Answer

Convert the visualization to a different type

Answer

Modify the drillthrough filters

Answer

Modify the visual level filters

Question 2

You intend to import 100 CSV files into Power BI Desktop, each containing data from a separate store. The files are identical in structure and are kept on a network share. You must combine the CSV files into a single table. The solution must require the least amount of administrative effort.

What are your options?

Accepted Answer

Add a folder data source and use the Combine Files command

Answer

Add a folder data source and use the Merge Queries command

Answer

Add text/CSV data sources and use the Append Queries command

Answer

Add a Microsoft Excel data source and use the Merge Queries command

Question 3

You have an app workspace with a report in it. The report contains confidential information.

You must verify that the report can be embedded into a bespoke application that will be used by external users. There will be no Microsoft Azure Active Directory user accounts or Power BI licenses for external users.

Solution: Purchase Power BI Premium P1 and set up the app workspace to operate in dedicated mode.

Is this achieving the goal?

Accepted Answer

Correct

Answer

Incorrect

Question 4

You are importing sales data into Power BI Desktop from a Microsoft Excel file named Sales.xlsx. You need to create a bar chart that shows the total sales amount by region. When you create the bar chart, the regions appear as expected, but the sales amount value displays the count of sales amount instead of the sum of sales amount each region. You must modify the query to ensure that the data appears correctly.

What are your options?

Accepted Answer

Add a calculated column to Query Editor that totals the sales amount column.

Answer

Remove the query, then import the data into Microsoft SQL Server.

Answer

Refresh the data model

Answer

Change the sales amount column's data type to Numeri

Question 5

You've uploaded a Microsoft Excel workbook to Microsoft SharePoint Online. Several Power View sheets are included in the workbook.

In the Power BI service, you must replicate the Power View sheets into reports.

Solution: Get the data from SharePoint Online using the Power BI service, then choose Import.

Is this achieving the goal?

Accepted Answer

Correct

Answer

Incorrect

Question 6

In Power BI Desktop, you have two queries: Query1 retrieves a table named SMB Customers from a Microsoft SQL Server database, while Query2 retrieves a table named Enterprise Customers from an Oracle database. Both tables have the identical columns. The data from SMB Customers and Enterprise Customers must be combined.

Which command do you need to use?

Accepted Answer

Append Queries

Answer

Merge Columns

Answer

Combine Files

Answer

Merge Queries

Question 7

App1 is the name of your Power BI app. The App1 app workspace's privacy is set to Private.

App1 does not exist in the My organization AppSource, according to User1.

For your account, App1 appears in the My organization AppSource. User1 must be able to see App1 from the My organization AppSource.

What are your options?

Accepted Answer

Update app, configure the Access setting, and then click Update app from the app workspace.

Answer

Add a member from the workspace settings in the app

Answer

Update app, configure the Content settings, and then click Update app from the app workspace

Answer

Share the dashboard from the app workspace

Question 8

You're working on a Power BI Desktop report with many bar charts and a date slicer, and you need to make a slide show that can be seen via the Power BI service. The charts must be filtered for a different year on each slide.

Before you publish the report, what should you do?

Accepted Answer

Create bookmarks after filtering the bar charts with the slicer

Answer

Create groups using the List group type after configuring report level filters

Answer

Create groups using the Bin group type after configuring page level filters.

Answer

Select Selection Pane after configuring drillthrough filters for each bar chart

Question 9

You've uploaded a Microsoft Excel workbook to Microsoft SharePoint Online. Several Power View sheets are included in the workbook.

In the Power BI service, you must replicate the Power View sheets into reports.

Solution: Click Publish to Power BI and then Export from Excel.

Is this achieving the goal?

Accepted Answer

Incorrect

Answer

Correct