DA-100, DA-100, Data analyst
QUESTIONS & ANSWERS 100%
CORRECT
D. Split the Date column into two columns, one that contains only the time and another that
contains only the date. - Answers: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?
· A. Round the hour of the Date column to startOfHour.
· B. Change the data type of the Date column to Text.
· 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.
· B. Remove the Subject and Body columns during the import. - Answers: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.
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. - Answers: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.
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.
· D. web content - Answers: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
· D. Column quality - Answers: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
· C. Enable Column profiling based on entire dataset.
· E. Select Column profile. - Answers: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?
· 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.
1. Remove Column
2. List.Select
3. Text.EndsWith - Answers:HOTSPOT -You have an API that returns more than 100 columns.
The following is a sample of column names.
✑ client_notified_timestamp
✑ client_notified_source
✑ client_notified_sourceid
✑ client_notified_value
✑ client_responded_timestamp
✑ client_responded_source
✑ client_responded_sourceid
✑ client_responded_value
You plan to include only a subset of the returned columns. You need to remove any columns that
have a suffix of sourceid. How should you complete the Power Query M code? To answer, select
the appropriate options in the answer area.
, 1. Convert the list to a table
2. Expand the columns
3. Set the data types - Answers:DRAG DROP - You are building a dataset from a JSON file that
contains an array of documents.You need to import attributes as columns from all the documents
in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in
Microsoft Power BI reports. Which three actions should you perform in sequence? To answer,
move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order. Select and Place:
· A. Merge the Customer and Address tables. - Answers: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.
QUESTIONS & ANSWERS 100%
CORRECT
D. Split the Date column into two columns, one that contains only the time and another that
contains only the date. - Answers: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?
· A. Round the hour of the Date column to startOfHour.
· B. Change the data type of the Date column to Text.
· 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.
· B. Remove the Subject and Body columns during the import. - Answers: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.
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. - Answers: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.
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.
· D. web content - Answers: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
· D. Column quality - Answers: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
· C. Enable Column profiling based on entire dataset.
· E. Select Column profile. - Answers: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?
· 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.
1. Remove Column
2. List.Select
3. Text.EndsWith - Answers:HOTSPOT -You have an API that returns more than 100 columns.
The following is a sample of column names.
✑ client_notified_timestamp
✑ client_notified_source
✑ client_notified_sourceid
✑ client_notified_value
✑ client_responded_timestamp
✑ client_responded_source
✑ client_responded_sourceid
✑ client_responded_value
You plan to include only a subset of the returned columns. You need to remove any columns that
have a suffix of sourceid. How should you complete the Power Query M code? To answer, select
the appropriate options in the answer area.
, 1. Convert the list to a table
2. Expand the columns
3. Set the data types - Answers:DRAG DROP - You are building a dataset from a JSON file that
contains an array of documents.You need to import attributes as columns from all the documents
in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in
Microsoft Power BI reports. Which three actions should you perform in sequence? To answer,
move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order. Select and Place:
· A. Merge the Customer and Address tables. - Answers: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.
