Exam (elaborations)
DA-100 EXAM STUDY QUESTIONS AND ANSWERS A+ GRADED
- Course
- Institution
DA-100 EXAM STUDY QUESTIONS AND ANSWERS A+ GRADED
[Show more]
Content preview
DA-100 EXAM STUDY QUESTIONS ANDANSWERS A+ GRADED.
Scenario 1: You need to modify the Date table’s date_id column to allow
users to view the month in reports in a "Feb 2020" format.
• Correct Answer: Use a calculated column to convert the date_id to a
"MMM YYYY" format.
• Explanation: A calculated column enables custom formatting by
extracting the month and year from the date_id column. This approach
allows Power BI to display dates in the desired format, such as "Feb
2020," without altering the raw data.
Scenario 2: Litware, Inc. uses Azure Active Directory (Azure AD) for
authentication. Users are concerned about data completeness and need to
check for negative sales amounts. What should you do?
• Correct Answer: Create a calculated column to flag or filter out negative
sales amounts.
• Explanation: Adding a calculated column that identifies rows with
negative values ensures data quality by enabling quick identification and
removal or filtering of erroneous data points.
Scenario 3: Litware’s Date table uses yyyymmdd for date_id and yyyymm for
month. You need to format the month column for reports to display only the
month name (e.g., "Feb").
• Correct Answer: Use Power BI's FORMAT function in a calculated
column to display only the month name.
, • Explanation: The FORMAT function can transform dates to display month
names, which meets report requirements without modifying the
underlying month column.
Scenario 4: The Date table has a week column in yyyyww format, while the
Weekly_Returns table has a week_id column in the same format. Region
managers need a visual to analyze weekly sales and returns. What should
you do?
• Correct Answer: Create a relationship between the Date and
Weekly_Returns tables using the week and week_id columns.
• Explanation: Establishing a relationship based on shared weekly
identifiers allows accurate alignment of weekly data across both tables,
enabling region managers to view and compare weekly sales and returns.
Scenario 5: Litware’s data model includes a region_id column managed by
only one sales manager per region. You need to visualize weekly sales and
returns data.
• Correct Answer: Create a one-to-many relationship between region_id in
the region manager table and the sales data table.
• Explanation: Setting up a one-to-many relationship allows the region
managers to accurately track and manage their specific regional data, as
each region is linked to one manager, ensuring effective sales analysis at
a regional level.
Scenario 6: Litware, Inc. requires a visual that shows sales performance
compared to sales targets. What type of visual and data fields should be
used?
• Correct Answer:
, o Box 1: KPI
o Box 2: Sales[sales_amount]
o Box 3: Date[month]
o Box 4: Targets[sales_target]
• Explanation: A Key Performance Indicator (KPI) visual is ideal for
displaying progress toward a measurable goal, such as a sales target.
Here, sales_amount represents actual sales data, month shows the time
trend, and sales_target provides the benchmark value. KPIs help sales
managers assess performance at a glance, making it easy to identify
areas that are meeting or falling short of targets.
Scenario 7: Contoso, Ltd. prepares quarterly financial reports using multiple
data sources, including revenue projections for the upcoming quarter. How
can Contoso sum monthly projections to display quarterly results in Power
BI?
• Correct Answer:
o Box 1: IF
o Box 2: ISFILTERED
o Box 3: SUM
• Explanation: The ISFILTERED function in DAX helps determine if a
particular column, such as month, is filtered. When combined with the IF
and SUM functions, it allows for conditional calculations, such as
aggregating monthly projections into a quarterly total. This approach
provides accurate data roll-ups to meet the financial reporting
requirements.
, Scenario 8: Contoso requires a calculated measure to determine the end of
each quarter. What DAX function should be used, and how should it be
implemented?
• Correct Answer:
o Box 1: A DAX Calculated measure
o Box 2: Date.EndofQuarter(#date([Year],[Month],1))
• Explanation: The ENDOFQUARTER DAX function returns the last date of
the quarter based on the specified date column, facilitating quarterly
financial analysis. Using this function in a calculated measure, Contoso
can create an accurate quarterly endpoint, which is essential for
compiling precise quarterly financial statements and projections.
Scenario 9: Contoso's financial analysts want to visualize quarterly
projections alongside profit and loss data using shared dimensions. How
should this data model be set up to maintain consistency?
• Correct Answer:
o Ensure that quarterly projections use the same shared dimensions
(such as date and department) as the profit and loss data.
• Explanation: By aligning quarterly projections with the profit and loss
statements using shared dimensions, such as Date and Department,
Contoso can maintain consistency across reports. This setup allows for
seamless data integration and accurate financial comparisons,
supporting more cohesive insights for decision-makers.
Scenario 10: To optimize Contoso’s quarterly financial reports, which
reference sources should be connected, and how can Power BI integrate
these data streams effectively?
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 $20.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