Power BI DA-100 Certification Exam Questions and CORRECT Answers

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.What should you do? A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent. B. Remove the Subject and Body columns during the import. C. From Model view, set the Subject and Body columns to Hidden. - B 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.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. A. Group the impressions by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function. B. Create one-to-many relationships between the tables.