Download Analyzing Data with Microsoft Power BI.dump4pass.DA-100.2021-03-15.1e.89q.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.2021-03-15.1e.89q.vcex
Size 8.39 Mb
Posted March 15, 2021
Downloads 56

How to open VCEX & EXAM Files?

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

Purchase
Coupon: EXAM_HUB

Discount: 20%

 
 



Demo Questions

Question 1
You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?

  • A: area chart
  • B: donut chart
  • C: scatter plot
  • D: pie chart



Question 2
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. 
City[State Province] = "Kentucky" 
Role2 contains the following filter. 
Date[Calendar Year] = 2020 
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

  • A: The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.
  • B: The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
  • C: The user will see only data for which the State Province value is Kentucky.
  • D: The user will receive an error and will not be able to see the data in the report.



Question 3
You are creating a quick measure as shown in the following exhibit. 

      

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. 
NOTE: Each correct selection is worth one point.




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 are deling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: You add a report-level filter that filters based on the order date. Does this meet the goal?

  • A: Yes
  • B: No



Question 5
You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design. 
What should you use?

  • A: Active Directory groups
  • B: tiles
  • C: data classifications
  • D: comments



Question 6
You create the following step by using Power Query Editor. = Table.ReplaceValue (SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

  • A: 1318
  • B: 1319
  • C: 21318 Lasalle Street
  • D: 21319 Lasalle Street



Question 7
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. 
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a percentile line by using the Salary measure and set the percentile to 50%. 
Does this meet the goal?

  • A: Yes
  • B: No



Question 8
You need to grant access to the business unit analysts. What should you configure? To answer, select the appropriate options in the answer area. 
NOTE: Each correct selection is worth one point.
 




Question 9
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the following format:2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. 
What should you do?

  • A: Change the data type of the Logged column to
  • B: Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
  • C: Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
  • D: Apply a transform to extract the first 11 characters of the Logged column.



Question 10
You plan to create the chart shown in the following exhibit. 

      

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period  hown?

  • A: Create a horizontal line that has a fixed value of 24,000.
  • B: Add a measure to the visual that uses the following DAX expression. 
    Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],.40)
  • C: Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
  • D: Add a measure to the visual that uses the following DAX expression. 
    Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)






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