JACKLINE
DA-100, DA-100, Data analyst With Questions And 100% ALL SURE ANSWERS
Terms in this set (163)
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?
D. Split the Date column into two columns, one · A. Round the hour of the Date column to startOfHour.
that contains only the time and another that · B. Change the data type of the Date column to Text.
contains only the date. · C. Trim the Date column.
· D. Split the Date column into two columns, one that contains only the time and another that
contains only the date.
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
· B. Remove the Subject and Body columns minimize the model size. What should you do?
during the import.
· 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.
1/21
,DA-100, DA-100, Data analyst
2/21
, 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.
A. Group the impressions by Ad_id, Site_name,
✑ Minimize the data model size.
and Impression_date. Aggregate by using the
Which two actions should you perform? Each correct answer presents part of the solution.
CountRows function.
B. Create one-to-many relationships between
A. Group the impressions by Ad_id, Site_name, and Impression_date. Aggregate by using the
the tables.
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 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
· D. web content
· B. custom streaming data
· C. text box
· D. web content
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
· D. Column quality
· B. Column profile
· C. Column distribution
· D. Column quality
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
· C. Enable Column profiling based on entire ✑ Phone number
dataset. You import the list into Power Query Editor. You need to ensure that the list contains records
· E. Select Column profile. for each State/Region to which you want to target a marketing campaign. Which two actions
should you perform?
· 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.
DA-100, DA-100, Data analyst
3/21
DA-100, DA-100, Data analyst With Questions And 100% ALL SURE ANSWERS
Terms in this set (163)
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?
D. Split the Date column into two columns, one · A. Round the hour of the Date column to startOfHour.
that contains only the time and another that · B. Change the data type of the Date column to Text.
contains only the date. · C. Trim the Date column.
· D. Split the Date column into two columns, one that contains only the time and another that
contains only the date.
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
· B. Remove the Subject and Body columns minimize the model size. What should you do?
during the import.
· 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.
1/21
,DA-100, DA-100, Data analyst
2/21
, 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.
A. Group the impressions by Ad_id, Site_name,
✑ Minimize the data model size.
and Impression_date. Aggregate by using the
Which two actions should you perform? Each correct answer presents part of the solution.
CountRows function.
B. Create one-to-many relationships between
A. Group the impressions by Ad_id, Site_name, and Impression_date. Aggregate by using the
the tables.
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 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
· D. web content
· B. custom streaming data
· C. text box
· D. web content
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
· D. Column quality
· B. Column profile
· C. Column distribution
· D. Column quality
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
· C. Enable Column profiling based on entire ✑ Phone number
dataset. You import the list into Power Query Editor. You need to ensure that the list contains records
· E. Select Column profile. for each State/Region to which you want to target a marketing campaign. Which two actions
should you perform?
· 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.
DA-100, DA-100, Data analyst
3/21
