Microsoft Power BI Test – 5

Your boss asks you to build a visual for each Manager’s sales by Subcategory.
What do you need to configure to solve that problem?

Select 1 option(s):

You want to create a hierarchy in the products table for Category and Subcategory. You will then use the hierarchy as a drill down for a sales by product visualization as per the below exhibit.
What three actions should you perform in sequence?

Select 1 option(s):

You need to create a table containing unique combinations of category and subcategory and aggregated sales.
What DAX expression should you use?

Select 1 option(s):

You work as a Power BI professional within your company’s HR group. You are creating a data model to use for reporting within the group. As you start building relationships, you see there are issues connecting some of the tables.
What two fixes are required to get the relationships working in your data model?

Select 1 option(s):

You work as a Power BI professional within your company’s HR group. The report you created for retention analysis worked fine in the development environment, but when deployed has performance issues.
Solution: Remove columns from the data model not used in reports
Does this solution meet the goal?

Select 1 option(s):

You work as a Power BI professional within your company’s HR group. The report you created for retention analysis worked fine in the development environment, but when deployed has performance issues.
Solution: Hide columns and tables from the data model not used in reports
Does this solution meet the goal?

Select 1 option(s):

What are the three steps required before you can use Python in Power BI?

Select 3 option(s):

What two optimizations should you do?

Select 2 option(s):

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Select 1 option(s):

Which roles should you use for the below workspace requirements?
1. Update and delete workspaces
2. Publish apps
3. Publish content to the workspace

Select 1 option(s):

· If the value is greater than 80 and Units are F, then ‘Hot’. Otherwise ‘Not Hot’
· If the value is greater than 26 and Units are C, then ‘Hot’. Otherwise ‘Not Hot’
Complete the below DAX expression by replacing [VALUE]:
Category =
[VALUE] ( [VALUE] ( [VALUE] (Temperature[Value] > 80,Temperature[Units]=“F“), [VALUE] (Temperature[Value] > 26,Temperature[Units]=“C“) ),“Hot“,“Not Hot“)

Select 1 option(s):

She asks you to use a particular theme for your company’s report in Power BI Service.
How do you incorporate the theme in your report?

Select 1 option(s):

What could be two possible explanations for data lineage not working?

Select 2 option(s):

How would you create the Employee_Hierarchy column with a delimited hierarchy list in DAX?

Select 1 option(s):

1. Accessories table: 1k rows that are updated monthly
2. Sales table: 15M rows that are updated regularly with changes that need to be shown immediately
3. Date table: 10k rows that are updated rarely
For the three tables ABOVE, which storage mode should you use from the below options?
· Import
· DirectQuery
· Dual

Select 1 option(s):

What should you configure in your report such that the page follows a logical sequence?

Select 1 option(s):

Which transform should you use to create the dataset?

Select 1 option(s):

For each of the following statements, select  Yes is the statement is true. Otherwise, select No.

Select 1 option(s):

Which visual should you choose?

Select 1 option(s):

Select the proper DAX functions to correctly complete the formula by replacing the [VALUE] field:
Top Hat Sales = [VALUE] ( 3,
[VALUE] ( HatSales, HatTeams[Team Name], “Transactions“, COUNT(HatSales[TransactionID])
), [Transactions],DESC)

Select 1 option(s):

How would you find the percentage of empty cells in each column?

Select 1 option(s):

How can you meet this requirement?

Select 1 option(s):

When the data reloads, it takes excessive time as the full seven years are refreshed.
How can you improve the dataset performance?

Select 1 option(s):

What data preview option is used to create these charts?

Select 1 option(s):

· Region_Texas filter is: Region[state] = “Texas”
· Shipping_Mode filter is: Shipping[mode] = “Rail”
If a manager is a member of both the Region_Texas and Shipping_Mode roles, what will they see in a report using this data model?

Select 1 option(s):

Your boss asks you the cause of this issue.
What is the reason not all data is shown?

Select 1 option(s):

What TWO solutions will help optimize your visuals?

Select 2 option(s):

You need to create a common date for a data model using DAX, respecting the fiscal period.
How should you create a date table using DAX?

Select 1 option(s):

· A column chart of parts on the axis, but there are too many products showing
· A stacked column chart of month number and order type, but too many months show
· A histogram of supplier order sizes, but there are too many order sizes
You need to combine the data to make the visual more readable.
How should you combine the data? Select the GROUPING TYPE for each of the THREE solutions below from top to bottom.
1. Combined the product into categories of product
2. Combine the columns into 3 month number blocks
3. Combine order sizes into 8 groups

Select 1 option(s):

Sales 2021 =
CALCULATE(
[Points Total],
FILTER( [VALUE] (‘Date‘[Year]), ‘Date‘[Year] = 2021)
)

Select 1 option(s):

What are TWO possible reasons insights is not working?

Select 2 option(s):

How would you achieve this goal?

Select 1 option(s):

How would you provide the additional piece of data?

Select 1 option(s):

How do you add the dotted horizontal line for the mean values?

Select 1 option(s):

How would you achieve this goal?
Annual Sales Growth % =
DIVIDE(
([Sales] – CALCULATE([Sales], PARALLELPERIOD(‘Date‘[Date], -12, MONTH))),
CALCULATE([Sales], PARALLELPERIOD(‘Date‘[Date], -12, MONTH))
)

Select 1 option(s):

How would you complete the DAX expression below to generate a Model table? What would you fill in for the [VALUE] fields starting from left to right?

Model Table = [VALUE] ( [VALUE] )

Select 1 option(s):

What is the most efficient way to check your data for negatives before creating the data model?

Select 1 option(s):

You need to create relationships in the data model to enable a visual containing data from both tables.
How would you model these two tables in the most efficient manner?

Select 1 option(s):

You need to configure email alerts to management when this happens.
Which four actions should you perform to create this alert?

Select 4 option(s):

What visual in Power BI can help you achieve your goal?

Select 1 option(s):

Which of the following configurations will allow Q&A to work in your data model?

Select 1 option(s):

Select 3 option(s):

When you click on drill through on the sales by month chart, it should redirect to a detail page called Sales Detail that shows sales for the selected month by category. The Sales Detail page should also preserve the filters from the original sales page.
What FOUR actions should you perform?

Select 4 option(s):

What should you do to save the views across different years for your presentation?

Select 1 option(s):

You are asked to create three different types of visuals for the marketing department.
Which visualization should you use for the below three requirements?
1. Show progress of conversion rates against a target
2. Identify outliers in sentiment scores
3. Show the factors that influence sentiment scores

Select 1 option(s):

Which three things can you do to optimize reports for mobile?

Select 3 option(s):

What should you do?

Select 1 option(s):

You are emailed a new Excel workbook from the CEO that contains updated data. You place the new Excel workbook on your server and append the text ‘v1.2’ to the name.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Select 1 option(s):

What would you suggest to your manager?

Select 1 option(s):

You thoroughly test the report and then upload it to Power BI Service. However, once in Power BI Service, the visualizations no longer work.
How would you solve this problem?

Select 1 option(s):

You work as a BI analyst for a software company that allows users to manipulate images online.
You have built a report that shows the conversion from free customers to premium customers.
Your boss has asked you to provide a filter for the ‘marketing’ industry.
Solution:
· Apply a filter on all pages of the report for the ‘marketing’ industry
· Share the report
· Mark share report with current filters and slicer options
Does this solution meet the requirements?

Select 1 option(s):

You work as a BI analyst for a software company that allows users to manipulate images online.
You have built a report that shows the conversion from free customers to premium customers.
Your boss has asked you to provide a filter for the ‘marketing’ industry.
Solution:
· Create a text parameter for industry
· Set the parameter equal to ‘marketing’
· Create a query parameter on the industry column
Does this solution meet the requirements?

Select 1 option(s):

You work as a BI analyst for a software company that allows users to manipulate images online.
You have built a report that shows the conversion from free customers to premium customers.
Your boss has asked you to provide a filter for the ‘marketing’ industry.
Solution:
· Add a slicer to the report and select the ‘marketing’ industry
· Sync slicers to all relevant pages of the report
Does this solution meet the requirements?

Select 1 option(s):

You work for a financial institution, and you have built a data model and report in Power BI desktop. The report ran fine during testing, but when in production, users are complaining of performance issues.
How can you improve the model’s performance?
Solution: Hide intermediate tables in the model view
Does this help improve performance?

Select 1 option(s):

You work for a financial institution, and you have built a data model and report in Power BI desktop. The report ran fine during testing, but when in production, users are complaining of performance issues.
How can you improve the model’s performance?
Solution: Convert source PO text column into a number by removing prefix, e.g. ‘PO12399’ to 12399
Does this help improve performance?

Select 1 option(s):

You work for a financial institution, and you have built a data model and report in Power BI desktop. The report ran fine during testing, but when in production, users are complaining of performance issues.
How can you improve the model’s performance?
Solution: Remove unnecessary columns
Does this help improve performance?

Select 1 option(s):

You have the schema for the tables used in a bicycle franchise. In your role as a BI consultant, you have been asked to generate some insights from the data.
Company data schema:

You are asked to create a visualization for the sales by product. However, what should you do before creating a relationship?

Select 1 option(s):

You have the schema for the tables used in a bicycle franchise. In your role as a BI consultant, you have been asked to generate some insights from the data.
Company data schema:

The product table’s color column has abbreviations as well as names. For instance, there is both Black and BLK.
What do you need to do to ensure consistency in the color column?

Select 1 option(s):

You have the schema for the tables used in a bicycle franchise. In your role as a BI consultant, you have been asked to generate some insights from the data.
Company data schema:

When reviewing the customer table, you find that some of the postcodes appear to be missing. For instance ‘0800’ does not seem to exist.
What do you need to do to ensure all the Postcodes from the original data are in your model?

Select 1 option(s):

You are a Power BI specialist at your organization. In your finance table, you have a column called margin, which is defined as ‘margin = revenue – cost of goods sold.’ In your company, there are several different ways people refer to margin. Some people call margin by other terms such as income, profit or profit margin.
To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to enable users to type in variations for margin.
Solution: Add Synonyms to the finance table
Does this solution meet the goal?

Select 1 option(s):

You are a Power BI specialist at your organization. In your finance table, you have a column called margin, which is defined as ‘margin = revenue – cost of goods sold.’ In your company, there are several different ways people refer to margin. Some people call margin by other terms such as income, profit or profit margin.
To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to enable users to type in variations for margin.
Solution: Add a detailed description of how you defined margin
Does this solution meet the goal?

Select 1 option(s):

You are a Power BI specialist at your organization. In your inventory table, there are several different ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or supply.
To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and columns.
Solution: Set the row label on the inventory table
Does this solution meet the goal?

Select 1 option(s):

You are a Power BI specialist at your organization. In your inventory table, there are several different ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or supply.
To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and columns.
Solution: Use Teach Q&A
Does this solution meet the goal?

Select 1 option(s):

What should you do to achieve this goal?

Select 1 option(s):