You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

• A.one-to-many from Customer to Transaction
• B.one-to-one between Customer and Transaction
• C.one-to-many from Transaction to Customer
• D.many-to-many between Customer and Transaction

Comment: *

Name: *

Email: *

Verification: *

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a chart that displays a sum of Order[Order_amount] by month for the Order_ship_date column and the Order_date column.
How should you model the data?

• A.Add a second Date table named Ship_date to the model. Create a one-to-many relationship from Date [Date_ID] to Order[Order_date] and a one-to-many relationship from Ship_Date[Date_ID] to Order [Order_ship_date].
• B.Add a second Date table named Ship_date to the model. Create a many-to-many relationship from Date[Date_ID] to Order[Order_date] and many-to-many relationship from Ship_date[Date_ID] to Order [Order_ship_date].
• C.Create a one-to-many relationship from Date[Date_ID] to Order[Order_date] and another relationship from Date[Date_ID] to Monthly_returns[Date_ID].
• D.Create a one-to-many relationship from Date[Date_ID] to Order[Order_date] and another relationship from Date[Date_ID] to Order[Order_ship_date].

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI report that is configured to use row-level security (RLS).
You have the following roles:
- A manager role that limits managers to see only the sales data from
the stores they manage
- A region role that limits users to see only the data from their
respective region
You plan to use Power BI Embedded to embed the report into an application. The application will authenticate the users.
You need to ensure that RLS is enforced when accessing the embedded report.
What should you do?

• A.In the access token for the application, include the report URL and the Microsoft Azure Active Directory domain name.
• B.From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access.
• C.From dev.powerbi.com/apps, register the new application and enable the Read All Groups API access.
• D.In the access token for the application, include the user name and the role name.

Comment: *

Name: *

Email: *

Verification: *

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.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: CALCULATE
Start with CALCULATE and use a SUMX.
CALCULATE evaluates an expression in a modified filter context.
Box 2: SUMX
SUMX returns the sum of an expression evaluated for each row in a table.
The following sample creates a measure with the sales of the top 10 sold products.
= SUMX(TOPN(10, SUMMARIZE(Product, [ProductKey], "TotalSales",
SUMX(RELATED(InternetSales_USD[SalesAmount_USD]), InternetSales_USD[SalesAmount_USD]) + SUMX(RELATED(ResellerSales_USD[SalesAmount_USD]), ResellerSales_USD[SalesAmount_USD])) Box 3: TOPN TOPN returns the top N rows of the specified table.
Box 4: [TransactionDate]
TOPN Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>,
[<order>]]...])
The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table.
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax

Comment: *

Name: *

Email: *

Verification: *

Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
- Executives require a visual that shows sales by region.
- Regional managers require a visual to analyze weekly sales and
returns.
- Sales managers must be able to see the sales data of their respective region only.
- The sales managers require a visual to analyze sales performance
versus sales targets.
- The sale department requires reports that contain the number of sales transactions.
- Users must be able to see the month in reports as shown in the
following example: Feb 2020.
- The customer service department requires a visual that can be
filtered by both sales month and ship month independently.
What should you create to meet the reporting requirements of the sales department?

• A.a calculated measure that uses a formula of couNTROws(Sales)
• B.a calculated column that uses a formula of suM(Sales[sales_id])
• C.a calculated column that use a formula of couMTA(Sales[sales_id]>
• D.a measure that uses a formula of sw-i(Sales[sales_id])

Comment: *

Name: *

Email: *

Verification: *