70-778 Exam Questions

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

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

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

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

You have a table in Power BI Desktop as shown in the following exhibit. You pivot the columns as shown in the following exhibit. You need to resolve the error in row 3. The solutio...

You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.) The file is in c:\data\. You need to...

You have two tables named Customer and Orders. A sample of the Data in Customer is shown in the following table. A sample of the data in Orders is shown in the following table. You...

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

You have a Power BI Desktop project that has the model shown in the exhibit. (Click the Exhibit tab.) Customer Count is a measure that uses the CountRows function to calculate the...

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

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 present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You have the following table named Location. The GeoCode column represents the country where each customer is located. You create a map visualization as shown in the exhibit. (Clic...

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