No Installation Required, Instantly Prepare for the DA-100 exam and please click the below link to start the DA-100 Exam Simulator with a real DA-100 practice exam questions.
Use directly our on-line DA-100 exam dumps materials and try our Testing Engine to pass the DA-100 which is always updated.
- (Exam Topic 3)
Correct Answer:A - (Exam Topic 2)
Correct Answer:A - (Exam Topic 1)
Correct Answer:A - (Exam Topic 4)
Correct Answer:B - (Exam Topic 4)
Correct Answer:C
You need to create a measure that will return the percentage of late orders.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Solution:
Graphical user interface, application Description automatically generated
Box 1: CALCULATE
CALCULATE evaluates an expression in a modified filter context. Syntax: CALCULATE(
filter1, filter2,… (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.
Box 2: FILTER
FILTER returns a table that represents a subset of another table or expression. Syntax: FILTER(,
Table- The table to be filtered. The table can also be an expression that results in a table.
Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or [Region] = "France"
Box 3: Orders[ShippedDate]> Orders[RequiredDate]
Northwind Traders defines late orders as those shipped after the required shipping date. Reference:
https://docs.microsoft.com/en-us/dax/calculate-function-dax https://docs.microsoft.com/en-us/dax/filter-function-dax
Does this meet the goal?
Question 2
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.
Solution:
Box 1: The Viewer role to the workspace
The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can’t browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to “Members can only view Power BI content”.
Box 2: Build
The analysts must be able to build new reports from the dataset that contains the profit and loss data. Scenario: The reports must be made available to the board from powerbi.com.
The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.
Reference:
https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html
Does this meet the goal?
Question 3
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Solution:
Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: KPI
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
Box 2: Sales[sales_amount]
Box 3: Date[month]
Time > FiscalMonth. This value will represent the trend. Box 4: Targets[sales_target]
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
Does this meet the goal?
Question 4
In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset
You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data
What should you do?
Question 5
You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?
A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time – a time series – thus the line is often drawn chronologically.
Example:
Reference:
https://www.data-to-viz.com/graph/line.html