DA-100 Free Practice Test

- (Exam Topic 4)
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?

1. A. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
2. B. Change the Microsoft Power Bl license type of the sales manager.
3. C. Manage the permissions of the underlying dataset
4. D. Request that the sales manager be added to the correct Azure Active Directory group.

Correct Answer: D
Using AD Security Groups, you no longer need to maintain a long list of users.
All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the REST! This means a small and simple security file with the permissions and AD Security group.
Note: Configure role mappings
Once published to Power BI, you must map members to dataset roles.
Members can be user accounts or security groups. Whenever possible, we recommend you map security groups to dataset roles. It involves managing security group memberships in Azure Active Directory. Possibly, it delegates the task to your network administrators.
Reference:
https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-group
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

- (Exam Topic 4)
You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

1. A. stacked area chart
2. B. donut chart
3. C. line chart
4. D. waterfall chart

Correct Answer: C
A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time – a time series – thus the line is often drawn chronologically.
Example:

Reference:
https://www.data-to-viz.com/graph/line.html

- (Exam Topic 4)
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Solution:
Reference:
https://finance-bi.com/power-bi-basket-analysis/

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You have a power BI tenant that hosts the datasets shown in the following table.

You have the following requirements:
• The export of reports that contain Personally Identifiable Information (Pll) must be prevented.
• Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise select No. NOTE: Each correct selection is worth one point

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 1)
You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?

1. A. Create a security role that has a table filter on the Sales_Manager table where username = UserName()
2. B. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
3. C. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
4. D. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

Correct Answer: A
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/