Exam (elaborations)
DA-100 EXAM PREP REVIEW QUESTIONS CORRECTLY ANSWERED WITH EXPLANATIONS A+ GRADED.
- Course
- Institution
DA-100 EXAM PREP REVIEW QUESTIONS CORRECTLY ANSWERED WITH EXPLANATIONS A+ GRADED.
[Show more]
Content preview
DA-100 EXAM PREP REVIEW QUESTIONSCORRECTLY ANSWERED WITH EXPLANATIONS
A+ GRADED.
You have a Power BI report and need to create a calculated table to return
the highest spending customers. Complete the DAX expression (drop-down
menus).
• Correct Answer: TOPN, SUMMARIZE, DESC
• Explanation: The TOPN function retrieves the top spending customers,
while SUMMARIZE groups data by specified columns, and DESC orders it
in descending order to identify the highest spenders.
You have two tables named Customers and Invoice in a Power BI model. You
need to define the relationship. What should you configure? (drop-down
menus)
• Correct Answer: One-to-many, Single
• Explanation: A One-to-many relationship links unique records in the
Customers table to multiple records in the Invoice table. The Single
direction of filtering allows filtering only one way, from Customers to
Invoice.
You have a Power BI data model with three tables. If a user has row-level
security clearance for Role 1 and Role 2, what data will they see?
• Correct Answer: The user will see data for which the State Province value
is Kentucky OR the Calendar Year is 2020.
, • Explanation: In Power BI, if multiple roles are assigned, data is displayed
based on the union of roles, so the user sees rows meeting any one role
condition.
Your company has affiliates who help acquire customers. You build a report
for affiliate managers and need a measure to support the visual. How should
you complete the DAX expression? (drop-down menus)
• Correct Answer: CALCULATE, SUM, TOPN, [TransactionDate]
• Explanation: CALCULATE changes the context of the calculation, SUM
aggregates sales or transactions, TOPN identifies top affiliates, and
[TransactionDate] ensures relevance to a time frame.
You are configuring a Power BI data model to allow users to ask natural
language questions using Q&A. What should you do to ensure users get
useful results?
• Correct Answer: Add a synonym of ["subscriber"] to the Customer table.
• Explanation: Adding synonyms helps Power BI understand alternate
terms users may use, improving Q&A functionality and relevance of
results.
You are creating a Power BI data model with tables: Sales, Product,
ProductCategory. How should you configure the relationships? (drop-down
menus)
• Correct Answer: Cardinality: One-to-many, Cross-filter direction: Both
• Explanation: This configuration allows filtering between tables and
supports many-to-one relationships across categories and products for
better data insights.
, You are creating an analytics report that will use data from tables shown
below. To optimize the data model, what should you configure? (drop-down
menus)
• Correct Answer: Employee ID: Hide, Employee Photo: Delete
• Explanation: Hiding Employee ID prevents unnecessary clutter, while
deleting the Employee Photo column reduces dataset size, improving
model performance.
You are creating a Power BI model with two tables, CityData and Sales. True
or False?
• Correct Answer: No, NO, and NOOO
• Explanation: (This seems to be an informal response, but typically would
require specifying relationships or model requirements between these
tables).
You build a report on warehouse inventory data with more than 10 million
product records from 200 warehouses worldwide. You need to modify it to
support warehouse managers' requirements. Which three actions should
you perform in sequence? (drag and drop)
• Correct Answer:
1. Add a column named ProductName.
2. Create a product hierarchy of [ProductCategory,
ProductSubcategory, ProductName].
3. Replace the use of ProductDescription with ProductName.
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 saraciousstuvia. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now