Power BI Data Analyst Associate
Read questions, check verified answers and discuss the reasoning. Use reading options to shape your revision, or switch to the simulator for timed practice.
164 questions in this view
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create an average line by using the Salary measure.
Does this meet the goal?
Select an answer above, then submit your vote. Reading or practicing does not cast a vote.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?
Select an answer above, then submit your vote. Reading or practicing does not cast a vote.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?
Select an answer above, then submit your vote. Reading or practicing does not cast a vote.
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
You are creating a Power BI semantic model named Model1 that contains the following tables.
|
Name |
Description |
|
Sales |
Contains five columns named CityID, ProductID, SaleAmount, SalespersonID, and SaleDate that store sales transaction data loaded from the external data warehouse |
|
CityData |
Contains city details, including population, state, and country |
|
Salesperson |
Contains a column named SalespersonID and one row for each salesperson |
The tables have the following relationships.
|
From table |
From column |
To table |
To column |
Relationship |
|
Sales |
SalespersonID |
Salesperson |
SalespersonID |
Active |
|
Sales |
CityID |
CityData |
CityID |
Active |
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You remove the Salesperson table.
Does this meet the goal?
Select an answer above, then submit your vote. Reading or practicing does not cast a vote.
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
You are creating a Power BI semantic model named Model1 that contains the following tables.
|
Name |
Description |
|
Sales |
Contains five columns named CityID, ProductID, SaleAmount, SalespersonID, and SaleDate that store sales transaction data loaded from the external data warehouse |
|
CityData |
Contains city details, including population, state, and country |
|
Salesperson |
Contains a column named SalespersonID and one row for each salesperson |
The tables have the following relationships.
|
From table |
From column |
To table |
To column |
Relationship |
|
Sales |
SalespersonID |
Salesperson |
SalespersonID |
Active |
|
Sales |
CityID |
CityData |
CityID |
Active |
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You remove the CityID column from the Sales table.
Does this meet the goal?
Select an answer above, then submit your vote. Reading or practicing does not cast a vote.
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
You are creating a Power BI semantic model named Model1 that contains the following tables.
|
Name |
Description |
|
Sales |
Contains five columns named CityID, ProductID, SaleAmount, SalespersonID, and SaleDate that store sales transaction data loaded from the external data warehouse |
|
CityData |
Contains city details, including population, state, and country |
|
Salesperson |
Contains a column named SalespersonID and one row for each salesperson |
The tables have the following relationships.
|
From table |
From column |
To table |
To column |
Relationship |
|
Sales |
SalespersonID |
Salesperson |
SalespersonID |
Active |
|
Sales |
CityID |
CityData |
CityID |
Active |
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You summarize the data in the Sales table by SalesPersonID.
Does this meet the goal?
Select an answer above, then submit your vote. Reading or practicing does not cast a vote.