70-778 Exam Questions

You plan to deploy a Power BI app workspace that will be viewed by 10,000 users. You need to ensure that dashboard data can be updated every 30 minutes. What should you do?

You have a Power BI model that contains the following two tables: Sales (Sales_ID, DateID, sales_amount) Date(DateID, Date, Month, Week, Year) The tables have a relationship. You n...

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns: CustomerI...

You have a table named Sales that contains sales data for the United States. A sample of the data in Sales is shown in the following table. When you attempt to create a map that sh...

You have the following tables. There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date[Date]. The Cross filter direction of the relatio...

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 cat...

You have a Power Pivot model that includes a KPI. You need to create a visualization based on the Power Pivot model as shown in the exhibit. Which type of visualization should you...

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...

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...

You have a Power BI model that has a date table. A sample of the data shown in the following table. You need to add a column to display the date in the format of December 01, 2014....

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 q...

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 q...

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 q...

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 q...

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 q...

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...

You have the visualization shown in the following exhibit. You need to display the values as shown in the following exhibit. What should you do?

You have a service published to a website. When you connect to the website, you receive the following data. You need to create a query that retrieves the Categories data and the Cu...

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 c...

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 th...

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,...

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...

Your organization has a Microsoft Office 365 subscription. When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. You need to e...

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 nee...

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 th...

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 m...

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....

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. Yo...

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 t...

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 s...

You create a report in the Power BI service. You plan to provide external users with access to the report in the blog post will be updated as the data is refreshed. What should you...

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 dashb...

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 relat...

You need to create a dashboard in the Power BI service to display data from a PubNub source. What should you do?

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...

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 q...

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 q...

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 q...

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 t...

From the Home tab in Power BI Desktop, you click Enter Data and create a table named Sales that contains the following data. You add Region and Sales to visualization and the visua...

You have a table named Sales. A sample of the data in Sales is shown in the following table. You create a stacked column chart visualization that displays ProductName by Date. You...

You need to create a custom visualization for Power BI. What should you install first?

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 t...

You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit. You need to ensure that when you click the bar of a country,...

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...

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 publis...

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...