Microsoft Analyzing and Visualizing Data with Power BI - 070-778 Exam Practice Test
Question 1
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 a visualization and the visualization displays the following data.
What causes the visualization to display four rows of data instead of six?
You add Region and Sales to a visualization and the visualization displays the following data.
What causes the visualization to display four rows of data instead of six?
Correct Answer: D
Question 2
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.
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.
Correct Answer: C,D,E
Question 3
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?
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?
Correct Answer: A
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 4
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: C
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 5
You have the following two tables:
* Subscriber (SubscriberlD, Enroll mentDate, ServicePlan)
* Date (Date, Month, Week, Year)
There is a relationship between Subscriber [EnrollmentDate] and Date[Date].
You plan to create a KPI for the number of subscribers enrolled in the current year.
You need to create a goal that is five percent more than the number of subscribers enrolled during the previous calendar year.
How should you complete the DAX formula? To answer, drag the appropriate values to the correct targets.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
* Subscriber (SubscriberlD, Enroll mentDate, ServicePlan)
* Date (Date, Month, Week, Year)
There is a relationship between Subscriber [EnrollmentDate] and Date[Date].
You plan to create a KPI for the number of subscribers enrolled in the current year.
You need to create a goal that is five percent more than the number of subscribers enrolled during the previous calendar year.
How should you complete the DAX formula? To answer, drag the appropriate values to the correct targets.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
CALCULATE
COUNT
PREVIOUSYEAR
References:
https://msdn.microsoft.com/en-us/library/hh272049(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/ee634770.aspx
Question 6
You have a Microsoft Excel spreadsheet that contains a table named Sales.
You need to add the Sales table to a Power BI dashboard as a tile.
How should you configure the tile?
You need to add the Sales table to a Power BI dashboard as a tile.
How should you configure the tile?
Correct Answer: B
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 7
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 user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Microsoft Office 365 Admin center, you modify the properties of Contoso PowerBI.
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 user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Microsoft Office 365 Admin center, you modify the properties of Contoso PowerBI.
Does this meet the goal?
Correct Answer: B
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 8
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: B
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 9
You have a column named phone_number. The values in the columns are in one of the following formats:
* 999-999-9999x123
* 1-999-999-9999x232
* +1-999-999-9999x66x666
The values after x in the phone-number column indicate the phone extension.
You need to create a custom column in Query Editor that contains only the phone extensions.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
* 999-999-9999x123
* 1-999-999-9999x232
* +1-999-999-9999x66x666
The values after x in the phone-number column indicate the phone extension.
You need to create a custom column in Query Editor that contains only the phone extensions.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
References: https://msdn.microsoft.com/en-us/library/mt798301.aspx
Question 10
You have a Power BI report in an app workspace.
You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.
Which information should you provide to the application developers?
You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.
Which information should you provide to the application developers?
Correct Answer: D
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 11
You have the datasets shown in the following graphic.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
Note: Each selection is worth one point.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
Note: Each selection is worth one point.
Correct Answer:
Explanation
References:
https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming
http://radacad.com/integrate-power-bi-into-your-application-part-6-real-time-streaming-and-push-data
Question 12
You have a query that uses a Microsoft Excel data source. The data source contains the following table.
You need the data to appear as shown in the following table.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need the data to appear as shown in the following table.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Question 13
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 two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to ensure that all the visualization in the report can be consumed by users.
Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: D,E
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
