DA-100 Exam Prep QUESTIONS &
ANSWERS 100% CORRECT
You have tables. 30 million records. You need ad analytics system. Which two actions? -
Answers:Group the impressions in power query. Create one-to-many relationships between
tables.
Training videos published to Microsoft stream need to be in PowerBI dashboard. Which tile to
add? - Answers:custom streaming data
You open a query. Need to identify the percentage of empty values in each column. Which data
preview option? - Answers:column quality
Prospective customer list that contains 1500 rows of data. [Name, email, state, phone]. Need to
ensure state/region. What two actions? - Answers:Enable column profiling. Select column
profile.
API returns more than 100 columns. Need to remove columns with suffix "sourceid". How to
complete Power Query M code? - Answers:1. Table.RemoveColumns. 2. List.Select. 3.
Text.EndsWith
Building dataset from JSON file. Need to import attributes. What 3 actions (in order)? -
Answers:1. Convert list to table. 2. Expand the columns. 3. Set the data types.
You import two Excel tables named Customer and Address. Need query with one row per
customer. What should you do? - Answers:Merge the customer and address tables
You have 3 versions of an Azure SQL database. Need to configure dataset. Which should you
do? - Answers:Create a parameter and update queries to use it.
CSV file contains user complaints. Need to analyze complaints by date. - Answers:Split the
logged column by using it as the delimiter.
, You have Azure SQl database with sales transactions. Need to detect fraudulent transactions.
How to configure? - Answers:Set Data connectivity mode to DirectQuery
You have a data model that contains many complex DAX expressions. Recommend a solution to
minimize "Related" and Relatedtable" functions. - Answers:Merge tables using PowerQuery
You have a large dataset that contains more than 1 million rows. Need to reduce size and not lose
data. What to do? - Answers:Split Datetime column into two columns (date & time)
You are modeling data in a table named SalesDetail. Need to provide end users with access to
summary stats. Which 3 actions to perform? (drag and drop) - Answers:1. Create a blank query
as a data source. 2. Specify the following query, then close and apply. 3. Create a visual on a
report page using fields from new table.
You create a step using Power Query Editor. A row has address in address column. What will
value be after the step is applied? - Answers:21319 Lasalle Street (replaced text)
You have a Power BI report that is 550MB that is accessed by app. Recommend solution to
improve performance. - Answers:Split the visuals onto multiple pages.
You create a dashboard using PowerBI that contains a card visual that shows total sales from the
current year. You need to automate notifications. What should you do? - Answers:Create a
subscription
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft
SQL serve table that has >100mil records. You need to import a sample of the data. You import
the table and add a filter step in Power Query editor. Does this meet the goal? - Answers:Yes
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft
SQL serve table that has >100mil records. You need to import a sample of the data. You add a
WHERE clause to the SQL Statement. Does this meet the goal? - Answers:Yes
ANSWERS 100% CORRECT
You have tables. 30 million records. You need ad analytics system. Which two actions? -
Answers:Group the impressions in power query. Create one-to-many relationships between
tables.
Training videos published to Microsoft stream need to be in PowerBI dashboard. Which tile to
add? - Answers:custom streaming data
You open a query. Need to identify the percentage of empty values in each column. Which data
preview option? - Answers:column quality
Prospective customer list that contains 1500 rows of data. [Name, email, state, phone]. Need to
ensure state/region. What two actions? - Answers:Enable column profiling. Select column
profile.
API returns more than 100 columns. Need to remove columns with suffix "sourceid". How to
complete Power Query M code? - Answers:1. Table.RemoveColumns. 2. List.Select. 3.
Text.EndsWith
Building dataset from JSON file. Need to import attributes. What 3 actions (in order)? -
Answers:1. Convert list to table. 2. Expand the columns. 3. Set the data types.
You import two Excel tables named Customer and Address. Need query with one row per
customer. What should you do? - Answers:Merge the customer and address tables
You have 3 versions of an Azure SQL database. Need to configure dataset. Which should you
do? - Answers:Create a parameter and update queries to use it.
CSV file contains user complaints. Need to analyze complaints by date. - Answers:Split the
logged column by using it as the delimiter.
, You have Azure SQl database with sales transactions. Need to detect fraudulent transactions.
How to configure? - Answers:Set Data connectivity mode to DirectQuery
You have a data model that contains many complex DAX expressions. Recommend a solution to
minimize "Related" and Relatedtable" functions. - Answers:Merge tables using PowerQuery
You have a large dataset that contains more than 1 million rows. Need to reduce size and not lose
data. What to do? - Answers:Split Datetime column into two columns (date & time)
You are modeling data in a table named SalesDetail. Need to provide end users with access to
summary stats. Which 3 actions to perform? (drag and drop) - Answers:1. Create a blank query
as a data source. 2. Specify the following query, then close and apply. 3. Create a visual on a
report page using fields from new table.
You create a step using Power Query Editor. A row has address in address column. What will
value be after the step is applied? - Answers:21319 Lasalle Street (replaced text)
You have a Power BI report that is 550MB that is accessed by app. Recommend solution to
improve performance. - Answers:Split the visuals onto multiple pages.
You create a dashboard using PowerBI that contains a card visual that shows total sales from the
current year. You need to automate notifications. What should you do? - Answers:Create a
subscription
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft
SQL serve table that has >100mil records. You need to import a sample of the data. You import
the table and add a filter step in Power Query editor. Does this meet the goal? - Answers:Yes
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft
SQL serve table that has >100mil records. You need to import a sample of the data. You add a
WHERE clause to the SQL Statement. Does this meet the goal? - Answers:Yes
