Power BI DA-100 Certification | Complete Exam
Questions & Answers (100% Correct) 2024|2025
You have a custom connector that returns ID, From, To, Subject, Body, and Has
Attachments for every email sent during the past year. More than 10 million
records are returned.You build a report analyzing the internal networks of
employees based on whom they send emails to.You need to prevent report
recipients from reading the analyzed emails. The solution must minimize the
model size.What should you do?
A. Implement row-level security (RLS) so that the report recipients can only see
results based on the emails they sent.
B. Remove the Subject and Body columns during the import.
C. From Model view, set the Subject and Body columns to Hidden. - correct
answer B
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 A,B
,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 - correct answer D
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
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 - correct answer C,E
You import two Microsoft Excel tables named Customer and Address into Power
Query. Customer contains the following columns:
✑ 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
You have the following three versions of an Azure SQL database:
✑ Test
Questions & Answers (100% Correct) 2024|2025
You have a custom connector that returns ID, From, To, Subject, Body, and Has
Attachments for every email sent during the past year. More than 10 million
records are returned.You build a report analyzing the internal networks of
employees based on whom they send emails to.You need to prevent report
recipients from reading the analyzed emails. The solution must minimize the
model size.What should you do?
A. Implement row-level security (RLS) so that the report recipients can only see
results based on the emails they sent.
B. Remove the Subject and Body columns during the import.
C. From Model view, set the Subject and Body columns to Hidden. - correct
answer B
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 A,B
,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 - correct answer D
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
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 - correct answer C,E
You import two Microsoft Excel tables named Customer and Address into Power
Query. Customer contains the following columns:
✑ 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
You have the following three versions of an Azure SQL database:
✑ Test
