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 each State/Region to which you […]

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 Explanation: Column quality: In this section, we can easily see valid, Error […]

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 Explanation: The only way to visualize a streaming dataset is to add […]

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 required. • Minimize the data […]

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 […]

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 data type of the Date column to Text. […]

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 you are able to complete all questions […]

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 you are able to complete all question […]