Valid Microsoft DA-100 questions shared by Pass4itsure for helping to pass the Microsoft DA-100 exam! Get the newest Pass4itsure Microsoft DA-100 exam dumps with VCE and PDF here: https://www.pass4itsure.com/da-100.html (121 Q&As Dumps).
[Free PDF] Microsoft DA-100 pdf Q&As https://drive.google.com/file/d/1Djc4rrHqfc9uuva4hO0u0otw9S6qc3Hh/view?usp=sharing
Suitable for DA-100 complete Microsoft learning pathway
The content is rich and diverse, and learning will not become boring. You can learn in multiple ways through the Microsoft DA-100 exam.
Microsoft DA-100 Analyzing Data with Microsoft Power BI
- Download
- Answer practice questions, the actual Microsoft DA-100 test
Free Microsoft DA-100 dumps download
[PDF] Free Microsoft DA-100 dumps pdf download https://drive.google.com/file/d/1Djc4rrHqfc9uuva4hO0u0otw9S6qc3Hh/view?usp=sharing
Pass4itsure offers the latest Microsoft DA-100 practice test free of charge 1-13
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.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Group the impressions by Ad_id, Site_name, and Impression_date.Aggregate by using the CountRows function.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Group the impressions by Ad_id, Site_name, and Impression_date.Aggregate by using the CountRows function.
B. Create one-to-many relationships between the tables.
C. Create a calculated measure that aggregates by using the COUNTROWS function.
D. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
Correct Answer: AB
QUESTION 3
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting
requirements of the regional managers. What should you do?
A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the
calculated column to create a relationship to the Date table.
B. Add the Weekly_Returns data to the Sales table by using related DAX functions.
C. Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to
Weekly_Return.
Correct Answer: A
Scenario: Region managers require a visual to analyze weekly sales and returns. To relate the two tables we need a
common column
QUESTION 4
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 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
HOTSPOT
You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: Background color
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select
Background color or Font color.
In the Background color or Font color dialog box, select Field value from the Format by drop-down field.
Box 2: Field value
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color
gradients, based on field values.
QUESTION 7
HOTSPOT
You view a query named Transactions as shown in the following exhibit.
The query gets CSV files from a folder.
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: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.
QUESTION 8
You have a line chart that shows the number of employees in a department over time.
You need to see the total salary costs of the employees when you hover over a data point.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Add a salary to the tooltips.
B. Add a salary to the visual filters.
C. Add salary to the drillthrough fields.
Correct Answer: AB
A: When visualization is created, the default tooltip displays the data point\\’s value and category. There are many
instances when customizing the tooltip information is useful. Customizing tooltips provides additional context and
information
for users viewing the visual. Custom tooltips enable you to specify additional data points that display as part of the
tooltip.
B: Visual Filter applies to a single visual/tile on a report page. You can only see visual level filters selected visual on the
report canvas.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips https://technovids.com/power-bifilters/
QUESTION 9
You are developing a sales report that will have multiple pages. Each page will answer a different business question.
You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the question is
answered. The solution must ensure that the menu page will work when deployed to any workspace.
What should you include on the menu page?
A. Create a text box for each business question and insert a link.
B. Create a button for each business question and set the action type to Bookmark.
C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.
Correct Answer: C
Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps
that connect to business data. Using the Power Apps visual, you can pass context-aware data to a canvas app, which
updates in real-time as you make changes to your report. Now, your app users can derive business insights and take
actions from right within their Power BI reports and dashboards.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual
QUESTION 10
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.
QUESTION 11
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
QUESTION 12
DRAG DROP
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date
attributes can be used as date hierarchies in Microsoft Power BI reports.
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:
Correct Answer:
Step 1: Expand the records.
First Open Power BI desktop and navigate to Power Query, import the JSON file, then load the data, click on the record
to expand it and to see the record and list.
Step 2: Add columns that use data type conversions.
Step 3: Convert the list to a table
QUESTION 13
HOTSPOT
You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
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: TOPN
TOPN returns the top N rows of the specified table.
Box 2: SUMMARIZE
SUMMARIZE returns a summary table for the requested totals over a set of groups.
Box 3: DESC
Sort in descending order.
It is last in the TOPN command.
TOPN syntax:
TOPN(, , , [[, , []]…])
Pass4itsure Microsoft exam dumps discount code share
Summarize:
[Q1-Q13] Free Microsoft DA-100 pdf download https://drive.google.com/file/d/1Djc4rrHqfc9uuva4hO0u0otw9S6qc3Hh/view?usp=sharing
Share all the resources: Latest Microsoft DA-100 practice questions, latest Microsoft DA-100 pdf dumps. The latest updated Microsoft DA-100 dumps https://www.pass4itsure.com/da-100.html Study hard and practices a lot. This will help you prepare for the Microsoft DA-100 exam. Good luck!
