Download Analyzing and Visualizing Data with Microsoft Power BI.70-778.TestKing.2020-03-11.81q.vcex

Vendor: Microsoft
Exam Code: 70-778
Exam Name: Analyzing and Visualizing Data with Microsoft Power BI
Date: Mar 11, 2020
File Size: 3 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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:
  • 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 the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data. 
Solution: You create a calculated table. You create a measure that uses the new table.
Does this meet the goal?
  1. Yes
  2. No
Correct answer: B
Question 2
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:
  • 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 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?
  1. Yes
  2. No
Correct answer: B
Question 3
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 remove User1 from the All Users security group.
Does this meet the goal?
  1. Yes
  2. No
Correct answer: B
Question 4
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?
  1. Yes
  2. No
Correct answer: A
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365
References: https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365
Question 5
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 PowerBI setting, you modify the Developer Settings.
Does this meet the goal?
  1. Yes
  2. No
Correct answer: B
Question 6
You have a workspace that contains 10 dashboards. A dashboard named Sales Data displays 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?
  1. From the settings of the workspace, modify the Language Settings.
  2. From the Sales Data dashboard, set the dashboard as a Favorite.
  3. From the properties of the datasets, modify the Q&A and Cortana settings.
  4. From the properties of the dashboard, modify the Q&A settings.
Correct answer: C
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview
Question 7
You manage a Power BI model that has two tables named Sales and Product. 
You need to ensure that a sales team can view only data that has a CountryRegionName value of Unites States and a ProductCategory value of Clothing. 
What should you do from Power BI Desktop?
  1. Add the following filters to a report. 
    CountryRegionName is United States 
    ProductCategory is Clothing
  2. From Power BI Desktop, create a new role that has the following filters. 
    [CountryRegionName] = "United States" 
    [ProductCategory] = "Clothing"
  3. Add the following filters in Query Editor. 
    CountryRegionName is United States 
    ProductCategory is Clothing
  4. From Power BI Desktop, create a new role that has the following filter. 
    [CountryRegionName] = "United States" && [ProductCategory] = "Clothing"
Correct answer: A
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter
References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter
Question 8
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?
  1. Pin the line chart to a dashboard.
  2. Pin the KPI to a dashboard.
  3. Embed the report into a Microsoft SharePoint page.
  4. Pin the report to a dashboard.
Correct answer: D
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-tile-from-report
References: https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-tile-from-report
Question 9
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 ensure that all the users can access the Power BI service. 
What should you do first?
  1. From the Microsoft Azure Active Directory admin center, assign a Power BI (free) license to each user.
  2. Instruct each user to install Microsoft Office 2016.
  3. From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet.
  4. From the properties of each dashboard, modify the Share dashboard settings.
Correct answer: C
Explanation:
You need to run the following cmdlet: Set-MsolCompanySettings -AllowAdHocSubscriptions $trueReference:https://docs.microsoft.com/en-us/power-bi/service-admin-service-free-in-your-organization#enable-or-disable-individual-user-sign-up-in-azure-active-directory
You need to run the following cmdlet: Set-MsolCompanySettings -AllowAdHocSubscriptions $true
Reference:
https://docs.microsoft.com/en-us/power-bi/service-admin-service-free-in-your-organization#enable-or-disable-individual-user-sign-up-in-azure-active-directory
Question 10
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?
  1. From the Power BI service, import the data from the Excel workbook.
  2. From Excel, publish the workbook to the Power BI service.
  3. From the Power BI tab in Excel, pin the table.
  4. From the Power BI service, upload the Excel workbook.
Correct answer: C
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/publisher-for-excel
References: https://docs.microsoft.com/en-us/power-bi/publisher-for-excel
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!