Download Analyzing and Visualizing Data with Microsoft Power BI.certkiller.70-778.2019-02-05.1e.73q.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.certkiller.70-778.2019-02-05.1e.73q.vcex
Size 2.95 Mb
Posted February 05, 2019
Downloads 66


How to open VCEX & EXAM Files?

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

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator
 
 


Demo Questions

Question 1
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.
Correct Answer: C
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview



Question 2
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"
Correct Answer: A
References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter



Question 3
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: Pin the line chart to a dashboard.
  • B: Pin the KPI to a dashboard.
  • C: Embed the report into a Microsoft SharePoint page.
  • D: Pin the report to a dashboard.
Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-tile-from-report



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

  • A: Subscriptions
  • B: Workbooks
  • C: Dashboards
  • D: Datasets
Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured-questions



Question 5
You have an app workspace named Retail Store Analysis in the Power BI service. 
You need to manage the members that have access to the app workspace using the least amount of administrative effort. 
What should you do?

  • A: From the Office 365 Admin center, click Users.
  • B: From the Power BI Admin portal, click Tenant settings.
  • C: From the Power BI Admin portal, click Usage metrics.
  • D: From the Office 365 Admin center, click Groups.
Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365



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

  • A: From the properties of each dashboard, modify the Share dashboard settings.
  • B: From Microsoft Azure PowerShell, run the Set-MsolDomain cmdlet.
  • C: Instruct each user to install Microsoft Office 2016.
  • D: From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet.
Correct Answer: D
References:
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 7
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.
Correct Answer: C
References: https://docs.microsoft.com/en-us/power-bi/publisher-for-excel



Question 8
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
Correct Answer: A
References: http://ppmworks.com/sorting-month-names-chronologically-in-microsoft-power-bi-reports/



Question 9
You are creating a report in Power BI Desktop. 
You are consuming the following tables. 

  

You have a new table named Fiscal that has the same schema as the Date table, but contains the fiscal dates of your company. 
You need to create a report that displays the total sales by fiscal month and calendar month. 
What should you do?

  • A: Union Fiscal and Date as one table.
  • B: Add Fiscal to the model and create a one-to-many relationship by using Date[Year] and Fiscal[Year].
  • C: Add Fiscal to the model and create a one-to-one relationship by using Date[Year] and Fiscal[Year].
  • D: Merge Fiscal into the Date table.
Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data



Question 10
You plan to create a Power BI report. You have the schema model shown in the exhibit. 

  

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).
Correct Answer: C
References: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-admin-rls/






CONNECT US


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