Power BI 778 Test 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?
Correct!
Wrong!
The Correct Answer:
Remove the trend axis from the visualization.
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?
Correct!
Wrong!
The Correct Answer:
Add a folder data source and use the Combine Files command
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?
Correct!
Wrong!
The Correct Answer:
Correct
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?
Correct!
Wrong!
The Correct Answer:
Add a calculated column to Query Editor that totals the sales amount column.
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?
Correct!
Wrong!
The Correct Answer:
Correct
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?
Correct!
Wrong!
The Correct Answer:
Append Queries
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?
Correct!
Wrong!
The Correct Answer:
Update app, configure the Access setting, and then click Update app from the app workspace.
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?
Correct!
Wrong!
The Correct Answer:
Create bookmarks after filtering the bar charts with the slicer
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?
Correct!
Wrong!
The Correct Answer:
Incorrect