Exam (elaborations)
Power BI - DA100 QUESTIONS WITH ALL PASSED ANSWERS 2024
- Course
- Institution
Power BI - DA100 QUESTIONS WITH ALL PASSED ANSWERS 2024
[Show more]
Seller
Follow
Content preview
10/31/24, 3:03 AM Power BI - DA100 Flashcards | QuizletEUNICE
‘
Power BI - DA100QUESTIONS WITH ALL PASSED ANSWERS
2024
Terms in this set (53)
You have a custom connector that returns B
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.
https://quizlet.com/709649430/power-bi-da100-flash-cards/ 1/21
,10/31/24, 3:03 AM Power BI - DA100 Flashcards | Quizlet
The Impressions table contains A,B
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.
C. Create a calculated measure that
aggregates by using the COUNTROWS
function.
D. Create a calculated table that contains
Ad_id, Site_name, and Impression_date.
Your company has training videos that are D
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
You open a query in Power Query D
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
https://quizlet.com/709649430/power-bi-da100-flash-cards/ 2/21
, 10/31/24, 3:03 AM Power BI - DA100 Flashcards | Quizlet
You have a prospective customer list that C,E
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 want to target a marketing
campaign.Which two actions should you
perform? Each correct answer presents
part of the 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.
D. Select Column distribution.
E. Select Column profile.
Reveal Solution
You import two Microsoft Excel tables A
named Customer and Address into Power
Query. Customer contains the following
columns:
✑ Customer ID
✑ Customer Name
✑ Phone
✑ Email Address
✑ Address ID
Address contains the following columns:
✑ Address ID
✑ Address Line 1
✑ 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?
A. Merge the Customer and Address
tables.
B. Transpose the Customer and Address
tables.
C. Group the Customer and Address tables
by the Address ID column.
D. Append the Customer and Address
tables.
https://quizlet.com/709649430/power-bi-da100-flash-cards/ 3/21
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 mbitheeunice2015. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77858 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now