[2021.1] latest Microsoft DA-100 practice test

Welcome to your [2021.1] latest Microsoft DA-100 practice test

QUESTION 1HOTSPOT
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
[2021.1] lead4pass da-100 practice test q1
QUESTION 2What should you create to meet the reporting requirements of the sales department?
QUESTION 3DRAG DROP
You are modeling data in a table named SalesDetail by using Microsoft Power Bl.
You need to provide end-users with access to the summary statistics about the SalesDetail data. The users require
insights on the completeness of the data and the value distributions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions
to the answer area and arrange them in the correct order.
Select and Place:
[2021.1] lead4pass da-100 practice test q3
QUESTION 4HOTSPOT
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance
sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the
appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
[2021.1] lead4pass da-100 practice test q4
QUESTION 5You have a large dataset that contains more than 1 million rows. The table has a DateTime column named Date.
You need to reduce the size of the data model.
What should you do?
QUESTION 6You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
1.
First name
2.
Last name
3.
Email address
4.
State/Region
5.
Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing
campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
QUESTION 7Note: 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 on 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 a 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?
QUESTION 8Note: 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 on the review screen. You have several reports and dashboards
in a workspace. You need to grant all organizational users to read access to a dashboard and several reports.
Solution: You publish an app to the entire organization. Does this meet the goal?
QUESTION 9You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least
privilege. Which role should you assign to the user?
QUESTION 10Note: 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 on 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 a 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?
QUESTION 11HOTSPOT
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the
data are shown in the following table.
[2021.1] lead4pass da-100 practice test q11
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct
selection is worth one point.
Hot Area:
[2021.1] lead4pass da-100 practice test q11-1
QUESTION 12You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries
contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data
structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do on Microsoft Power Bl Desktop?
QUESTION 13You need to provide a solution to provide the sales managers with the required access. What should you include in the
solution?