How to pass the Microsoft DA-100 exam as a DA-100 novice

Experience passing the Microsoft DA-100 exam as a da-100 novice? Hopefully, this article will help others prepare for the exam. DA-100 Learning Materials and Strategy Sharing: Keep the plan simple and realistic so I can execute it. It is recommended to use the Pas4itSure DA-100 exam dumps material( Link https://www.pass4itsure.com/da-100.html PDF+VCE ), spend enough time practicing the exercise questions inside, plus daily learning, and beginners can quickly pass the Microsoft DA-100 exam.

Microsoft DA-100 exam PDF

Microsoft DA-100 pdf free https://drive.google.com/file/d/1wD9OGyKl_B3Fnvk1iLVT_2Hj6wSFz5zw/view?usp=sharing from Pas4itSure.

Free sharing of  Microsoft DA-100 exam questions and answers q1-q15

QUESTION 1

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data
quality issues that must be investigated by the customer services department of your company.
You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.

Which report setting should you configure?

A. Don\’t allow end-user to save filters on this report.
B. Change default visual interaction from cross highlighting to cross-filtering.
C. Enable the updated filter pane and show filters in the visual header for this report.
D. Allow users to add comments to this report.
E. Choose the type of data you allow your end-users to export.
Correct Answer: E

Explanation: https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/

QUESTION 2

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 come from three sources. Detailed revenue, cost, and expense data come 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 3

You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which
dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

A. comments
B. tiles
C. Microsoft Information Protection sensitivity labels
D. Active Directory groups
Correct Answer: C

Explanation: Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical
content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied to
datasets, reports, dashboards, and dataflows.

Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview

QUESTION 4

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 several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You assign all the users the Viewer role to the workspace.

Does this meet the goal?

A. Yes
B. No
Correct Answer: A

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 5

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 several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard
with the group.

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 6

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 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 an average line by using the Salary measure. Does this meet the goal?

A. Yes
B. No
Correct Answer: B

Instead, create a percentile line by using the Salary measure and setting 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 7

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged
contains the date and time each complaint occurred. The data in Logged is in the following format: 2018- 12-31 at
08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you
do?

A. Change the data type of the Logged column to Date.
B. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to
Date.
C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
D. Apply a transform to extract the first 11 characters of the Logged column.
Correct Answer: D

With Power Query, you can Split Date and Time into Separate Columns by using a transform.

Reference:
https://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into- separate-columns/

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 section, you will NOT be able to return to it. As a result, these questions will not
appear in the review screen.

You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named
The order has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function.

Does this meet the goal?

A. Yes
B. No
Correct Answer: B

QUESTION 9

You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.

Solution: You enable included in-app for all assets.
Does this meet the goal?

A. Yes
B. No
Correct Answer: B

QUESTION 10

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.
The Sales table contains purchase and ship dates. Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?

A. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
B. Duplicate the Date query in Power Query and use active relationships between both Date tables.
C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both
Date tables in the modeling view.
D. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship
date.

Correct Answer: D

Only one relationship can be active.

Note: If you query two or more tables at the same time when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.

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

QUESTION 11

HOTSPOT
You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Hot Area:

Box 2: Build
The analysts must be able to build new reports from the dataset that contains the profit and loss data.
Scenario: The reports must be made available to the board from powerbi.com.
The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data,
which must be restricted to only their business unit\’s data.

The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports
that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to
share the quarterly reports with anyone.

QUESTION 12

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and
Longitude in the fields sent to the visual. Each customer ID is unique.
In powerbi.com, when users load the visual, they only see some of the customers.

What is the cause of the issue?

A. The visual was built by using a different version of R.
B. The data comes from a Microsoft SQL Server source.
C. The data is deduplicated.
D. Too many records were sent to the visual.
Correct Answer: D

R visuals in the Power BI service have a few limitations including:

Data size limitations? data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are
selected, only the top 150,000 rows are used and a message is displayed on the image.
Additionally, the input data has a limit of 250 MB.

Reference: https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals

QUESTION 13

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 14

You need to create a calculated column to display the month based on the reporting requirements.
Which DAX expression should you use?

A. FORMAT(\’Date\'[date], “MMM YYYY”)
B. FORMAT(\’Date\’ [date], “M YY”)
C. FORMAT(\’Date\'[date_id], “MMM”) and “” and FORMAT(\’Date\'[year], “#”)
D. FORMAT(\’Date\’ [date_id], “MMM YYYY”)
Correct Answer: D

Scenario: In the Date table, the date_id column has a format of yyyymmdd. Users must be able to see the month in reports as shown in the following example: Feb 2020.

QUESTION 15

HOTSPOT
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.

You receive the following email message: “Hi. I\’ve put 24 files of monthly transaction data onto the shared drive. File
Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv
to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50
transactions.”

You get data from the folder and select Combine and Load. The Combine Files dialog box is shown in the exhibit. (Click
the Exhibit tab.)

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:

Finally,

It’s also easy for a novice to pass a DA-100 exam, just in the right way. Trust the Pas4itSure DA-100 exam dumps material, take the time to practice the questions, and success is right in front of your eyes! The free DA-100 exam practice questions shared above are only part of the complete DA-100 exam dumps. For complete DA-100 exam dumps, please click here https://www.pass4itsure.com/da-100.html DA-100 exam dumps.

I hope this article can help you solve your doubts, and I wish the exam a success!