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!
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
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.
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?
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
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?
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/
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?
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/
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?
Explanation: https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/
Exam Code: DA-100Q & A: 131 Q&AsUpdated: Sep 07,2021
[email protected]
GMT+8: Mon-Sat 8:00-18:00
GMT: Mon-Sat 0:00-10:00