Welcome to KillTest.com

TOP Exams

Want to practice some free Microsoft DA-100 exam questions? You can study the following Microsoft DA-100 exam online questions. Killtest provides 131 Q&As for Microsoft DA-100 exam, which has been proven effective in the DA-100 exam preparation. Besides, you can get full payment fee refund if you fail DA-100 exam by using Killtest DA-100 practice exam questions. Ready? Go!

 Get DA-100 with 131 Q&As

Microsoft DA-100 Online Practice Exam Questions

The questions of DA-100 were last updated on Sep 07,2021 .

Viewing page 1 out of 13 pages.

Viewing questions 1 out of 69 questions

Question#1

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization .
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Add the same slicer to each page and configure Sync slicers.
B. Edit the interactions of the KPI visualization.
C. Configure a page-level filter.
D. Edit the interactions of the slicer that is on the same page as the KPI visualization.
E. Configure a report-level filter.

Question#2

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 constant line and set the value to .5.
Does this meet the goal?

A. Yes
B. No

Explanation:
Instead create a percentile line by using the Salary measure and set the percentile to 50%.
Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Refence: https://dash-intel.com/powerbi/statistical_functions_percentile.php

Question#3

You have the dataset shown in the following exhibit.



You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?

A. Add a Top N filter to the visual.
B. Configure the Sales Profit measure to use the RANKX function.
C. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
D. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.

Explanation:
Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.
Note:
✑ Select the Column you want to display the Top Sales Profit
✑ Then change the Filter Type of that Column to Top N
✑ Fill in Top / Bottom number field
✑ And lastly drag to the By Value filed your Sales Profit
Reference: https://www.tutorialgateway.org/power-bi-top-10-filters/

Question#4

You have the visual shown in the Original exhibit. {Click the Original tab.)



You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)



What should you add to the visual?

A. a measure
B. a trendline
C. a forecast
D. an Average line

Explanation:
Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.



Timeline
Description automatically generated with low confidence
Reference: https://powerbi.microsoft.com/fr-fr/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/

Question#5

Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region
information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?

A. Create a new aggregation that summarizes by employee.
B. Create a new group on the state column and set the Group type to List.
C. Create a new group on the state column and set the Group type to Bin.
D. Create a new aggregation that summarizes by state.

Explanation:
https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/

Exam Code: DA-100
Q & A: 131 Q&As
Updated:  Sep 07,2021

 Get DA-100 Full Version

KILLTEST CONTACT INFO

[email protected]

GMT+8: Mon-Sat 8:00-18:00

GMT: Mon-Sat 0:00-10:00