Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Location Chicago IL, USA

Microsoft DA-100 Exam Actual Questions

The questions for DA-100 were last updated at Sept. 12, 2021.
  • Viewing page 1 out of 32 pages.
  • Viewing questions 1-4 out of 130 questions

Topic 1 - Question Set 1

Question #1 Topic 1

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 query in Power Query 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.
Reveal Solution Hide Solution   Discussion   36

Correct Answer: AB

Question #2 Topic 1

Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?

  • A. video
  • B. custom streaming data
  • C. text box
  • D. web content
Reveal Solution Hide Solution   Discussion   42

Correct Answer: B
The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data source.

Question #3 Topic 1

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
Reveal Solution Hide Solution   Discussion   18

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:
✑ Column quality
✑ Column distribution
✑ Column profile

Question #4 Topic 1

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
✑ First name
✑ Last name
✑ Email address
✑ State/Region
✑ Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Open the Advanced Editor.
  • B. Select Column quality.
  • C. Enable Column profiling based on entire dataset.
  • D. Select Column distribution.
  • E. Select Column profile.
Reveal Solution Hide Solution   Discussion   29

Correct Answer: DE
Data Profiling, Quality & Distribution in Power BI / Power Query features
To enable these features, you need to go to the View tab ֳ  Data Preview Group ֳ  Check the following:
✑ Column quality
✑ Column profile
✑ Column distribution

✑ Column profile
Turn on the Column Profiling feature.

✑ Column distribution
Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts.

https://www.poweredsolutions.co/2019/08/13/data-profiling-quality-distribution-in-power-bi-power-query/ https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/