Download Analyzing Data with Microsoft Power BI.dump4pass.DA-100.2022-04-27.5e.138q.vcex

Download Exam

File Info

Exam Analyzing Data with Microsoft Power BI
Number DA-100
File Name Analyzing Data with Microsoft Power BI.dump4pass.DA-100.2022-04-27.5e.138q.vcex
Size 31.01 Mb
Posted April 27, 2022
Downloads 82

How to open VCEX & EXAM Files?

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

Coupon: EXAM_HUB

Discount: 20%


Demo Questions

Question 1
You need to create a calculated column to display the month based on the reporting requirements.  
Which DAX expression should you use?  

  • A: FORMAT('Date'[date], "MMMYYYY")
  • B: FORMAT('Date' [date], "MYY") 
  • C: FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year],"#")
  • D: FORMAT('Date' [date_id], "MMMYYYY")

Question 2
You need to review the data for which there are concerns before creating the data model.  
What should you do in Power Query Editor?

  • A: Transform the sales_amount column to replace negative values with0.
  • B: Select Columndistribution.
  • C: Select the sales_amount column and apply a numberfilter. 
  • D: Select Column profile, and then select the sales_amountcolumn.

Question 3
What is the minimum number of Power BI datasets needed to support the reports?

  • A: two importeddatasets
  • B: a single DirectQuerydataset
  • C: two DirectQuerydatasets
  • D: a single importeddataset

Question 4
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.    
You build a report analyzing the internal networks of employees based on whom they send emails to.    
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.    
What should you do?

  • A: Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
  • B: Remove the Subject and Body columns during theimport.
  • C: From Model view, set the Subject and Body columns toHidden.

Question 5
You have the tables shown in the following table.  

The Impressions table contains approximately 30 million records per month.  
You need to create an ad analytics system to meet the following requirements: 
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.  
Minimize the data model size.    
Which two actions should you perform? Each correct answer presents part of the solution.  
NOTE: Each correct selection is worth one point. 

  • A: Group the impressions by Ad_id, Site_name, and Impression_date. 
    Aggregate by using the CountRowsfunction.
  • B: Create one-to-many relationships between thetables.
  • C: Create a calculated measure that aggregates by using the COUNTROWSfunction.
  • D: Create a calculated table that contains Ad_id, Site_name, andImpression_date.

Question 6
Your company has training videos that are published to Microsoft Stream.  
You need to surface the videos directly in a Microsoft Power BI dashboard.  
Which type of tile should you add?

  • A: video
  • B: custom streamingdata
  • C: textbox
  • D: webcontent

Question 7
You open a query in Power Query Editor.    
You need to identify the percentage of empty values in each column as quickly as possible.  
Which Data Preview option should you select?

  • A: Show whitespace
  • B: Columnprofile
  • C: Columndistribution
  • D: Columnquality

Question 8
You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields: 
First name  
Last name  
Email address  
Phone number    
You import the list into Power Query Editor.    
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.    
Which two actions should you perform? Each correct answer presents part of the solution.    
NOTE: Each correct selection is worth one point.

  • A: Open the AdvancedEditor.
  • B: Select Columnquality.
  • C: Enable Column profiling based on entiredataset.
  • D: Select Columndistribution.
  • E: Select Columnprofile.

Question 9
You have an API that returns more than 100 columns. The following is a sample of column names.  
You plan to include only a subset of the returned columns.    
You need to remove any columns that have a suffix of sourceid.    
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.    
NOTE: Each correct selection is worth one point.

Question 10
You are building a dataset from a JSON file that contains an array of documents.    
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.  
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.



You can buy ProfExam with a 20% discount..

Get Now!


Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen


Use VCE Exam Simulator to open VCE files