DA-100

DA-100 practice questions, page 2 of 4, with answer review and explanations.

Question 6

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. NOTE: Each correct selection is worth one point. Hot Area:

Question 7

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:

Question 8

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?

  1. Merge the Customer and Address tables.
  2. Transpose the Customer and Address tables.
  3. Group the Customer and Address tables by the Address ID column.
  4. Append the Customer and Address tables.

Question 9

You have the following three versions of an Azure SQL database: ✑ Test ✑ Production ✑ Development You have a dataset that uses the development database as a data source. You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com. Which should you do?

  1. Create a JSON file that contains the database server names. Import the JSON file to the dataset.
  2. Create a parameter and update the queries to use the parameter.
  3. Create a query for each database server and hide the development tables.
  4. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

Question 10

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

  1. Change the data type of the Logged column to Date.
  2. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
  3. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
  4. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.