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