70-778 Microsoft Power BI Practice Questions
You need to create a dashboard in the Power BI service to display data from a PubNub source. What should you do? a. Add a Microsoft SQL Server Analysis Services (SSAS) data source that uses Connect live and create a report. Pin the report to a dashboard b. Add a custom streaming data tile to a dashboard c. Create an app workspace and publish the workspace to a dashboard d. Add a Microsoft Azure SQL database data source that uses DirectQuery and create a report. Pin the report to a dashboard
b. Add a custom streaming data tile to a dashboard
You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use? a. PREVIOUSYEAR b. TOTALYTD c. LASTDATE d. DATEADD e. SAMEPERIODLASTYEAR
e. SAMEPERIODLASTYEAR
You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart. The date value in ActivityDate is a number column named DateID. DateID is in the YYYYMMDD format. What should you do in the model before you create the relationship? a. Create a calculated column in ActivityLog that uses the FORMAT DAX function b. Create a measure in ActivityLog that uesed the FORMAT DAX function c. Change the Data Type of DateID to Date d. Change the Data Type of ActivityStart to Date
a. Create a calculated column in ActivityLog that uses the FORMAT DAX function
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? a. go to dev.powerbi.com/apps and register an application b. go to app.powerbi.com and create an app workspace c. go to portal.azure.com and create a web app d. go to app.powerbi.com/admin-portal and click Publish to web
a. go to dev.powerbi.com/apps and register an application
Your company has several developers who plan to create custom solutions that will interact with the API for the Power BI service. Which three operations can the developers achieve by using the API? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. a. Retrieve rows from a dataset b. Add rows to a dataset c. Refresh an imported dataset d. Create a dataset e. Add a member to a row-level security role
a. Retrieve rows from a dataset b. Add rows to a dataset d. Create a dataset
You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use? a. DATEADD b. DATESYTD c. TOTALYTD d. ENDOFYEAR
b. DATESYTD
In the Power BI service, you create an app workspace that contains several dashboards. You need to provide a user named [email protected] with the ability to edit and publish dashboards. What should you do? a. Share the dashboard, and the modify the Access settings of the dashboard b. Configure security for the dataset used by the app c. From the app workspace, click Update app, and then configure the Access settings d. Modify the members of the app workspace
a. Share the dashboard, and the modify the Access settings of the dashboard
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? a. (sum(Assest[Value])Calculate(sum(Assets[Value]),SAMEPERIODLASTYEAR(Date[Date])))/CALCULATE(sum(Assets[Value])),SAMEPERIODLASTYEAR(Date[Date]))) b. CALCULATE(sum(Assets[Value]),DATESYTD(Date[Date]))/(sum(Assets[Value]) c. CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR(Date[Date])))/(sum(Assets[Value]) d. (sum(Assets[Value])CALCULATE(sum(Assets[Value])), SAMEPERIODLASTYEAR(Dat[Date])))/
d. (sum(Assets[Value])CALCULATE(sum(Assets[Value])), SAMEPERIODLASTYEAR(Dat[Date])))/
You have an app workspace that contains two datasets named dataset1 and dataset2. Dataset1 connects to a Microsoft Azure SQL database. Dataset2 connects to a Microsoft Excel file stored in Microsoft OneDrive for Business. You create a report named Report1 that uses dataset1. You pin Report1 to a dashboard named Dashboard1. You publish the app workspace to all the users in your organization. You need to delete dataset2 from the app workspace. What should you do first? a. Unpublish the app b. Configure the refresh settings for Dataset2 c. Delete Report1 d. Delete Dashboard1
a. Unpublish the app
You need to create a custom visualization for Power BI. What should you install first? a. Node.js b. jQuery c. Microsoft Azure PowerShell d. Microsoft.NET
a. Node.js
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power BI service. Solution: From the Power BI service, get the data from SharePoint Online, and then click Import. Does this meet the goal?
yes
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a query for a table named Sales. Sales has a column named CustomerID. The Data Type of CustomerID is Whole Number. You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values. You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column. Click Replace Errors… and enter a value of 0 Does this meet the goal?
yes
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an app workspace that contains a report. The report contains sensitive data. You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses. Solution: Purchase Power BI Premium P1, and then configure the app workspace to run in a dedicated capacity. Does this meet the goal?
yes
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. Your company has 1,000 users in a Microsoft Office 365 subscription. A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users. You discover that a user named User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards. Solution: From the properties of each dashboard, you modify the Share settings. Does this meet the goal?
yes
A data analyst publishes several Power BI visualizations to a blog. You discover that some of the visualizations contain data that is considered private by your company. You need to prevent the visualizations from being published to the blog. What should you do? a. From the Power BI Admin portal. disable the Publish to web setting b. From the dashboard settings, modify the Share dashboard settings c. From the Power BI Admin portal, diable the Share content with external users setting d. From the Power BI settings, delete the embedded codes
a. From the Power BI Admin portal. disable the Publish to web setting
You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database. From Power BI Desktop, you can query the database. When you publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should you do to resolve the issue? a. Install the on-premises data gateway and configure a data source b. Install the on-premises data gateway (personal mode) and republish the project c. Locate the published dataset for the project in the Power BI service and configure the data source credentials d. Configure a Microsoft Azure ExpressRoute connection between the on-premises network and the Power BI service
a. Install the on-premises data gateway and configure a data source
You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular database named SalesDB in Microsoft SQL Server Analysis Services (SSAS). The report will be published to the Power BI service. You need to ensure that the report published to the Power BI service will access the current data in SalesDB. What should you do? a. Deploy an on-premises data gateway and configure the connection to Sales DB to use the DirectQuery Data Connectivity mode b. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live option c. Deploy an on-premises data gateway (personal mode) and configure the connection to SalesDB to use the DirectQuery Data Connectivity mode d. Deploy an on-premises data grateway and configure the connection to SalesDB to use the Import Data Connectivity mode
b. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live option
You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization. The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data. You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source? a. Deploy an on-premises data gateway (personal mode). Connect to the data by using the Connect live option b. Deploy an on-premises data gateway. Connect to the data by using the Connect live option c. Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Data Connectivity mode d. Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode
b. Deploy an on-premises data gateway. Connect to the data by using the Connect live option
You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category. You need to ensure that when you select a year on the bar chart, the donut chart remains unchanged. What should you do? a. Set a visual level filter on the donut chart b. Edit the interactions from the Format menu c. Add a slicer to the page that uses the year column d. Set a visual level filter on the bar chart
b. Edit the interactions from the Format menu
You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd. You create a new Power BI Desktop model that uses 120 tables from SQLDev. You plan to publish the Power BI file to the Power BI service. You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort. What should you do from Query Editor before you publish the model? a. Delete the existing queries, and then add new data sources b. Edit the source of each table query c. Create a new connection to SQLProd and then import the table from SQLProd d. Configure the Data source settings
b. Edit the source of each table query
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? a. Configure drillthrough filters for each bar chart, and then select Selection Pane b. Filter the bar charts by using the slicer, then create bookmarks c. Configure page level filters, then crate groups that use the Bin group type d. Configure report level filters, and then create groups that use the List group type
b. Filter the bar charts by using the slicer, then create bookmarks
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. From the app workspace, share the dashboard b. From the app workspace, click Update app, configure the Access setting, and the click Update app c. From the app workspace, click Update app, configure the Content settings, and then click Update app d. From the app workspace, add a member
b. From the app workspace, click Update app, configure the Access setting, and the click Update app
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server. You need to ensure that all the visualization in the report can be consumed by users. Which three types of visualizations should you include in the report? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. a. breadcrumbs b. custom visuals c. funnel charts d. bubble maps e. R visuals
b. custom visuals c. funnel charts d. bubble maps
You have a Power BI report that is configured to use row-level security (RLS). You have the following roles: ✑ A manager role that limits managers to see only the sales data from the stores they manage ✑ A region role that limits users to see only the data from their respective region You plan to use Power BI Embedded to embed the report into an application. The application will authenticate the users. You need to ensure that RLS is enforced when accessing the embedded report. What should you do? a. From dev.powerbi.com/apps, register the new application and enable the Read All Groups API access b.In the access token for the application, include the user name and the role name c. In the access token for the application, include the report URL and the Microsoft Azure Active Directory domain name d. From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access
b.In the access token for the application, include the user name and the role name
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? a. Add a folder data source and use the Merge Queries command b. Add a Microsoft Excel data source and use the Merge Queries comand c. Add a folder data source and use the Combine Files command d. Add test/CSV data sources and use the Append Queries command
c. Add a folder data source and use the Combine Files command
You have the following two queries in Power BI Desktop: ✑ A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database ✑ A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle Server database Both tables have the same columns. You need to combine the data from SMB_Customers and Enterprise_Customers. Which command should you use? a. Merge Queries b. Merge Columns c. Append Queries d. Combine Files
c. Append Queries
You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source? a. Deploy an on-premises data gateway (personal mode). Connect to the data by using the Connect live option b. Deploy an on-premises data gateway. Connect to the data by using the Connect live option c. Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Data Connectivity mode d. Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode
c. Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Data Connectivity mode
You are importing sales data from a Microsoft Excel file named Sales.xlsx into Power BI Desktop. You need to create a bar chart showing 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 need to modify the query to ensure that the data appears correctly. What should you do? a. Delete the query. Import the data into Microsoft SQL Server, and then import the data from SQL Server b. Change the Data Type of sales amount column to Numeric c. In Query Editor, add a calculated column that totals the sales amount column d. Refresh the data model
c. In Query Editor, add a calculated column that totals the sales amount column
Your company has a security policy stating that proprietary data must not be transferred over the Internet. During a security audit, auditors discover that executives use the Power BI service for reporting. You need to recommend a solution to ensure that the company adheres to the security policy. What should you include in the recommendation? a. a site-to-site VPN to Microsoft Azure b. Microsoft SQL Server column encyption c. Microsoft Azure ExpressRoute d. the on-premises gateway for Power BI
c. Microsoft Azure ExpressRoute
You create a KPI visualization in Power BI Desktop that uses the month as the trend axis. You discover that the data is not sorted by month. You need to change the sort order of the visualization. What should you do first? a. Modify the visual level filters b. Modify the drillthrough filters c. Remove the trend axis from the visualization d. Convert the visualization to a different type
c. Remove the trend axis from the visualization
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? a. Add a page level filter, and then pin each visualization to the dashboard b. Publish the app workspace c. Pin each visualization to the dashboard, and then add a web content tile d. Pin the report as a live page
d. Pin the report as a live page
You embed a Power BI report in a Microsoft SharePoint Online page. A user named User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: “This content isn’t available.†User1 is unable to view the report. You verify that you can access the SharePoint Online page and that the Power BI report displays as expected. You need to ensure that User1 can view the report from SharePoint Online. What should you do? a. Modify the members of the app workspace b. Edit the settings of the Power BI web part c. Share the dashboard in the app workspace d. Publish the app workspace
d. Publish the app workspace
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? a. Share the report. In the blog post, use the URL of the dashboard b. In the blog post, use the URL of the report c. Publish the app workspace to the entire organization. In the blog post, use the URL of the workspace d. Publish the report to the web. In the blog post, use the embed code URL
d. Publish the report to the web. In the blog post, use the embed code URL
You create a dashboard that displays the results of a customer satisfaction survey. You need to embed a tweet from your company’s Twitter feed into the dashboard. What should you do? a. To the dashboard, add a tile that uses a PubNub content source b. Edit the report and import a visualization from the marketplace. Pin the visualization to the dashboard c. Edit the report and import a visualization from a file. Pin the visualization to the dashboard d. To the dashboard, add a tile that uses a web content source
d. To the dashboard, add a tile that uses a web content source
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power BI service. Solution: From Excel, click Publish to Power BI, and then click Export. Does this meet the goal?
no
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a query for a table named Sales. Sales has a column named CustomerID. The Data Type of CustomerID is Whole Number. You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values. You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column and click Remove Errors. Does this meet the goal?
no
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an app workspace that contains a report. The report contains sensitive data. You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses. Solution: Configure the app workspace to be read-only for members and to run in a shared capacity. Does this meet the goal?
no
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an app workspace that contains a report. The report contains sensitive data. You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses. Solution: From Publish to web, generate an iFrame. Does this meet the goal?
no
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. Your company has 1,000 users in a Microsoft Office 365 subscription. A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users. You discover that a user named User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards. Solution: From the Office 365 Admin center, you remove the Power BI license from User1. Does this meet the goal?
no
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. Your company has 1,000 users in a Microsoft Office 365 subscription. A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users. You discover that a user named User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards. Solution: From the Power BI Admin portal, you modify the Dashboard settings. Does this meet the goal?
no
