Aspiring participants before taking the Microsoft DA-100 real exam,
Need to learn a variety of exam study materials.
But our experts say that candidates should try to obtain validated preparation materials for the DA-100 exam, https://www.pass4itsure.com/da-100.html which may help pass the exam.
Latest Microsoft DA-100 practice test
QUESTION 1
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 2
You have the tables shown in the following table.
……
Get complete free Microsoft DA-100 exam practice questions: https://www.exampass.net/new-update-prep-actual-microsoft-da-100-exam-questions-for-free-share.html
Latest Microsoft DA-100 actual exam questions for free (update 2021.7)! If you want to read more, this site recommends a complete online blog on Microsoft exam practice questions: exampass.net and microsoft-technet.com. Here, you have everything you need to easily prepare and pass the certification exam.
Start practicing now, Microsoft DA-100 study materials free
Download free Microsoft DA-100 exam questions pdf
Microsoft DA-100 pdf free https://drive.google.com/file/d/1ddQopPmFUe-8gF8rhK1Tya3eWcVt2KZ7/view?usp=sharing Google Drive
Real Microsoft DA-100 practice test 1-13 for free
QUESTION 1
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:
QUESTION 2
HOTSPOT
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer: 
Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: KPI
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a
measurable goal.
Box 2: Sales[sales_amount]
Box 3: Date[month]
Time > FiscalMonth. This value will represent the trend.
Box 4: Targets[sales_target]
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
QUESTION 3
HOTSPOT
You have a report page that contains the visuals shown in the following exhibit.
QUESTION 4
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:
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 5
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
QUESTION 6
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-securitygroups/ https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
QUESTION 7
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.
Box 1: A DAX Calculated measure
Box 2: Date.EndofQuarter(#date([Year],[Mont],1))
ENDOFQUARTER 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 8
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.
A. Add the same slicer to each page and configure Sync slicers.
B. Edit the interactions of the KPI visualization.
C. Configure a page-level filter.
D. Edit the interactions of the slicer that is on the same page as the KPI visualization.
E. Configure a report-level filter.
Correct Answer: BE
QUESTION 9
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?
A. Create a new aggregation that summarizes by employee.
B. Create a new group on the state column and set the Group type to List.
C. Create a new group on the state column and set the Group type to Bin.
D. Create a new aggregation that summarizes by state.
Correct Answer: C
With grouping you are normally working with dimensional attributes. Here we add three new groups (East, West, and
North) and add each state to the appropriate group.
Reference: https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/
QUESTION 10
HOTSPOT
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups 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:
Correct Answer:
QUESTION 11
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
to 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 12
You have a Microsoft Power Bl dashboard.
You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers
of the dashboard.
What should you use?
A. Feedback
B. Subscribe
C. Comments
D. Mark as favorite
Correct Answer: C
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment
QUESTION 13
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
A. Show whitespace
B. Column profile
C. Column distribution
D. Column quality
Correct Answer: D
Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the
Selected table. Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data
profiling functionalities:
1.
Column quality
2.
Column distribution
3.
Column profile
Reference:
https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/bap/674555
The above free resources come from Pass4itsure
Reason for selection
Microsoft DA-100 comments:
valid 100% thanks for helping me pass the exam.
Passed this exam with a score of 941.Most of them are in this dump.
Very good dump. If you want to pass your exam, you can try it and I think you can pass your exam as long as you make full use of this dump. Good luck to you.
Share Pass4itsure Microsoft exam discount code 2021
Enter the discount code “Microsoft” to get a 15% discount!
Finish:
Pass4cert shared the latest Microsoft DA-100 pdf, Microsoft DA-100 exam video, Microsoft DA-100 practice exam questions, Microsoft DA-100 study guide! Challenging materials, hone your skills. Suggest you try https://www.pass4itsure.com/da-100.html full DA-100 dumps (PDF and VCE).