Download Analyzing and Visualizing Data with Microsoft Power BI.PracticeTest.70-778.2019-03-28.1e.74q.vcex


Download Exam

File Info

Exam Analyzing and Visualizing Data with Microsoft Power BI
Number 70-778
File Name Analyzing and Visualizing Data with Microsoft Power BI.PracticeTest.70-778.2019-03-28.1e.74q.vcex
Size 3.73 Mb
Posted March 28, 2019
Downloads 140



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


 
 



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 measures that use the CALCULATE, COUNT, and FILTER DAX functions.
Does this meet the goal?

  • A: Yes
  • B: No



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

  • A: Yes
  • B: No



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 PowerBI setting, you modify the Developer Settings.
Does this meet the goal?

  • A: Yes
  • B: No



Question 4
You plan to embed multiple visualizations 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 solution. 
NOTE: Each correct selection is worth one point.

  • A: Visual 1
  • B: Visual 2
  • C: Visual 3
  • D: Visual 4
  • E: Visual 5



Question 5
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?

  • A: From the settings of the workspace, modify the Language Settings.
  • B: From the Sales Data dashboard, set the dashboard as a Favorite.
  • C: From the properties of the datasets, modify the Q&A and Cortana settings.
  • D: From the properties of the dashboard, modify the Q&A settings.



Question 6
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?

  • A: Add the following filters to a report. 
    CountryRegionName is United States 
    ProductCategory is Clothing
  • B: From Power BI Desktop, create a new role that has the following filters. 
    [CountryRegionName] = "United States" 
    [ProductCategory] = "Clothing"
  • C: Add the following filters in Query Editor. 
    CountryRegionName is United States 
    ProductCategory is Clothing
  • D: From Power BI Desktop, create a new role that has the following filter. 
    [CountryRegionName] = "United States" && [ProductCategory] = "Clothing"



Question 7
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 form the Power BI Settings?

  • A: Subscriptions
  • B: Workbooks
  • C: Dashboards
  • D: Datasets



Question 8
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?

  • A: From the Power BI service, import the data from the Excel workbook.
  • B: From Excel, publish the workbook to the Power BI service.
  • C: From the Power BI tab in Excel, pin the table.
  • D: From the Power BI service, upload the Excel workbook.



Question 9
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?

  • A: by MonthNumber
  • B: ascending
  • C: descending
  • D: by DateKey



Question 10
You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.) 

  

The model has the following relationships:
Store to District based on DistrictID 
Sales to Store based on LocationID 
Sales to Date based on PeriodID 
Sales to Item based on ItemID 
You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage. 
When the district managers view the Store by Items report, they see items for all the stores. 
You need to ensure that the district managers can see items for the stores they manage only. 
How should you configure the relationship from Sales to Item?

  • A: Select Assume Referential Integrity.
  • B: Change the Cardinality to One to Many (1:*).
  • C: Change the Cross filter direction to Both.
  • D: Change the Cardinality to One to one (1:1).








ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset