Power BI - DA100 APPROVED QUESTIONS AND ANSWERS 100% GUARANTEED GRADE A+
2 views 0 purchase
Course
DA-100 Analyzing Data with Microsoft Power BI
Institution
DA-100 Analyzing Data With Microsoft Power BI
Power BI - DA100 APPROVED QUESTIONS AND ANSWERS 100% GUARANTEED GRADE A+
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 networ...
,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
A
based on the emails they sent.
B. Remove the Subject and Body columns during the import.
VI
C. From Model view, set the Subject and Body columns to Hidden. - ANSWER B
The Impressions table contains approximately 30 million records per month.You need to
TU
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?
IS
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.
M
B. Create one-to-many relationships between the tables.
C. Create a calculated measure that aggregates by using the COUNTROWS function.
O
D. Create a calculated table that contains Ad_id, Site_name, and Impression_date. -
ANSWER A,B
A
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
N
you add?
A. video
B. custom streaming data
JP
C. text box
D. web content - ANSWER D
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 - ANSWER D
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
A
✑ Phone number
VI
You import the list into Power Query Editor.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
TU
solution.NOTE: Each correct selection is worth one point.
A. Open the Advanced Editor.
B. Select Column quality.
C. Enable Column profiling based on entire dataset.
IS
D. Select Column distribution.
E. Select Column profile.
Reveal Solution - ANSWER C,E
M
You import two Microsoft Excel tables named Customer and Address into Power Query.
Customer contains the following columns:
O
✑ Customer ID
✑ Customer Name
✑ Phone
A
✑ Email Address
✑ Address ID
N
Address contains the following columns:
✑ Address ID
✑ Address Line 1
JP
✑ Address Line 2
✑ City
✑ State/Region
✑ Country
✑ Postal Code
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?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller JPNAOMISTUVIA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
