Microsoft DA-100 - Analyzing Data with Microsoft Power BI Exam
Page: 3 / 19
Total 94 questions
Question #11 (Topic: Question Set 1)
You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
A. Add a SQL statement.
B. Set Data Connectivity mode to DirectQuery.
C. Set the Command timeout in minutes setting.
D. Set Data Connectivity mode to Import.
Answer: B
Question #12 (Topic: Question Set 1)
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE
functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
A. Split the model into multiple models.
B. Hide unused columns in the model.
C. Merge tables by using Power Query.
D. Transpose.
Answer: C
Question #13 (Topic: Question Set 1)
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 without losing access to any data.
What should you do?
You need to reduce the size of the data model without losing access to any data.
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.
Answer: D
Question #14 (Topic: Question Set 1)
DRAG DROP
You are modeling data in a table named SalesDetail by using Microsoft Power BI.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and
the value distributions.
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:
You are modeling data in a table named SalesDetail by using Microsoft Power BI.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and
the value distributions.
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:
Answer: 
Question #15 (Topic: Question Set 1)
You create the following step by using Power Query Editor.
- Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})
A row has a value of 21318 Lasalle Street in the AddressLine1 column.
What will the value be when the step is applied?
- Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})
A row has a value of 21318 Lasalle Street in the AddressLine1 column.
What will the value be when the step is applied?
A. 1318
B. 1319
C. 21318 Lasalle Street
D. 21319 Lasalle Street
Answer: D
