JACKLINE
Power BI - DA100 With Questions And 100% ALL CORRECT ANSWERS
Terms in this set (53)
You have a custom connector that returns ID, B
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.
Power BI - DA100
1/30
,The Impressions table contains approximately 30 A,B
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.
Your company has training videos that are D
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
Power BI - DA100
2/30
, You open a query in Power Query Editor.You D
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
You have a prospective customer list that C,E
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
Power BI - DA100
3/30
Power BI - DA100 With Questions And 100% ALL CORRECT ANSWERS
Terms in this set (53)
You have a custom connector that returns ID, B
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.
Power BI - DA100
1/30
,The Impressions table contains approximately 30 A,B
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.
Your company has training videos that are D
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
Power BI - DA100
2/30
, You open a query in Power Query Editor.You D
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
You have a prospective customer list that C,E
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
Power BI - DA100
3/30
