Microsoft Power BI Test – 4

How can you achieve this?

Select 1 option(s):

What could be TWO reasons for these issues?

Select 2 option(s):

Select 1 option(s):

Which two visuals can you NOT create a data alert.

Select 2 option(s):

How do you complete the three fields below?

Select 1 option(s):

When reviewing the data in Power BI, you want to check the distinct and unique rows for each column.

Select 1 option(s):

How can you create the same report for each department in the most efficient manner?

Select 1 option(s):

1. When Power BI Service launches, I want the competition report to be displayed on their screen.
2. For the financial dashboard, I want the classification of the data clearly displayed.
3. I want you to highlight particular reports because it is valuable and worthwhile for others to use. I also don’t want you to ask permission from the Power BI Admin each time.
For the above requirements, them as either:
· Certified
· Promoted
· Featured
· Sensitivity Label

Select 1 option(s):

What are the two ways you could do this?

Select 2 option(s):

Select 1 option(s):

What are the three most important parts of publishing an app?
“
Select THREE from the below.

Select 3 option(s):

What do you need to make the connection and what type of query connection can you use?
Select the THREE correct responses.

Select 3 option(s):

How would you identify the cause of the poorly performing report elements?

Select 1 option(s):

What are TWO key considerations to enable automatic page refresh?

Select 2 option(s):

What sort of visualization can help?

Select 1 option(s):

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

Select 1 option(s):

Select 2 option(s):

What transformation should you use?

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

In Power BI Desktop you create roles for each country e.g. USA, Canada, UK, France etc. You add a DAX expression for each role in the region table to filter country. You then add an Azure Active Directory security group for the country to each role. A new user starts in France.
What do you need to do for the new user such that they can only see the sales data for France?

Select 1 option(s):

What are the two options for configuring an alert in Power BI Service?

Select 2 option(s):

Select 1 option(s):

What fields should be used from the exhibit below in the KPI wells: Indicator, Trend Axis and Target Goals?

Select 1 option(s):

What is a possible cause for ‘view native query’ being disabled?

Select 1 option(s):

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

Select 1 option(s):

· DestinationZIP
· Weight
· Units

Select 1 option(s):

How would you go about achieving this objective?

Select 1 option(s):

How would you achieve this goal using a DAX expression?

Select 1 option(s):

The new users compain that they cannot create new workspaces. What three actions do you need to take in sequence in the admin portal to fix this issue?
Possible actions:
i. Navigate to Power BI admin portal and select Tenant settings
ii. Navigate to office 365 admin security and select settings
iii. Choose specific security groups to apply to and add DA100Workspace
iv. Click on Workspace settings and then click on create workspaces
v. Click refresh

Select 1 option(s):

How would you go about doing this in the most efficient manner?

Select 1 option(s):

How would you calculate last month’s sales percentage change?

Select 1 option(s):

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

Select 1 option(s):

How would you complete the below conditional formatting table?

Select 1 option(s):

You need to create a bar chart that shows wine fermentation time in ranges of 5 months.
When creating the bar chart, which four actions should you perform in sequence?

Select 1 option(s):

How would you go about creating a DAX measure to calculate this?

Select 1 option(s):

What two things can you do to optimize the report performance?

Select 2 option(s):

Your boss wants to know the median sales, the 50th percentile of values in a column, rather than the total sales for each category.
What are the two ways to achieve this goal?

Select 2 option(s):

To answer, select the following feature for each requirement from top to bottom. A feature may be used once, more than once, or not at all.
Features:
· Back button
· Tab selection
· Bookmarks
· Edit interactions
· Format pane

Select 1 option(s):

What five actions should you take in sequence from the below set of potential steps.
· Open performance analyzer and press start recording
· Ineract with the visuals
· Restart Power BI
· Press stop and review results
· Open query diagnostics and press start recording
· Click on SQL Server diagnostics
· Check enable diagnostics logging
· Create a blank report page

Select 1 option(s):

What are the three possible reasons why Quick Insights is not working?

Select 3 option(s):

You need to configure the visual interaction between the two charts.

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

Select 1 option(s):

Which of the following two statements is NOT true?

Select 2 option(s):

Prior to sharing your dashboard with your supplier, what do you first need to do?

Select 1 option(s):

The key tables you have for your company’s reporting requirements are:
1. Date is a date table created in DAX
2. Countries is a geographic table that is rarely updated
3. Sales has the software sales to retailers and has many new records added every day
Which storage model should you use for each of the three requirements from top to bottom?

Select 1 option(s):

How would you go about adding the YouTube video to your dashboard?

Select 1 option(s):

How would you optimize the model performance?

Select 1 option(s):

How would you configure your connection to the COVID-19 database?

Select 1 option(s):

What workspace roles should Ray and Jane be assigned?

Select 1 option(s):

How would you create a measure for the row-level average of the sum of freight and surcharge?

Select 1 option(s):

What data quality option should you use?

Select 1 option(s):

What roles can she NOT perform?

Select 1 option(s):

How can you achieve this goal?

Select 1 option(s):

What data profile tool shows the image in the red box?

Select 1 option(s):

You have configured row-level security (RLS) so that Geographic leaders can only see the invoices from their region.
You are having difficulty getting RLS working for the relationship between the Geo and Invoices.
Which TWO actions should you perform to resolve this issue?

Select 2 option(s):

Where should you store the dataflows?

Select 1 option(s):

Which TWO tasks can you perform?

Select 2 option(s):

How would you share content with external users?

Select 1 option(s):

What TWO things does a decomposition tree do?

Select 2 option(s):

How would you complete the below the [VALUE] field in the DAX expression?
Last Inventory Level =
CALCULATE (
SUM ( Inventory[Quantity] ),
[VALUE] ( [VALUE])
)

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):