Exam (elaborations)
DA-100 Exam Questions with 100% Correct Answers |Verified
- Course
- Institution
DA-100 Exam Questions with 100% Correct Answers |Verified
[Show more]
Content preview
DA-100 Exam Questions with 100% CorrectAnswers |Verified
· B. Set Data Connectivity mode to DirectQuery. - ✔✔You have an Azure SQL database that
contains sales transactions. The database is updated frequently. You need to generate reports
from the data to detect fraudulent transactions. The data must be visible within five minutes of
an update. How should you configure the data connection?
· A. Add a SQL statement.
· B. Set Data Connectivity mode to DirectQuery.
· C. Set the Command timeout in minutes setting.
· D. Set Data Connectivity mode to Import.
· B. The user will see data for which the State Province value is Kentucky or the Calendar Year is
2020. - ✔✔You have a Microsoft Power BI data model that contains three tables named
Orders, Date, and City. There is a one-to-many relationship between Date and Orders and
between City and Orders. The model contains two row-level security (RLS) roles named Role1
and Role2. Role1 contains the following filter. City[State Province] = "Kentucky"
Role2 contains the following filter.
Date[Calendar Year] = 2020
-If a user is a member of both Role1 and Role2, what data will they see in a report that uses the
model?
1. Calculate
2. Sum
3. TopN
4. [TransactionDate] - ✔✔Your company has affiliates who help the company acquire
customers. You build a report for the affiliate managers at the company to assist them in
understanding affiliate performance. The managers request a visual showing the total sales
value of the latest 50 transactions for each affiliate. You have a data model that contains the
following tables.
,You need to develop a measure to support the visual. How should you complete the DAX
expression? To answer, select the appropriate options in the answer area.
· B. Add a synonym of "subscriber" to the Customer table. - ✔✔You are configuring a
Microsoft Power BI data model to enable users to ask natural language questions by using Q&A.
You have a table named Customer that has the following measure. Customer Count =
DISTINCTCOUNT(Customer[CustomerID]) Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A.
The solution must minimize the size of the model. What should you do?
· A. Set Summarize By to None for the CustomerID column.
· B. Add a synonym of "subscriber" to the Customer table.
· C. Add a synonym of "subscriberID" to the CustomerID column.
· D. Add a description of "subscriber count" to the Customer Count measure.
1. One-to-Many
2. Both - ✔✔You are creating a Microsoft Power BI data model that has the tables shown in
the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID
column. You need to ensure that you can analyze sales by product category. How should you
configure the relationships from Products to ProductCategory? To answer, select the
appropriate options in the answer area.
1. Base value = Total Sales
2. Date = Date
3. Period = Months - ✔✔You are creating a quick measure as shown in the following exhibit.
, You need to create a monthly rolling average measure for Sales over time. How should you
configure the quick measure calculation? To answer, select the appropriate options in the
answer area.
C. Request that the sales manager be added to the correct Azure Active Directory group. -
✔✔You have four sales regions. Each region has multiple sales managers.You implement
row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales
records of their region. The sales managers are prevented from viewing records from other
regions. A sales manager changes to a different region. You need to ensure that the sales
manager can see the correct sales data. What should you do?
A. Change the Microsoft Power BI license type of the sales manager.
B. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports.
C. Request that the sales manager be added to the correct Azure Active Directory group.
D. Manage the permissions of the underlying dataset.
1. Divide
2. Calculate
3. All Selected - ✔✔You have a Microsoft Power BI data model that contains three tables
named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales]
that sums the total sales from the Sales table. You need to write a calculation that returns the
percentage of total sales that a selected ProductCategoryName value represents. The
calculation must respect any slicers on ProductCategoryName and must show the percentage
of visible total sales. For example, if there are four ProductCategoryName values, and a user
filters one out, a table showing ProductCategoryName and the calculation must sum up to 100
percent. How should you complete the calculation? 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.
D. Create an active relationship between Sales and Date for the purchase date and an inactive
relationship for the ship date. - ✔✔You have sales data in a star schema that contains four
tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship
dates. Most often, you will use the purchase date to analyze the data, but you will analyze the
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 Examsplug. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.24. 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