DA-100 Microsoft Exam Questions and Free Practice Test

Question 25

- (Exam Topic 1)
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

A. Select Column distribution.

B. Select the sales_amount column and apply a number filter.

C. Select Column profile, and then select the sales_amount column.

D. Transform the sales_amount column to replace negative values with 0.

Correct Answer:C

Question 26

- (Exam Topic 4)
You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
DA-100 dumps exhibit Customer ID
Customer Name
Phone
Email Address
Address ID
Address contains the following columns:
Address ID
Address Line 1
Address Line 2
City
State/Region
Country
Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?

A. Merge the Customer and Address tables.

B. Transpose the Customer and Address tables.

C. Group the Customer and Address tables by the Address ID column.

D. Append the Customer and Address tables.

Correct Answer:A
There are two primary ways of combining queries: merging and appending.
DA-100 dumps exhibit When you have one or more columns that you’d like to add to another query, you merge the queries.
When you have additional rows of data that you’d like to add to an existing query, you append the query.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

Question 27

- (Exam Topic 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 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 BI. Part of the data model is a large Microsoft SQL Server table named Order that 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 add a WHERE clause to the SQL statement.
Does this meet the goal?

A. Yes

B. No

Correct Answer:A
The WHERE clause has its effects before the data is imported. Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

Question 28

- (Exam Topic 4)
You have the tables shown in the following table.
DA-100 dumps exhibit
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:BC

Question 29

- (Exam Topic 4)
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.

Correct Answer:B
You can add synonyms to tables and columns.
Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
Reference:
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices

Question 30

- (Exam Topic 4)
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 lis

D. The drop-down list will contain the business questions.

Correct Answer:B
When you create a bookmark, the following elements are saved with the bookmark: - The current page - Filters - Slicers, including slicer type (for example, dropdown or list) and slicer state - Visual selection state (such as cross-highlight filters) - Sort order - Drill location - Visibility of an object (by using the Selection pane) - The focus or Spotlight modes of any visible object

START DA-100 EXAM