[Q23-Q40] Real Microsoft DA-100 Exam Questions [Updated 2022]

Real Microsoft DA-100 Exam Questions [Updated 2022]

DA-100 Exam Dumps Pass with Updated 2022 Analyzing Data with Microsoft Power BI

More about DA-100 Exam

This test focuses on technical domains such as structuring data, using DAX to create measures, making a data model, acquiring data from numerous sources, and preparing and analyzing data. Also, it checks one’s skills in interpreting reports, revealing data insights, forming dashboards, visualizing data, handling datasets, and lastly, incorporating and maintaining deliverables. The registration fee for DA-100 is $165. The test is available in numerous languages including Japanese, Chinese, Korean, and English. DA-100 can be taken at local physical centers or online under proctored conditions.

NEW QUESTION 23
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. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
B. Create one-to-many relationships between the tables.
C. Group the impressions by Ad_id, Site_name, and Impression_date.
Aggregate by using the CountRowsfunction.
D. Create a calculated measure that aggregates by using the COUNTROWS function.

Answer: B,C

NEW QUESTION 24
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.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/power-query/append-queries

NEW QUESTION 25
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. Split the Date column into two columns, one that contains only the time and another that contains only the date.
D. Trim the Date column.

Answer: C

Explanation:
Explanation: We have to separate date & 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 & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need 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

NEW QUESTION 26
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 27
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.

Answer:

Explanation:

NEW QUESTION 28
You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

A. Q&A
B. Key influences
C. Funnel chart
D. Line and clustered column chart

Answer: B

NEW QUESTION 29
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
* CustomerID
* Customer City
* Customer State
* Customer Name
* Customer Address 1
* Customer Address 2
* Customer Postal Code
The Invoice table contains the following fields:
* Order ID
* Invoice ID
* Invoice Date
* Customer ID
* Total Amount
* Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
* The number of customers invoiced in each state last month
* The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation

Box 1: One-to-many
A customer can have many invoices within one month.
Box 2: Single
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the
"many" side (bi-directional). For
Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-directional.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

NEW QUESTION 30
Hotspot Question
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.

Answer:

Explanation:

Explanation:
Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.

NEW QUESTION 31
You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
What should you do?

A. Add a description of "subscriber count" to the Customer Count measure.
B. Set Summarize By to None for the CustomerlD column.
C. Add a description of "Subscriber" to the Customer table.
D. Add a synonym of "subscriber" to the Customer table.

Answer: D

NEW QUESTION 32
You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

A. Create a horizontal line that has a fixed value of 24,000.
B. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],0.40)
C. Add a measure to the visual that uses the following DAX expression.
Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
D. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

Answer: D

Explanation:
Explanation
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart

Add percentile lines to monitor daily revenue

NEW QUESTION 33
You need to create a measure that will return the percentage of late orders.
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.

Answer:

Explanation:

NEW QUESTION 34
You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Show whitespace
B. Column quality
C. Column distribution
D. Column profile
E. Monospace

Answer: C,D

Explanation:
Explanation
B: Column distribution: This feature provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.
By hovering over the distribution data in any of the columns, you get information about the overall data in the column (with distinct count and unique values).
A: Column profile: This feature provides a more in-depth look at the data in a column [compared to column distribution]. Apart from the column distribution chart, it contains a column statistics chart.
Reference:
https://docs.microsoft.com/en-us/power-query/data-profiling-tools

NEW QUESTION 35
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. Create a new table based on the Date table where date_idis unique, and then create a many-to-many relationship to Weekly_Return.
B. Add the Weekly_Returns data to the Sales table by using RELATED DAX functions.
C. In the Weekly_Returns table, create a new calculated column named date_idin a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

Answer: C

Explanation:
Explanation/Reference:
Explanation:
Scenario: Region managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.

NEW QUESTION 36
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.

Answer:

Explanation:

NEW QUESTION 37
You build a report about warehouse inventory data. The dataset has more than 10 million product records from
200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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.

Answer:

Explanation:

Explanation

NEW QUESTION 38
Hotspot Question
You have a Power Bl 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.
NOTX Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 39
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.

Answer:

Explanation:

Explanation:
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