Pass Pl-300 Microsoft Data Analyst Associate Study Guide Exam Pdf Dumps
                      
  
 
 
 Microsoft
  
PL-300
 Microsoft Power BI Data Analyst
 
 
 
 
 
 
 
 
 
 
Questions And Answers PDF Format:  
 
For More Information – Visit link below: 
https://www.certsgrade.com/ 
 
Version = Product 
 
 
Visit us at https://www.certsgrade.com/pdf/pl-300/
 
Latest Version: 15.0  
 
Question: 1 
   
You need to address the data concerns before creating the data model. What should you do in Power 
Query Editor? 
 
A. Select Column distribution. 
B. Select the sales_amount column and apply a number filter. 
C. Select Column profile, and then select the sales_amount column. 
D. Transform the sales_amount column to replace negative values with 0. 
 
Answer: C     
 
Question: 2 
   
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], "MMM YYYY") 
B. FORMAT('Date' [date], "M YY") 
C. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#") 
D. FORMAT('Date' [date_id], "MMM YYYY") 
 
Answer: A     
 
Question: 3 
   
You need to create the required relationship for the executive's visual. What should you do before you 
can create the relationship? 
 
A. Change the data type of Sales[region_id] to Whole Number. 
B. In the Sales table, add a measure for sum(sales_amount). 
C. Change the data type of sales[sales_id] to Text. 
D. Change the data type of sales [region_id] to Decimal Number. 
 
Answer: A     
 
Explanation: 
Scenario: Executives require a visual that shows sales by region. 
Need to change the sales_id column from Varchar to Whole Number (Integer). 
Visit us at https://www.certsgrade.com/pdf/pl-300/
 
 
Question: 4 
   
What should you create to meet the reporting requirements of the sales department? 
 
A. a measure that uses a formula of SUM (Sales [sales_id]) 
B. a calculated column that use a formula of COUNTA(sales [sales_id]) 
C. a measure that uses a formula of COUNTROWS (Sales) 
D. a calculated column that uses a formula of SUM (Sales [sales_id]) 
 
Answer: C     
 
Explanation: 
The sale department requires reports that contain the number of sales transactions. 
The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an 
expression. 
Reference: 
https://docs.microsoft.com/en-us/dax/countrows-function-dax 
 
Question: 5 
   
You need to create a relationship between the Weekly_Returns table and the Date table to meet the 
reporting requirements of the regional managers. What should you do? 
 
A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd 
and use the calculated column to create a relationship to the Date table. 
B. Add the Weekly_Returns data to the Sales table by using related DAX functions. 
C. Create a new table based on the Date table where date-id is unique, and then create a many-to-many 
relationship to Weekly_Return. 
 
Answer: A 
 
Explanation: 
Scenario: Region managers require a visual to analyze weekly sales and returns. 
To relate the two tables we need a common column. 
 
Visit us at https://www.certsgrade.com/pdf/pl-300/
 
  
 
For More Information – Visit link below: 
https://www.certsgrade.com/ 
 
PRODUCT FEATURES 
 
  100% Money Back Guarantee 
 90 Days Free updates 
  Special Discounts on Bulk Orders 
  Guaranteed Success  50,000 Satisfied Customers 
  100% Secure Shopping 
 Privacy Policy 
  Refund Policy 
16 USD Discount Coupon Code: NB4XKTMZ 
 
 
 
Visit us at https://www.certsgrade.com/pdf/pl-300/
 
Powered by TCPDF (www.tcpdf.org)