DA-100

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields: - First name - Last name - Email address - State/Region - Phone number You import the list into Power Query Editor. You need to ensure that the list contains records for...

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 whitespaceB . Column profileC . Column distributionD . Column qualityView AnswerAnswer: D Explanation: Column quality: In this...

DRAG DROP 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....

You have the tables shown in the following table. 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...

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 . videoB . custom streaming dataC . text boxD . web contentView AnswerAnswer: B Explanation: The only way to...

Testlet 1 Case Study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that...

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

Question Set 3 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. What should you do?A . Round the hour of the Date column to startOfHour.B . Change the...

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?A . Split the model into multiple models.B ....

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