Microsoft Analyzing and Visualizing Data with Power BI - 70-778 Exam Practice Test
You create a report in the Power BI service that displays the following visualizations:
* A KPI that displays the count of customers
* A table that displays the count of customers by country
* A line chart that displays the count of customers by year
You need to receive an alert when the total number of customers reaches 10,000.
What should you do first?
* A KPI that displays the count of customers
* A table that displays the count of customers by country
* A line chart that displays the count of customers by year
You need to receive an alert when the total number of customers reaches 10,000.
What should you do first?
Correct Answer: D
Vote an answer
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. (Click the Exhibit tab.)
You need to ensure that the map displays the country locations.
What should you do?
The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)
You need to ensure that the map displays the country locations.
What should you do?
Correct Answer: F
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Note: This question is a 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 Replace Errors.
Does this meet the goal?
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 Replace Errors.
Does this meet the goal?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify from the Power BI Settings?
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify from the Power BI Settings?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
Correct Answer: A
Vote an answer
Note: This question is a 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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains two columns named Date and Time.
The tables have the following relationships:
* Sales [DueDate] and Date [Date]
* Sales [ShipDate] and Date [Date]
* Sales [OrderDate] and Date [Date]
The active relationship is on Sales [DueDate].
You need to create measures to count the number of orders by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any additional data.
Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.
Does this meet the goal?
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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains two columns named Date and Time.
The tables have the following relationships:
* Sales [DueDate] and Date [Date]
* Sales [ShipDate] and Date [Date]
* Sales [OrderDate] and Date [Date]
The active relationship is on Sales [DueDate].
You need to create measures to count the number of orders by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any additional data.
Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.
Does this meet the goal?
Correct Answer: A
Vote an answer
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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.
The tables have the following relationships:
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.
Does this meet the goal?
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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.
The tables have the following relationships:
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.
Does this meet the goal?
Correct Answer: A
Vote an answer
You have two tables named CustomerVisits and Date in a Power BI model.
You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit.)
You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.
You need to fix the report to display the correct data for each month.
What should you do?
You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit.)
You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.
You need to fix the report to display the correct data for each month.
What should you do?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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 solution must preserve all the data.
What should you do?
You pivot the columns as shown in the following exhibit.
You need to resolve the error in row 3. The solution must preserve all the data.
What should you do?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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 goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You implement the Power BI model.
You plan to add a table named Date to the model. The table will have columns for the date, year, month, and end of the last month, and will include data from January 1, 2013 to December 31, 2015.
The Date table and the Sales table will have a relationship.
Which DAX functions should you use to create the columns?
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You implement the Power BI model.
You plan to add a table named Date to the model. The table will have columns for the date, year, month, and end of the last month, and will include data from January 1, 2013 to December 31, 2015.
The Date table and the Sales table will have a relationship.
Which DAX functions should you use to create the columns?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have a workspace that contains 10 dashboards. A dashboard named Sales Data from two datasets.
You discover that users are unable to find data on the dashboard by using natural language queries.
You need to ensure that the users can find data by using natural language queries.
What should you do?
You discover that users are unable to find data on the dashboard by using natural language queries.
You need to ensure that the users can find data by using natural language queries.
What should you do?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).