Micsft PBI DA 100

The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements:

✑ Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.

Minimize the data model size

• A. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function. •

• B. Create one-to-many relationships between the tables

• C. Create a calculated measure that aggregates by using the COUNTROWS function.

• D. Create a calculated table that contains Ad_id, Site_name, and Impression_date.

Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?

• A. video

• B. custom streaming data

• C. text box

• D. web content

You open a query in Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?

• A. Show whitespace

• B. Column profile

• C. Column distribution

• • D. Column quality

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign. Which two actions should you perform? Each correct answer presents part of the solution.

• A. Open the Advanced Editor.

• C. Enable Column profiling based on entire dataset.

• E. Select Column profile

• B. Select Column quality.

• D. Select Column distribution.

Clients.... You plan to include only a subset of the returned columns. You need to remove any columns that have a suffix of sourceid.

• Box 1: Table.RemoveColumns

  Box 2: List.Select Get a list of columns.

  Box 3: Text.EndsWith

• Box 1: Combine Table Column

  Box 2: List Contains

  Box 3: Text Contains

• Box 1: Table From List

  Box 2: List Select

  Box 3: Text Starts With

• Box 1: Table Finds List

  Box 2: Table FindText

  Box 3: Text From

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.

• Convert list to Table

  Expand Column

  Set Data Type

• Set Data Type

  Expand Column

  Convert list to Table

• Convert list to Table

  Set Data Type

  Expand Column

• Expand Column

  Set Data Type

  Convert list to Table

) 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?

• A. Merge the Customer and Address tables.

• B. Transpose the Customer and Address tables.

• C. Group the Customer and Address tables by the Address ID column.

• D. Append the Customer and Address tables.

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?

• A. Create a JSON file that contains the database server names. Import the JSON file to the dataset.

• B. Create a parameter and update the queries to use the parameter.

• C. Create a query for each database server and hide the development tables.

• D. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function

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.

• A) Create a new column that starts with 2018-12-31 and set the data type of the new column to Date

• . D. Apply a transform to extract the first 11 characters of the Logged column.

• A. Change the data type of the Logged column to Date.

• B. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

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? •

• 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