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?

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

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

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

B. Set Data Connectivity mode to DirectQuery.

C. Set the Command timeout in minutes setting.

D. Set Data Connectivity mode to Import

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

C. Merge tables by using Power Query.

B. Hide unused columns in the model.

A. Split the model into multiple models.

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

D)Split the Date column into two columns, one that contains only the time and another that contains only the date

A. Merge tables by using Power Query. . .

B. Hide unused columns in the model

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.(3 actions)

Create a blank query as a data source Specify the following query, then close and apply Table.profile Create a visual on a report page using fields from the new table

Create a visual on a report page using fields from the new table Specify the following query, then close and apply Table.profile Create a blank query as a data source

Specify the following query, then close and apply Table.profile Create a blank query as a data source Create a visual on a report page using fields from the new table

The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend? • •

B. Split the visuals onto multiple pages.

A. Change any DAX measures to use iterator functions.

C. Change the imported dataset to DirectQuery.

D. Remove unused columns from tables in the data model.

) A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do? •

A. Share the dashboard to the user.

You plan to create several visuals from the data, including a visual that shows revenue split by year and product. You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain. 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

1. Use the first row as headers 2. Unpivot all the columns other than Measure 3. Rename the Attribute column as Year 4. Change the datatype of the year column to date

1. Rename the Attribute column as Year 2. Change the datatype of the year column to date 3. Unpivot all the columns other than Measure 4. Use the first row as headers

1. Unpivot all the columns other than Measure 2. Use the first row as headers 3. Change the datatype of the year column to date 4. Rename the Attribute column as Year

1. Change the datatype of the year column to date 2. Rename the Attribute column as Year 3. Unpivot all the columns other than Measure 4. Use the first row as headers

You have the data lineage shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

Box 1: CONTOSO BIKES report Box 2: three datasets

Box 1: Contoso dashboard Box 2: one dataset

Box 1: Realtime dashboard Box 2: four dataset

You have two Azure SQL databases that contain the same tables and columns. For each database, you create a query that retrieves data from a table named Customer. You need to determine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com .

Box 1: Append Queries as New. Box 2: Disable loading the query to the data model

Box 1: Append Queries Box 2: Delete the queries

Box 1: Merge Queries Box 2: Duplicate the queries

Box 1: Append Queries Box 2: Disable loading the query to the data model

You receive revenue data that must be included in Microsoft Power Bl reports. You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit. You plan to create several visuals from the data, including a visual that shows revenue split by year and product. You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain. 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.

Step 1: Select Use Header as First Row. Step 2: Select Department and Product and Unpivot Other Columns Step 3: Rename the Attribute column to Year and the Value column to Revenue.

Step 1: Rename the Attribute column to Year and the Value column to Revenue. Step 2: Select Use Header as First Row. Step 3: Select Department and Product and Unpivot Other Columns

Step 1: Select Department and Product and Unpivot Other Columns Step 2: Rename the Attribute column to Year and the Value column to Revenue. Step 3: Select Use Header as First Row.

You are building a financial report by using Power BI. You have a table named financials that contains a column named Date and a column named Sales. You need to create a measure that calculates the relative change in sales as compared to the previous quarter. How should you complete the measure? To answer, select the appropriate options in the answer area.

Box 1: CALCULATE Box 2: DATEADD Box 3: DIVIDE

Box 1: Dateadd Box 2: Divide Box 3: Filter

Box 1: Find Box 2: Divide Box 3: Calculate

Box 1: Divide Box 2: Filter Box 3: Filter

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. • •

B. Remove the Subject and Body columns during the import.

A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

C. From Model view, set the Subject and Body columns to Hidden.

You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use to link the tables?

C. one-to-many from Customer to Transaction

B. one-to-one between Customer and Transaction

A. one-to-many from Transaction to Customer

D. many-to-many between Customer and Transaction

You have a Power BI report. You need to create a calculated table to return the 100 highest spending customers. How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

Box 1: TOPN Box 2: SUMMARIZE Box 3: DESC

Box 1: Asc Box 2: Filter Box 3: Summarize

Box 1: Filter Box 2: Topn Box 3: Topn

Box 1: Desc Box 2: Asc Box 3: TopN

The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month. The Power BI model must provide the following information: ✑ The number of customers invoiced in each state last month ✑ The average invoice amount per customer in each postal code

Box 1: One-to-many month. Box 2: Single

Box 1: Many-to-many Box 2: Both

Box 1: one-to-one Box 2: SIngle

The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky" Role2 contains the following filter. Date[Calendar Year] = 2020 - If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model? •

B. The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020

A. The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.

C. The user will see only data for which the State Province value is Kentucky.

D. The user will receive an error and will not be able to see the data in the report.

The Affiliate table has a one-to-many relationship to the Transactions table based on the AffiliateID column. You need to develop a measure to support the visual. How should you complete the DAX expression?

Calculate Sum Topn TransactionDate

SumX Calculate Calculate Amount

TopN TopN ConcateNateX ItemsOrdered

You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model. What should you do? • •

B. Add a synonym of "subscriber" to the Customer table.

A. Add a description of "subscriber count" to the Customer Count measure.

C. Set Summarize By to None for the CustomerlD column.

C. Add a description of "Subscriber" to the Customer table.

You are creating a Microsoft Power BI data model that has the tables shown in the following table. The Products table is related to the ProductCategory table through the ProductCategoryID column. You need to ensure that you can analyze sales by product category. How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area

Box 1: one to one Box 2: Single

Box 1: many to many Box 2: Single

Box 1: one to many Box 2: Single

You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table. Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the Product Description column and is always the fourth value. You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size. 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.

Add a column named ProductName that contains only the text between the third and fourth > symbol in the ProductDescription column Create a product hierarchy of Maufacturer, ProductSpecifications, ProductName, ProductSubcategory, and ProductCategory Replace the use of ProductDescription in the report with the product hierarchy

Create a product hierarchy of Maufacturer, ProductSpecifications, ProductName, ProductSubcategory, and ProductCategory Replace the use of ProductDescription in the report with the product hierarchy Add a column named ProductName that contains only the text between the third and fourth > symbol in the ProductDescription column

Add a column named ProductName that contains only the text between the third and fourth > symbol in the ProductDescription column Create a product hierarchy of Maufacturer, ProductSpecifications, ProductName, ProductSubcategory, and ProductCategory Replace the use of ProductDescription in the report with the product hierarchy

You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you use in the query?

• D. = Table.ExpandListColumn(Table.TransformColumns(Source, {{"classes", Splitter.SplitTextByDelimiter(",", QuoteStyle.None), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")

B. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")

C. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None), {"classes.1"})

A. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

You publish the dataset to powerbi.com , set RLS role membership, and distribute the dataset and related reports to the salespeople. A salesperson reports that she believes she should see more data. You need to verify what data the salesperson currently sees. What should you do?

A. Use the Test as role option to view data as the salespersonגTM€s user account.

B. Use the Test as role option to view data as the Sales role.

C. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

You are creating a quick measure as shown in the following exhibit. You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.

Box 1: Total Sales Box 2: Date Box 3: Month

Box 1: Total Cost Box 2: Total Sales Box 3: Quarters

Box 1: Month Box 2: Year Box 3: Days

Box 1: Total Order Cost Box 2: Year Box 3: Quarters

You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions. A sales manager changes to a different region. You need to ensure that the sales manager can see the correct sales data. What should you do? • •

C. Request that the sales manager be added to the correct Azure Active Directory group

A. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.

B. Change the Microsoft Power Bl license type of the sales manager.

D. Manage the permissions of the underlying dataset

You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent. How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Divide, Calculate, AllSelected.

The Date table is marked as a date table. DateID is the date data type. You need to create an annual sales growth percentage measure. Which DAX expression should you use?

B. (SUM(ג˜€Salesג]TM€sales_amount]) - CALCULATE(SUM(ג˜€Salesג]TM€sales_amount]), SAMEPERIODLASTYEAR(ג˜€Dateג]TM€DateID]))) / CALCULATE(SUM(ג˜€Salesג]TM€sales_amount]), SAMEPERIODLASTYEAR(ג˜€Dateג]TM€DateID]))

A. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])

C. CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))

D. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured. You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings. What should you do? • •

D. Create an active relationship between the tables and select Apply security filter in both directions.

A. Create an active relationship between the tables and select Assume referential integrity.

B. Create an inactive relationship between the tables and select Assume referential integrity.

C. Create an inactive relationship between the tables and select Apply security filter in both directions.

The table has 12 million rows. All the columns are needed for analysis. You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data. What should you do?

• B. Disable the Power Query load.

A. Split the DateTime column into separate date and time columns. B. Disable the Power Query load.

C. Round the Longitude column two decimal places.

D. Change the data type of the TempCelsius column to Integer

Micsft PBI DA 100

Authored by H DUHANEY

Instructional Technology, Professional Development

Professional Development

Used 13+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

114 questions

Show all answers

MULTIPLE SELECT QUESTION

2 mins • 1 pt

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.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

MULTIPLE SELECT QUESTION

2 mins • 1 pt

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.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

Expand Column

Convert list to Table

Set Data Type

Expand Column

Set Data Type

Convert list to Table

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

113 questions

D61 MASTER THE DAY

Quiz

•

Professional Development

118 questions

DELTA - Module 1 About Language Terminology

Quiz

•

Professional Development

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Instructional Technology

44 questions

Would you rather...

Quiz

•

Professional Development

20 questions

Black History Month Trivia Game #1

Quiz

•

Professional Development

12 questions

Mardi Gras Trivia

Quiz

•

Professional Development

14 questions

Valentine's Day Trivia!

Quiz

•

Professional Development

7 questions

Copy of G5_U5_L14_22-23

Lesson

•

KG - Professional Dev...

16 questions

Parallel, Perpendicular, and Intersecting Lines

Quiz

•

KG - Professional Dev...

11 questions

NFL Football logos

Quiz

•

KG - Professional Dev...

12 questions

Valentines Day Trivia

Quiz

•

Professional Development

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

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?

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?

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.

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

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

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?

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Instructional Technology

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