[MAR 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 leads4pass Microsoft DA-100 Dumps PDF and DA-100 Dumps VCE, leads4pass 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 leads4pass DA-100 Dumps part of the distraction collected on Google Drive shared by leads4pass
https://drive.google.com/file/d/1RnOftbCnniLb8WkrDmPte2vTLtyu5ktL/

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

QUESTION 1
You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales records of their region.
The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?
A. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
B. Change the Microsoft Power Bl license type of the sales manager.
C. Manage the permissions of the underlying dataset
D. Request that the sales manager be added to the correct Azure Active Directory group.
Correct Answer: D
Using AD Security Groups, you no longer need to maintain a long list of users.
All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the
REST! This means a small and simple security file with the permissions and AD Security group.
Note: Configure role mappings
Once published to Power BI, you must map members to dataset roles. Members can be user accounts or security
groups. Whenever possible, we recommend you map security groups to dataset roles. It involves managing security
group
memberships in Azure Active Directory. Possibly, it delegates the task to your network administrators.
Reference:
https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

QUESTION 2
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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:

Correct Answer:

When you view dashboards in portrait mode on a phone, you notice the dashboard tiles are laid out one after another,
all the same size. In the Power BI service, you can create a customized view of a dashboard, specifically for portrait
mode
on phones.
Step 1: Open the Dashboard.
Step 2: Change the dashboard view to Phone view
Step 3: Pin items from the reports to the dashboard.
Step 4: Rearrange, resize, or remote items from the Phone view.
Create a phone view of a dashboard
1. In the Power BI service, open a dashboard (Step 1)
2. Select the arrow next to Web view in the upper-right corner > select Phone view. (Step2)

The phone dashboard edit view opens. Here you can unpin, resize, and rearrange tiles to fit the phone view. The web
version of the dashboard doesn\\’t change.
3. Select a tile to drag, resize, or unpin it. You notice the other tiles move out of the way as you drag a tile. The
unpinned tiles go in the Unpinned tiles pane, where they stay unless you add them back.
4. If you change your mind, select Reset tiles to put them back in the size and order they were before.
5. When you\\’re satisfied with the phone dashboard layout, select the arrow next to Phone view in the upper-right
corner > select Web view. Power BI saves the phone layout automatically.

QUESTION 3
What is the minimum number of datasets and storage modes required to support the reports?
A. two imported datasets
B. a single DirectQuery dataset
C. two DirectQuery datasets
D. a single imported dataset
Correct Answer: A
Scenario: Data and Sources
Data for the reports comes from three sources. Detailed revenue, cost, and expense data comes from an Azure SQL
database. Summary balance sheet data comes from Microsoft Dynamics 365 Business Central. The balance sheet data
is
not related to the profit and loss results, other than they both relate dates.
Monthly revenue and expense projections for the next quarter come from a Microsoft SharePoint Online list. Quarterly
projections relate to the profit and loss results by using the following shared dimensions: date, business unit,
department,
and product category.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand

QUESTION 4
You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table.
Which type of visualization should you use?
A. area chart
B. donut chart
C. scatter plot
D. pie chart
Correct Answer: C
Outliers are those data points that lie outside the overall pattern of distribution and the easiest way to detect outliers is
though graphs. Box plots, Scatter plots can help detect them easily.
Reference:
https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-the-microsoft-powerbi-d7ad16ac9ccc

QUESTION 5
You need to recommend a strategy to consistently define the business unit, department, and product category data and
make the data usable across reports. What should you recommend?
A. Create a shared dataset for each standardized entity.
B. Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.
C. For every report, create and use a single shared dataset that contains the standardized data.
D. For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft
OneDrive for others to use as a source.
Correct Answer: B

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 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 a Data Preview Group a 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
HOTSPOT
You have a table that contains the following three columns:
1. City
2. Total Sales
3. Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

How should you configure the visualization? To answer, select the appropriate options in the answer area. NOTE: Each
correct selection is worth one point.
Hot Area:

Correct Answer:

Box 1: Total Sales Box 2: Occupation Box 3: City You can use Expand By to add fields you want to use for setting the
level of the analysis without looking for new influencers. Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

QUESTION 8
HOTSPOT
You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer:

Box 1: One-to-many
Box 2: Both
For One-to-many relationships, the cross filter direction is always from the “one” side, and optionally from the “many”
side (bi-directional).
Note:

Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

QUESTION 9
HOTSPOT
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and
support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer:

QUESTION 10
You are creating a visual to show the ranking of product categories by sales revenue.
Your company\\’s security policy states that you cannot send data outside of your Microsoft Power Bl tenant
Which approach provides the widest variety of visuals while adhering to the security policy?
A. Use default visuals or custom visuals uploaded from a .pbiviz file.
B. Use only default visuals.
C. Use default or any custom visuals from the marketplace.
D. Use default or certified custom visuals.
Correct Answer: C

QUESTION 11
HOTSPOT
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a
data model that contains the following tables.

You need to develop a measure to support the visual.
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.
Hot Area:

Correct Answer:

Box 1: CALCULATE
Start with CALCULATE and use a SUMX.
CALCULATE evaluates an expression in a modified filter context.
Box 2: SUMX
SUMX returns the sum of an expression evaluated for each row in a table. The following sample creates a measure with
the sales of the top 10 sold products. = SUMX(TOPN(10, SUMMARIZE(Product, [ProductKey], “TotalSales”, SUMX
(RELATED(InternetSales_USD[SalesAmount_USD]), InternetSales_USD[SalesAmount_USD]) +
SUMX(RELATED(ResellerSales_USD[SalesAmount_USD]), ResellerSales_USD[SalesAmount_USD]))
Box 3: TOPN
TOPN returns the top N rows of the specified table.
Box 4: [TransactionDate]
TOPN Syntax: TOPN(, , , [[, , []]…])
The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for
each row of table.
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax

QUESTION 12
Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a
Microsoft Power BI dashboard. Which type of tile should you add?
A. video
B. custom streaming data
C. text box
D. web content
Correct Answer: B
The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data
source.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming

QUESTION 13
HOTSPOT
You have a report page that contains the visuals shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the graphic. NOTE: Each correct selection is worth one point.
Hot Area:

Box 1: cross-filter
By default, selecting a data point in one visual on a report page will cross-filter or cross- highlight the other visuals on
the page.
Box 2: cross-highlight
Example:
By default, selecting a data point in one visual on a report page will cross-filter or cross- highlight the other visuals on
the page.

Fulldumps shares the latest updated Microsoft DA-100 exam exercise questions, DA-100 dumps pdf for free.
All exam questions and answers come from the leads4pass exam dumps shared part! leads4pass 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/1RnOftbCnniLb8WkrDmPte2vTLtyu5ktL/