24 December, 2019
[Dec-2019-25] Abreast Of The Times 70-778 Questions
Act now and download your Microsoft 70-778 test today! Do not waste time for the worthless Microsoft 70-778 tutorials. Download Down to date Microsoft Analyzing and Visualizing Data with Microsoft Power BI (beta) exam with real questions and answers and begin to learn Microsoft 70-778 with a classic professional.
Question 1
You plan to embed multiple visualization in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.
Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.
NOTE: Each correct selection is worth one point.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.
Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.
NOTE: Each correct selection is worth one point.
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.
Question 3
You are configuring the relationships between the following tables.
A customer can have multiple accounts. An account can only be associated to one customer. Each account is associated to only one insurance policy.
You need to configure the relationships between the tables to ensure that you can create a report displaying customers and their associated insurance policies.
How should you configure each relationship? To answer, drag the appropriate cardinalities to the correct relationships. 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.
Solution:
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Does this meet the goal?
A customer can have multiple accounts. An account can only be associated to one customer. Each account is associated to only one insurance policy.
You need to configure the relationships between the tables to ensure that you can create a report displaying customers and their associated insurance policies.
How should you configure each relationship? To answer, drag the appropriate cardinalities to the correct relationships. 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.
Solution:
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Does this meet the goal?
Question 4
You have sales data in a spreadsheet named Sales.xlsx.
You need to provide a detailed sales report to several managers.
From the Power BI service, you create an app workspace named SalesWorkspace.
Which three actions should you perform in sequence next? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Solution:
References:
https://docs.microsoft.com/en-us/power-bi/service-report-create-new https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps
Does this meet the goal?
You need to provide a detailed sales report to several managers.
From the Power BI service, you create an app workspace named SalesWorkspace.
Which three actions should you perform in sequence next? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Solution:
References:
https://docs.microsoft.com/en-us/power-bi/service-report-create-new https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps
Does this meet the goal?
Question 5
In the Power BI service, you create an app workplace that contains several dashboards.
You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards. What should you do?
You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards. What should you do?
Question 6
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.
Question 7
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?
Question 8
You plan to create a report in Power BI Desktop. You have the following tables.
You have a measure that uses the following DAX formula. Total Sales = SUM('Sales'[SalesAmount])
You plan to create a report to display TotalSales by ProductCategory and ProductSubCategory. You need to create a measure to calculate the percentage of TotalSales for each ProductCategory.
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.
Solution:
References:
https://support.office.com/en-us/article/when-to-use-calculated-columns-and-calculated-fields-ca18d63a-5b6d-4
Does this meet the goal?
You have a measure that uses the following DAX formula. Total Sales = SUM('Sales'[SalesAmount])
You plan to create a report to display TotalSales by ProductCategory and ProductSubCategory. You need to create a measure to calculate the percentage of TotalSales for each ProductCategory.
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.
Solution:
References:
https://support.office.com/en-us/article/when-to-use-calculated-columns-and-calculated-fields-ca18d63a-5b6d-4
Does this meet the goal?
Question 9
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. (Click the Exhibit button.)
Which type of visualization should you use?
You need to create a visualization based on the Power Pivot model as shown in the exhibit. (Click the Exhibit button.)
Which type of visualization should you use?
Question 10
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.
Solution:
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
Does this meet the goal?
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.
Solution:
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
Does this meet the goal?
Question 11
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.
Solution:
References: https://msdn.microsoft.com/en-us/library/mt798301.aspx
Does this meet the goal?
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.
Solution:
References: https://msdn.microsoft.com/en-us/library/mt798301.aspx
Does this meet the goal?
Question 12
You have the following tables.
You need to create a new table that displays the top 10 customers by the total of SalesAmount.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Solution:
References: https://msdn.microsoft.com/en-us/library/gg492198.aspx
Does this meet the goal?
You need to create a new table that displays the top 10 customers by the total of SalesAmount.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Solution:
References: https://msdn.microsoft.com/en-us/library/gg492198.aspx
Does this meet the goal?
Question 13
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.
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 use name 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?
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 use name 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?
Question 14
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 User!. User1 is a member of a security group named Contoso PowerB1. 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 Power B1 Admin portal, you modify the Tenant settings.
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 User!. User1 is a member of a security group named Contoso PowerB1. 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 Power B1 Admin portal, you modify the Tenant settings.
Question 15
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
Access a published Power BI app
Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Solution:
References:
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace
Does this meet the goal?
Access a published Power BI app
Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Solution:
References:
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace
Does this meet the goal?
Question 16
You are creating a report in Power BI Desktop. You are consuming the following tables.
Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNumber] is in the mm format. Date[MonthName] is in the mmm format.
You create the report shown in the exhibit. (Click the Exhibit button.)
You need to ensure that the months appear in the order of the calendar. How should you sort the MonthName column?
Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNumber] is in the mm format. Date[MonthName] is in the mmm format.
You create the report shown in the exhibit. (Click the Exhibit button.)
You need to ensure that the months appear in the order of the calendar. How should you sort the MonthName column?
Question 17
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 ensure that you can publish the file to Power BI. What should you do first?
The file is in c:\data\.
You need to ensure that you can publish the file to Power BI. What should you do first?
Question 18
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, only the values for that country are shown on the Revenue by Year and Manufacturer chart.
You need to ensure that when you click the bar of a country, only the values for that country are shown on the Revenue by Year and Manufacturer chart.
Question 19
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 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?
Question 20
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 relationship is set to Single.
You plan to create a column chart that displays the following two measures:
Count of SubscriberID by Month based on the StartDate
Count of SubscriberID by Month based on the EndDate What should you do before you create the measures?
There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date[Date]. The Cross filter direction of the relationship is set to Single.
You plan to create a column chart that displays the following two measures:
Count of SubscriberID by Month based on the StartDate
Count of SubscriberID by Month based on the EndDate What should you do before you create the measures?
Question 21
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?
Question 22
You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data.
Which data source you should use?
Which data source you should use?
Question 23
Note: This question is a part of a series of questions that present 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 contains the following tables.
The following columns contain data information:
Date[Month] in the mmyyyy format
Date[Date_ID] in the ddmmyyyy format
Date[Date_name] in the mm/dd/yyyy format
Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI desktop to create an analytics solution for the data. End of repeated scenario.
You need to display the month as a three-letter abbreviation, followed by the year, such as jan2017. You add a calculated column in Power BI.
Which DAX formula should you use for the calculated column? 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 bat between panes or scroll to view continent.
NOTE: Each correct selection is worth one point.
Solution:
CONCATENATE MMM
References: https://msdn.microsoft.com/en-us/library/ee634811.aspx
Does this meet the goal?
Start of repeated scenario
You have a Microsoft SQL Server database that contains the following tables.
The following columns contain data information:
Date[Month] in the mmyyyy format
Date[Date_ID] in the ddmmyyyy format
Date[Date_name] in the mm/dd/yyyy format
Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI desktop to create an analytics solution for the data. End of repeated scenario.
You need to display the month as a three-letter abbreviation, followed by the year, such as jan2017. You add a calculated column in Power BI.
Which DAX formula should you use for the calculated column? 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 bat between panes or scroll to view continent.
NOTE: Each correct selection is worth one point.
Solution:
CONCATENATE MMM
References: https://msdn.microsoft.com/en-us/library/ee634811.aspx
Does this meet the goal?