DA-100-Questions Flashcards
How should you prepare the data on Sales spreadsheet?
C. In Microsoft Excel, convert the data in the Sales spreadsheet to a flat table.
Does this action allow you to use Microsoft R scripts in your visualization?
B. No, it does not
Does this action allow you to use Microsoft R scripts in your visualization?
A. Yes, it does
Does this action allow you to use Microsoft R scripts in your visualization?
B. No, it does not
Which Power Query M formula should you use?
A. Text.Replace([SSN], Text.Start([SSN],6), “xxx-xx”)
Which Power Query function should you use?
D. Append Queries
Does this action allow you to ascertain the percentage of empty values in each column?
B. No, it does not
Does this action allow you to ascertain the percentage of empty values in each column?
B. No, it does not
Does this action allow you to ascertain the percentage of empty values in each column?
A. Yes, it does
What should you do?
B. In your query definitions, modify the source step to use the DS parameter as the file path.
Which two actions could you take? Each correct selection is a complete solution.
B. Create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.
D. Create measures that use the CALCULATE, COUNT, and FILTER DAX functions.
What should you do?
D. In Power BI Settings, configure Datasets
Does this action produce the desired outcome?
B. No, it does not
Does this action produce the desired outcome?
B. No, it does not
Does this action produce the desired outcome?
A. Yes, it does
What should you do before you can create the report?
B. For each relationship, change the Cross filter direction to Both.
Which DAX function should you use?
C. SAMEPERIODLASTYEAR
How would you calculate the number of orders?
A. Create a calculated measure that uses the COUNTA(‘Orders’[Order_id]) DAX formula.