[Jan 2021] Microsoft DA-100 exam dumps and online practice questions are available from Lead4Pass

The latest updated Microsoft DA-100 exam dumps and free DA-100 exam practice questions and answers! Latest updates from Lead4Pass Microsoft DA-100 Dumps PDF and DA-100 Dumps VCE, Lead4Pass DA-100 exam questions updated and answers corrected!
Get the full Microsoft DA-100 dumps from https://www.leads4pass.com/da-100.html (VCE&PDF)

Latest DA-100 PDF for free

Share the Microsoft DA-100 Dumps PDF for free From Lead4pass DA-100 Dumps part of the distraction collected on Google Drive shared by Lead4pass
https://drive.google.com/file/d/1eiJ0_Gqtcd4wzdQWjMU-cCEMF7XnCxVR/

Latest Lead4pass DA-100 Youtube

Share the latest Microsoft DA-100 exam practice questions and answers for free from Led4Pass Dumps viewed online by Youtube Videos

The latest updated Microsoft DA-100 Exam Practice Questions and Answers Online Practice Test is free to share from Lead4Pass (Q1-Q13)

QUESTION 1
HOTSPOT
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:

Box 1: Using a workspace membership Scenario: The company wants to provide a single package of reports to the
board that contains custom navigation and links to supplementary information. Note: Workspace is a shared
environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have
hundreds of dashboards, reports, and datasets in it. Box 2: A mail-enabled security group Scenario: Security
Requirements The reports must be made available to the board

QUESTION 2
What should you create to meet the reporting requirements of the sales department?
A. a calculated column that uses a formula of couMTA(Sales[sales_id]>
B. a calculated measure that uses a formula of couNTROws(Sales)
C. a calculated column that uses a formula of suM(Sales[sales_id])
D. a measure that uses a formula of SW-i(Sales[sales_id])
Correct Answer: B

QUESTION 3
DRAG 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:

QUESTION 4
HOTSPOT
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:

Box 1: A DAX Calculated measure
Box 2: Date.EndofQuarter(#date([Year],[Mont],1))
END OF QUARTER returns the last date of the quarter in the current context for the specified column of dates.
The following sample formula creates a measure that returns the end of the quarter, for the current context.
= ENDOFQUARTER(DateTime[DateKey])
Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

QUESTION 5
You 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?
A. Round the hour of the Date column to startOfHour.
B. Change the data type of the Date column to Text.
C. Trim the Date column.
D. Split the Date column into two columns, one that contains only the time and another that contains only the date.
Correct Answer: D
Explanation: We have to separate date and time tables. Also, we don\\’t need to put the time into the date table,
because the time is repeated every day. Split your DateTime column into a separate date and time columns in the fact
table, so that you can join the date to the data table and the time to the time table. The time needs to be converted to the
nearest round minute or second so that every time in your data corresponds to a row in your time table.
Reference: https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

QUESTION 6
You 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.
A. Open the Advanced Editor.
B. Select Column quality.
C. Enable Column profiling based on the entire dataset.
D. Select Column distribution.
E. Select Column profile.
Correct Answer: DE
Data Profiling, Quality, and Distribution in Power BI / Power Query features To enable these features, you need to go to
the View tab Data Preview Group Check the following:
1.
Column quality
2.
Column profile
3.
Column distribution

Column profile
Turn on the Column Profiling feature.

Column distribution
Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts.

Reference: https://www.poweredsolutions.co/2019/08/13/data-profiling-quality-distribution-in-power-bi-power-query/
https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/

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 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?
A. Yes
B. No
Correct Answer: B
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.
Reference: https://dash-intel.com/powerbi/statistical_functions_percentile.php

QUESTION 8
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 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?
A. Yes
B. No
Correct Answer: B
Instead, assign all the users the Viewer role to the workspace. Note: 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”.
Reference: https://powerbi.microsoft.com/en-us/blog/announcing-the-new-viewer-role-for-power-bi-workspaces/

QUESTION 9
You 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?
A. Viewer
B. Contributor
C. Member
D. Admin
Correct Answer: C
A Member can add members or others with lower permissions. Note:

QUESTION 10
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 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?
A. Yes
B. No
Correct Answer: A
The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference: https://dash-intel.com/powerbi/statistical_functions_percentile.php

QUESTION 11
HOTSPOT
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the
data shown in the following table.

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:

QUESTION 12
You 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?
A. Get data from a SharePoint Online list, enter the site URL, and then select Combine and Load.
B. Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by folder path.
C. Get data from a SharePoint Online folder, enter the site URL and then select Combine and Load.
D. Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by folder path.
Correct Answer: A

QUESTION 13
You need to provide a solution to provide the sales managers with the required access. What should you include in the
solution?
A. Create a security role that has a table filter on the Sales_Manager table where username = UserName()
B. Create a security role that has a table filter on the Region_Manager table where sales_manager_id =
UserPrincipalName().
C. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
D. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.
Correct Answer: B
Scenario: The region_id column can be managed by only one sales manager.
You can use Username() or userprincipalname() in DAX with Row-Level Security.
Within Power BI Desktop, username() will return a user in the format of DOMAIN\User, and userprincipalname() will
return a user in the format of [email protected].
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Fulldumps shares the latest updated Microsoft DA-100 exam exercise questions, DA-100 dumps pdf, and Youtube video learning for free.
All exam questions and answers come from the Lead4pass exam dumps shared part! Lead4pass updates throughout the year and shares a portion of your exam questions for free to help you understand the exam content and enhance your exam experience!
Get the full Microsoft DA-100 exam dumps questions at https://www.leads4pass.com/da-100.html (pdf&vce)

ps.

Get free Microsoft DA-100 dumps PDF online: https://drive.google.com/file/d/1eiJ0_Gqtcd4wzdQWjMU-cCEMF7XnCxVR/