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…
You need to design the data model to meet the report requirements. What should you do in Power BI Desktop? A. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter…
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.…
What is the minimum number of Power BI datasets needed to support the reports? A. two imported datasets B. a single DirectQuery dataset C. two DirectQuery datasets D. a single imported dataset
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 need to review the data for which there are concerns before creating the data model. What should you do in Power Query Editor? A. Transform the sales_amount column to replace negative values with 0. B. Select Column distribution. C.…
You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use? A. FORMAT(‘Date’, “MMM YYYY”) B. FORMAT(‘Date’ , “M YY”) C. FORMAT(‘Date'[date_id], “MMM”) & – & FORMAT(‘Date’, “#”) D.…
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.…