Exam (elaborations)
DA-100 (Data Analyst) EXAM QUESTIONS AND ANSWERS LATEST AND FREQUENTLY TESTED.
- Course
- Institution
DA-100 (Data Analyst) EXAM QUESTIONS AND ANSWERS LATEST AND FREQUENTLY TESTED.
[Show more]
Content preview
DA-100 (Data Analyst) EXAM QUESTIONS ANDANSWERS LATEST AND FREQUENTLY TESTED.
CASE STUDY - LITWARE
You need to provide a solution to provide the sales managers with the
required access. What should you include in the solution?
A. Create a security role that has a table filter on the Sales_Manager table
where username = UserName()
B. Create a security role that has a table filter on the Region_Manager table
where sales_manager_id = UserPrincipalName().
C. Create a security role that has a table filter on the Sales_Manager table
where name = UserName().
D. Create a security role that has a table filter on the Sales_Manager table
where username = sales_manager_id.
Verified Answer -B. Create a security role that has a table filter on the
Region_Manager table where sales_manager_id = UserPrincipalName().
LOOK AT THE ACTUAL TABLES THOUGH
CASE STUDY - LITWARE
You need to create relationships to meet the reporting requirements of the
customer service department. What should you create?
,A. an additional date table named ShipDate, a one-to-many relationship
from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship
from Sales[sales_ship_date_id] to ShipDate[date_id]
B. an additional date table named ShipDate, a many-to-many relationship
from Sales[sales_date_id] to Date[date_id], and a many-to-many
relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
C. a one-to-many relationship from Date[date_id] to Sales[sales_date_id]
and another one-to-many relationship from Date[date_id] to
Weekly_Returns[week_id]
D. a one-to-many relationship from Sales[sales_date_id] to Date[date_id]
and a one-to-many relationship from Sales[sales_ship_date_id] to
Date[date_id]
E. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] an
Verified Answer -E. a one-to-many relationship from Date[date_id] to
Sales[sales_date_id] and another one-to-many relationship from
Date[date_id] to Sales [sales_ship_date_id]
CASE STUDY - CONTOSO
Which DAX expression should you use to get the ending balances in the
balance sheet reports?
A. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD(
'Date'[Date] ) )
B. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE(
'Date'[Date] ) )
C. FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) )
D. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date'
[Date] ) )
,Verified Answer -A. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ),
DATESQTD( 'Date'[Date] ) )
CASE STUDY - CONTOSO
You need to calculate the last day of the month in the balance sheet data to
ensure that you can relate the balance sheet data to the Date table. Which
type of calculation and which formula should you use? To answer, select the
appropriate options in the answer area.
Verified Answer -1. A DAX calculated measure
2. Date.EndOfQuarter(#date([Year]),[Month],1))
CASE STUDY - lITWARE
Verified Answer -1. KPI
2. Sales[sales_amount]
3. Date[month]
4. Targets[sales_target]
CASE STUDY - CONTOSO
You need to create a DAX measure in the data model that only allows users
to see projections at the appropriate level of granularity. How should you
complete the measure? To answer, drag the appropriate values to the
correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
Verified Answer -1. IF
, 2. IS FILTERED
3. SUM
CASE STUDY - CONTOSO
Which two types of visualizations can be used in the balance sheet reports
to meet the reporting goals? Each correct answer presents part of the
solution.NOTE: Each correct selection is worth one point.
A. a line chart that shows balances by quarter filtered to account categories
that are long-term liabilities.
B. a clustered column chart that shows balances by date (x-axis) and
account category (legend) without filters.
C. a clustered column chart that shows balances by quarter filtered to
account categories that are long-term liabilities.
D. a pie chart that shows balances by account category without filters.
E. a ribbon chart that shows balances by quarter and accounts in the legend.
Verified Answer -A. a line chart that shows balances by quarter filtered to
account categories that are long-term liabilities.
C. a clustered column chart that shows balances by quarter filtered to
account categories that are long-term liabilities.
CASE STUDY - CONTOSO
How should you distribute the reports to the board? To answer, select the
appropriate options in the answer area.NOTE: Each correct selection is
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.69. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now