×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data.
In Power BI Desktop, you have the following query for the cube.
The query retrieves 25,499 records.
When you check the data warehouse that is the source of the cube, you discover that there are 26,423 records.
You need to ensure that the query retrieves all 26,423 records.
What should you do?
In Power BI Desktop, you have the following query for the cube.
The query retrieves 25,499 records.
When you check the data warehouse that is the source of the cube, you discover that there are 26,423 records.
You need to ensure that the query retrieves all 26,423 records.
What should you do?
2.
You have a query that retrieves sales data. A sample of the data is shown in the following table.
You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row.
What should you click on the Transform tab in Query Editor?
You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row.
What should you click on the Transform tab in Query Editor?
3.
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?
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?
4.
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?
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?
5.
You have a Power BI app named App1. The privacy for the App1 app workspace is set to Private.
A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.
You need to ensure that User1 sees App1 from the My organization AppSource.
What should you do?
A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.
You need to ensure that User1 sees App1 from the My organization AppSource.
What should you do?
6.
You have a sales report in an app workspace. The report displays a map of sales by location and a bar chart of sales by year. The report has a slicer to filter the data by year.
You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year.
What should you do?
You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year.
What should you do?
7.
You create a report in the Power BI service.
You plan to provide external users with access to the report by publishing the report to a public blog.
You need to ensure that the report in the blog post will be updated as the data is refreshed.
What should you do in the Power BI service?
You plan to provide external users with access to the report by publishing the report to a public blog.
You need to ensure that the report in the blog post will be updated as the data is refreshed.
What should you do in the Power BI service?
8.
You have a Power BI model that contains the following two tables:
Assets (AssetID, AssetName, Purchase_DateID, Value)
Date (DateID, Date, Month, Week, Year)
The tables have a relationship. Date is marked as a date table in the Power BI model.
You need to create a measure to calculate the percentage that the total assets value increased since one year ago.
Which DAX formula should you use?
Assets (AssetID, AssetName, Purchase_DateID, Value)
Date (DateID, Date, Month, Week, Year)
The tables have a relationship. Date is marked as a date table in the Power BI model.
You need to create a measure to calculate the percentage that the total assets value increased since one year ago.
Which DAX formula should you use?
9.
You need to create a dashboard in the Power BI service to display data from a PubNub source.
What should you do?
What should you do?
10.
Your company has a custom line-of-business application named SalesApp.
The developers of SalesApp want to push data into the Power BI service to create several visualizations.
You need to ensure that the developers can push the data from SalesApp to the Power BI service.
What should you do?
The developers of SalesApp want to push data into the Power BI service to create several visualizations.
You need to ensure that the developers can push the data from SalesApp to the Power BI service.
What should you do?