Microsoft Power BI Test - 4

Welcome to your Microsoft Power BI - Test-4

Name

Phone

Q1. You have some new staff joining your Power BI team. To help them get started in Power BI Desktop, you want to create a way for them to connect to the data sources that you are using on in your project. All they will need to do to connect to the data is enter their user credentials to authenticate.

How can you achieve this?

Select 1 option(s):

Create a dynamic M query

Use an Excel Macro to build connections

Create a PBIDS file with your key data sources

Create a template in lineage view

Q2. You use an R script to build a custom visual. However, you find that you cannot see data marked N/A and you are getting an error when importing your data as a list.

What could be TWO reasons for these issues?

Select 2 option(s):

NA is transformed into NULL by Power BI

You have not used the correct R version

Power BI only supports R dataframes

You need to first install the library tidyr

Q3. You have an inactive relationship between your date table and your shipping table. How would you use an inactive relationship in a measure?

Select 1 option(s):

Use the LOOKUPVALUE() function

Delete the active relationship and make the new relationship active

Use the USERELATIONSHIP() function

Change the crossfilter direction to both in the modelling tab

Q4. Your client has asked you whether you can create data alerts for all of the key visuals on your dashboard.

Which two visuals can you NOT create a data alert.

Select 2 option(s):

Funnel chart

KPI chart

Stacked column chart

Gauge chart

Card chart

Q5. You build a key influencers visual and you want to see how sales amount is affected by product category and product color.

How do you complete the three fields below?

Select 1 option(s):

Analyze -> Sales[Sales Quantity]; Explain by -> Product[Category], Product[Color]

Analyze -> Sales[Sales Amount]; Expand by -> Product[Category], Product[Model]

Analyze -> Sales[Sales Quantity]; Explain by -> Product[Category]; Expand by -> Product[Color]

Analyze -> Sales[Sales Amount]; Explain by -> Product[Category], Product[Color]

Q6. You work for an electric car manufacturer and you need to import a Supplier table into your data model. The Supplier table list the supplier id, full name, short name and address.

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

Select 1 option(s):

Column profile

Monospaced

Column distribution

Show whitespace

Column quality

Q7. You work for a large multinational company that has 23 departments. You have been tasked with creating a report with all the first aid trained staff . You need to create the same report for each department.

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

Select 1 option(s):

Create separate Power BI Desktop report for each department and email the PBIX file

Add a parameter to the report to filter department

Create a separate workspace for each department and create a report in each

Create a separate dataset for each department and add a separate report

Q8. You have produced reports for a space tourism startup. The founder is thrilled with the Power BI service setup. However, he has some questions on how to promote and secure the datasets to other users in the company. His three requirements are below:

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 dont 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):

Promoted / Certified / Featured

Sensitivity Label / Featured / Promoted

Featured / Sensitivity Label / Promoted

Certified / Sensitivity Label / Promoted

Q9. You work for an electric scooter manufacturer. You have a report with five pages, and you have been asked to filter all five pages when you select a particular scooter category on the first page.

What are the two ways you could do this?

Select 2 option(s):

Add a page level filter on all five pages

Create a report level filter using category in the Filter all pages well

Use a single button and set the action type to bookmark

Select paginated report and configure the settings

Create a slicer for category on each page and then Sync slicers on all pages

Q10. A colleague built a Power BI desktop report. Your colleague imported a flat file into Power BI from his local machine. You have inherited the Power BI report and you need to update the source for the file. How would you go about this?

Select 1 option(s):

On the home ribbon, click on properties and change the file path

Click on the Applied step source and click on the cog to change the file path

On the home ribbon, click on manage -> then file, then change the file path

Click on the Applied step changed type and click on the cog in the corner to change the file location

Q11. “A colleague calls you for help. She wants to build an app in Power BI and asks you how to publish the app.

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

Select 3 option(s):

On the permissions tab, decide who has access to the app

On the title tab, fill in the name and description to help people find the app

Before releasing the app, create a digital signature, so people know who built the app

On the navigation tab, select the content to be visible in the app

Click the Sync to organization button

On the setup tab, fill in the name and description to help people find the app

Q12. Your client asks you to connect to their procurement departments Azure Analysis Service. You call up their data analyst, and he asks you what you need for the connection.

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):

Connection Requirement: Server name, e.g. asazure://westcentralus.asazure.windows.net/abc

Connection Requirement: Admin name

Connection Option: Import

Connection Option: Dual

Connection Option: Direct Query

Connection Option: Connect live

Q13. You are a BI analyst for a digital marketing company. You have built a complex report that requires many custom DAX measures and tables. After releasing your report, senior management complains that it takes too long to load some key visuals.

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

Select 1 option(s):

Use the Dataverse button to drill into likely performance issues

Use the Performance Analyzer to examine report element performance

Use the cross report drillthrough feature to examine performance across the report

Run an R script to determine the performance issues in report elements

Q14. You have a Premium workspace at your company and you want to use automatic page refresh.

What are TWO key considerations to enable automatic page refresh?

Select 2 option(s):

Use must first disable sharing of your workspace

Your capacity administrator must enable the feature

Your interval must be greater than the minimum refresh interval

Refresh time in a premium capacity is rounded to the nearest 30 minutes

Q15. A medical devices company has contracted you to investigate their transportation providers performance. The company has a series of metrics they use to monitor the transporation providers performance, including on-time pickup, on-time delivery, billing accuracy etc. You are asked to find potential factors that contribute to the transportation providers performance.

What sort of visualization can help?

Select 1 option(s):

Scatter chart

Q&A chart

Key influencers chart

Decomposition tree chart

Q16. The board of your company would like to see a report on their mobiles. So you go ahead and optimize the report for mobile.

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

Select 1 option(s):

Yes / No / No

No / No / Yes

Yes / Yes / No

Yes / No / Yes

Q17. You discover a quality data source on your companys Azure SQL database. You decide to connect using direct query to the database. What two things are necessary to successfully connect?

Select 2 option(s):

Specify the fully qualified server name when connecting

Ensure firewall rules for the database are configured to allow access to Azure services

Select automatic schema change detection

Tiles are refreshed once per day, so you must configure the schedule refresh

Q18. Your company buys out a transportation company. You find that the company has several tables for customer records, all with the same structure and headings. You need to combine these tables to form a new single table for a customer segmentation analysis prior to merging the data into the parent companys system.

What transformation should you use?

Select 1 option(s):

Merge queries

Append queries as new

Append queries

Merge queries as new

Q19. You are asked by management to allow a consultants custom Power BI visual. However, by default, management wants no custom visuals. How would you enable the consultants visual while maintaining the default requirement in the most efficient manner?

Select 1 option(s):

Temporarily disable the tenant setting for custom visualization

Use Power BI Desktop .pbiviz files with the custom visual

Add the custom visuals to the organizational store

Build a separate Power BI service instance for the custom visual

Q20. What Text Analytics AI Insights are NOT available in Power BI.

Select 1 option(s):

Language Detection

Sentiment Analysis

Key Phrase Extraction

Word Sense Disambiguation

Q21. You create a Power BI report for a software company that uses AI for transportation companies. The company has a sales team across several countries and you create row-level security (RLS) in the model. Sales managers are restricted to access the data from their own country.

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):

In Power BI Desktop, edit the DAX expression on the role for France

In Power BI Service, change the Power BI workspace security and change the users email address to contributor

Add the user to the Azure Active Directory for France

In Power BI Service, use test as role and use the email address of the new employee

Q22. You build a dashboard that has an important gauge visual for a furniture manufacturer. The head of manufacturing want an alert whenever the gauge exceeds a certain value.

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

Select 2 option(s):

Use Microsoft Dataverse alert API

Send an email

Send a notification to mobile

Use Microsoft Power Automate to trigger additional actions

Q23. What is NOT part of the Power BI Service dashboard theme?

Select 1 option(s):

Dark

Light

Color-blind friendly

Custom

Tab-order friendly

Q24. You decide to add a KPI visual for your companys dashboard. You need to show total units this year, show the historic values at a monthly level and for the comparison use total units last year.

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

Select 1 option(s):

Indicator: Sales Units This Year , Trend axis: Fiscal Month , Target Goals: Sales Units This year

Indicator: Sales Units This Year , Trend axis: Fiscal Month , Target Goals: Sales Units Last year

Indicator: Sales Units Last Year , Trend axis: Fiscal Month , Target Goals: Sales Units This year

Indicator: Sales Units This Year , Trend axis: Fiscal Year , Target Goals: Sales Units Last year

Q25. You import a customer table from a flat file into your data model. You have been asked to investigate the performance of your model and decide to check all the data sources view native query . When you come to the customer table, you find that the view native query does not display.

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

Select 1 option(s):

Flat files do not support query folding

In the transformation, there is a promoted headers step that blocks the native query

You have used import as the storage mode

There is row-level security on the dataset

Q26. You create a report for a hospital and use row-level security (RLS) for doctors to view their metrics and salary using a doctors role. You also create a hospital manager role that can see all the data. The employee table you use for RLS has id, name, role and email address.

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

Select 1 option(s):

Yes / Yes / No

Yes / Yes / Yes

Yes / No / No

No / Yes / No

Q27. You import the below Transport table into your model and have been instructed to find the totals across destination ZIP codes. Which summarization option would you recommend for aggregating the below three columns?

· DestinationZIP
· Weight
· Units

Select 1 option(s):

MAX / NONE / SUM

COUNT / SUM / NONE

NONE / SUM / SUM

NONE / MAX / SUM

Q28. Your manager at a construction materials company wants to know how category sales have changed over time with an animation. You decide that a chart with an animation to show changes across months would help visualize the data.

How would you go about achieving this objective?

Select 1 option(s):

Create a line chart and add month to the axis well

Create a waterfall chart and add month to the breakdown well

Create a scatter chart and add month to the play axis well

Create a tree map and add month to the details well

Q29. You are asked to create a measure to calculate the sales amount including the value added tax with the ability to go to the lowest level of detail (row level.) In addition, the value added tax is only relevant for order dates after Jan/1/2018. Prior to 2018, there is no tax applicable. See the exhibit below as an example of the output.

How would you achieve this goal using a DAX expression?

Select 1 option(s):

SUM(sales[Sales Amount]) + SUM(sales[Sales Tax])

SUMX(sales,if(sales[OrderDate]>=DATE(2018,1,1),sales[Sales Amount]+sales[Sales Tax],sales[Sales Amount])
)

SUMX(filter(sales,sales[OrderDate]>=DATE(2018,1,1)),sales[Sales Amount]+sales[Sales Tax])

SUM(sales,if(sales[OrderDate]>=1/1/2018,sales[Sales Amount]+sales[Sales Tax],sales[Sales Amount])

Q30. At your company, you are the Power BI administrator. Your company policy states that only DA-100 certified people are allowed to create new workspaces. The people who are DA-100 certified are grouped into a security group called DA100Workspace. You hire several new people who have recently completed their DA-100 certification and assign them to the DA100Workspace security group.

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):

i / iv / iii

ii / iii / v

ii / iv / v

i / ii / iii

Q31. You have built a dashboard for the board of a soft drink company. One of the board members has some ideas he wants to test with several visuals from a report page. However, he he wants to be able to immediatelty see the updates in the dashboard after you make changes.

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

Select 1 option(s):

Create a new dashboard for every new request and pin the new tiles

Pin the report page as live to the dashboard

On the report page, select embed in dashboard

Create a hyperlink for the tiles and select embed in dashboard

Q32. You work for a rapid fashion company and are tasked with calculating the percentage change in sales from last month. You are given a measure Sales Total that aggregates sales and you have date table you built in DAX.

How would you calculate last months sales percentage change?

Select 1 option(s):

VAR SalesLastMonth = CALCULATE([Sales Total],DATEADD(‘Date‘[Date],-1,MONTH))
VAR SalesPercentageChange = DIVIDE([Sales Total]-SalesLastMonth,SalesLastMonth)
Return SalesPercentageChange

VAR SalesLastMonth = CALCULATE([Sales Total], PARALLELPERIOD (‘Date‘[Date],-1,QUARTER))
VAR SalesPercentageChange = DIVIDE([Sales Total]-SalesLastMonth,SalesLastMonth)
Return SalesPercentageChange

VAR SalesLastMonth = CALCULATE([Sales Total], SAMEPERIODLASTYEAR (‘Date‘[Date]) )
VAR SalesPercentageChange = DIVIDE([Sales Total]-SalesLastMonth,SalesLastMonth)
Return SalesPercentageChange

VAR SalesLastMonth = CALCULATE([Sales Total],DATEADD(‘Date‘[Date],-1,MONTH))
VAR SalesPercentageChange = Sales Total-SalesLastMonth
Return SalesPercentageChange

Q33. Senior management wants you to add data classifications to your dashboards to raise awareness with those viewing your dashboards about what level of security should be used.

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

Select 1 option(s):

Yes / Yes / Yes

No / Yes / No

No / No / Yes

Yes / No / Yes

Q34. You have created a measure for the percentage of sales subcategory to sales and wish to apply conditional formatting as per the below exhibit. The rule you want to use is if the value is less than 10%, then shade the cell blue and if the value is greater than 10%, then shade the cell green.

How would you complete the below conditional formatting table?

Select 1 option(s):

Format: Color Scale, Row 1: 0 / Number and 10 / Number, Row 2: 10 / Number and 100 / Number

Format: Field Value, Row 1: 0 / Percentage and 10 / Percentage, Row 2: 10 / Percentage and 100 / Percentage

Format: Rules, Row 1: 0 / Number and 0.1 / Number, Row 2: 0.1 / Number and 1 / Number

Format: Color Scale, Row 1: 0 / Percentage and 10 / Percentage, Row 2: 10 / Percentage and 100 / Percentage

Q35. You work for a wine maker who has a selection of white and red wines that are fermented in barrels. The process can take between 5 and 35 months. Your data set has columns for fermentation time, start and end date

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):

Select the fermentation time column, right click and select New Group -> Set Group type to Bin -> Set the Bin type to number of bins -> Make the bin count 6

Set Group type to list -> Select the fermentation time column, right click and select New Group -> Set the Bin type to number of bins -> Make the bin count 30

Select the fermentation time column, right click and select New Group -> Set the Bin type to count of bins -> Set Group type to Bin -> Make the bin size 6

Select the fermentation time column, right click and select New Group -> Set Group type to Bin -> Make the bin count 30 -> Set the Bin type to number of bins

Q36. Your company has a current year target of last years sales multiplied by an additional 10%. You have a date table called date and you have a measure to sum sales called Sales Total.

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

Select 1 option(s):

VAR PreviousYearSales = SUMX([Sales Total], SAMEPERIODLASTYEAR (‘Date‘[Date],-1,YEAR))
VAR TargetSales = PreviousYearSales*1.1
Return TargetSales

VAR PreviousYearSales = CALCULATE([Sales Total],DATEADD(‘Date‘[Date],-1,YEAR))
VAR TargetSales = PreviousYearSales*1.1
Return TargetSales

VAR PreviousYearSales = CALCULATETABLE([Sales Total],DATEADD(‘Date‘[Date],-1,YEAR))
VAR TargetSales = PreviousYearSales*0.1
Return TargetSales

VAR PreviousYearSales = CALCULATE([Sales Total], PARALLELPERIOD (‘Date‘[Date],-1,MONTH))
VAR TargetSales = PreviousYearSales*1.1
Return PreviousYearSales

Q37. You work for a cryptocurrency exchange as a BI analyst. You are tasked with creating a report for weekly trends across the asset ranges. Your source dataset has over 150 million rows.

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

Select 2 option(s):

Use the Direct Query storage mode for the dataset

Only use line charts for visuals

Use the Import storage mode for the dataset

Do not use tab or layer order

Create a summary table in the source data grouped by weekly volumes

Q38. You work for a bicycle manufacturer and you have created a bar chart with sales by category.

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):

Create a new measure using the MEDIAN DAX function on the sales column

In the analytics pane, add a trendline

In the chart values well, right click on sales and change the summarization to Median

Create a new measure using the Count (distinct) DAX function on the sales column

In the chart values well, right click on sales and change the show value as to a percent of grand total

Q39. Your users give you feedback that they would like your reports to have more interactivity. You add some interactivity.

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):

Tab selection / Format pane / Back button

Edit interactions / Bookmarks / Back button

Edit interactions / Tab selection / Back button

Bookmarks / Edit interractions / Back button

Q40. You find that your visuals on a report page are taking a long time to load and you need to find the cause. You remember there is a way to get how each of your report elements, such as visuals and DAX formulas, are performing.

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):

Restart Power BI -> Open performance analyzer and press start recording -> Check enable diagnostics logging -> Press stop and review results

Create a blank report page -> Restart Power BI -> Click on SQL Server diagnostics -> Ineract with the visuals -> Press stop and review results

Create a blank report page -> Restart Power BI -> Open performance analyzer and press start recording -> Ineract with the visuals -> Press stop and review results

Restart Power BI -> Open query diagnostics and press start recording -> Ineract with the visuals -> Press stop and review results

Q41. You have a dataset in Power BI Service, and you want to use Quick Insights to get some ideas for a dashboard. However, you notice that Quick Insights are not working.

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

Select 3 option(s):

You have uploaded data to Power BI

Your dataset uses Direct Query

Your dataset uses streaming

You have measures in your dataset

Your dataset is not statistically significant

Q42. You have two visuals as per the below exhibit. You have the sales by year on the left, and on the right, you have sales by category.

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):

Yes / No / Yes

Yes / No / No

No / No / Yes

Yes / Yes / No

Q43. Your company has a Power BI Premium license and you want to use the AI features in your report to expose insights.

Which of the following two statements is NOT true?

Select 2 option(s):

You can take a piece of text and return a list of key phrases

You can build your own machine learning models and use them in Power BI desktop

The decomposition tree requires a premium subscription

Sentiment Analysis is available for select languages

You cannot use Power BI to tag images

Q44. You have created a dashboard you want to share with your suppliers to help with the data communications between your organizations. Your supplier has a Power BI Pro license and uses Power BI within their own organization as well.

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

Select 1 option(s):

Make sure your supplier has upgraded to Power BI Premium

In the tenant settings, enable email notification service for outages or incidents

In the tenant settings, enable share content with external users

Publish your dashboard to the web

Q45. You work for a software company that enables cryptocurrency payments for retailers.

The key tables you have for your companys 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):

Import / Import / Live Connection

Dual / Import / Live Connection

Dual / Import / DirectQuery

Import / Import / DirectQuery

Q46. For your annual report, your company has produced a YouTube video. Your manager asks to add this YouTube video to your financial dashboard so the board members can see the video in the dashboard.

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

Select 1 option(s):

Add an image tile

Add a video tile

Add a text box tile

Add a custom streaming data tile

Q47. You have a large Power BI dashboard for stock prices that display weekly performance. The data set goes back to 1985. When the dashboard refreshes it takes visuals too long to load.

How would you optimize the model performance?

Select 1 option(s):

Add a personal gateway to your organizations dataset

Add a streaming tile to your dashboard

Adjust the time zone in the tenant setting

Configure incremental refresh

Q48. Your country has created a register for confirmed cases of COVID-19. The data is recorded in a large Azure SQL Database and is updated continuously. You have been contracted as a consultant to assist your government in creating a dashboard to visualize the data in Power BI.

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

Select 1 option(s):

Create a script to continuously import the data

Connect to the data with Live Connection

Connect to the data with DirectQuery

Connect to the data with AI Insights

Q49. You work for an electric engine manufacturer as a Power BI admin. You have two colleagues, Ray and Jane, who need access to your workspace. Ray will need to publish, unpublish, and change permissions for the apps. Jane needs to be able to publish reports to the workspace and delete content.

What workspace roles should Ray and Jane be assigned?

Select 1 option(s):

Ray = Member / Jane = Contributor

Ray = Admin / Jane = Member

Ray = Member / Jane = Viewer

Ray = Member / Jane = Member

Q50. Your company uses a transport provider that charges freight costs and fuel surcharge costs as per the below exhibit for the Transport table.

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

Select 1 option(s):

AVERAGE( Transport, Transport[Freight ($)] + Transport[Surcharge ($)])

SUMX(Transport, Transport[Freight ($)] + Transport[Surcharge ($)])

AVERAGEA( Transport, Transport[Freight ($)])

AVERAGEX( Transport, Transport[Freight ($)] + Transport[Surcharge ($)])

Q51. You are checking your data for errors and want to see the average and standard deviation for a column.

What data quality option should you use?

Select 1 option(s):

Column quality

Column distribution

Column profile

Monospaced

Q52. You are the Power BI admin at your company. You have assigned a colleague as a member role in your workspace.

What roles can she NOT perform?

Select 1 option(s):

Update an app

Manage dataset permissions

Update and delete the workspace

Allow others to reshare items

Q53. You work in a warehouse for a large eCommerce company. You have a Power BI Premium dashboard of the key logistics metrics called daily shipments. You would like to receive a daily snapshot by email of the daily shipments dashboard.

How can you achieve this goal?

Select 1 option(s):

Integrate the dashboard to Power BI Desktop

Ask the admin to add you as a contributor to the workspace

Subscribe to the dashboard

Turn on notifications on your instance of Power BI Service

Q54. You are in Power Query Editor, and you see the below view across multiple columns.

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

Select 1 option(s):

Column distribution

Column quality

Column histogram

Column profile

Q55. You have two tables named Invoice and Geo that are connected through an active relationship using the GeoID field. You need to be able to filter the data from both the Geo table and from the Invoice table. I.e. you need the Invoice table filtered by Geo and the Geo table filtered by Invoice type.

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):

In the relationship view, set the cross filter direction to Single

In the relationship view, check apply security filter in both directions

In the relationship view, set the cross filter direction to Both

In the relationship view, uncheck make this relationship active

Q56. Your company plans to use dataflows to process the data stored in the Common Data Service to prepare for Power BI reports and Dashboards.

Where should you store the dataflows?

Select 1 option(s):

Common Data Model folder

Azure Data Lake Gen2

Sharepoint

Azure SQL Server

Q57. You are a Power BI User Admin.

Which TWO tasks can you perform?

Select 2 option(s):

Manage subscriptions

Create and manage users and groups

Enable and disable Power BI features

Reset user passwords

Q58. You want to share a dashboard with external guest users from another business.

How would you share content with external users?

Select 1 option(s):

Invite external guests through the Azure Active Directory B2B

Click share directly from the dashboard

Go to the Power BI admin tenant setting and add the emails for the external users

Modify the workspace permissions to allow for the external users

Q59. You think that a decomposition tree may be useful for your analysis.

What TWO things does a decomposition tree do?

Select 2 option(s):

Conduct root cause analysis

Segments that contribute to the selected metric value

Visualize data across multiple dimensions

Contrast the relative importance of factors

Q60. You have an Inventory table and a Date table (see exhibit below) and need to calculate a semi-additive measure for the closing inventory value.

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):

MAX / Date[Date]

LASTDATE / Inventory[MovementDate]

LASTNONBLANK / Inventory[MovementDate]

LASTDATE / Date[Date]

Q61. How can you create a calculated table in Power BI?

Select 1 option(s):

By using the New Table feature and writing a DAX formula

By using the Group By feature

By creating a new column with a table formula

By using the Pivot Table feature

Q62. 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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.During the development process, you need to import a sample of the data from the Order table.Solution: You write a DAX expression that uses the FILTER function.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q63. What is the purpose of data aggregation?

Select 1 option(s):

To combine data from multiple sources

To remove outliers from the data

To replace missing data with estimated values

To transform data into a different format

Q64. You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?

Select 1 option(s):

A. From Model view, set the Subject and Body columns to Hidden.

B. Remove the Subject and Body columns during the import.

C. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Q65. In Power Query, how does referencing a query differ from duplicating a query?

Select 1 option(s):

Referencing uses the original query as a lookup table.

Referencing works on external data sources, while duplicating does not.

When you reference a query, any changes to the original query fail to reflect in the new query.

Referencing uses the original query as the source and it can be used in other queries for the further processing

Microsoft Power BI Test - 4

Q2. You use an R script to build a custom visual. However, you find that you cannot see data marked N/A and you are getting an error when importing your data as a list.

Q3. You have an inactive relationship between your date table and your shipping table. How would you use an inactive relationship in a measure?

Q4. Your client has asked you whether you can create data alerts for all of the key visuals on your dashboard.

Q5. You build a key influencers visual and you want to see how sales amount is affected by product category and product color.

Q6. You work for an electric car manufacturer and you need to import a Supplier table into your data model. The Supplier table list the supplier id, full name, short name and address.

Q7. You work for a large multinational company that has 23 departments. You have been tasked with creating a report with all the first aid trained staff . You need to create the same report for each department.

Q8. You have produced reports for a space tourism startup. The founder is thrilled with the Power BI service setup. However, he has some questions on how to promote and secure the datasets to other users in the company. His three requirements are below:

Q9. You work for an electric scooter manufacturer. You have a report with five pages, and you have been asked to filter all five pages when you select a particular scooter category on the first page.

Q10. A colleague built a Power BI desktop report. Your colleague imported a flat file into Power BI from his local machine. You have inherited the Power BI report and you need to update the source for the file. How would you go about this?

Q11. “A colleague calls you for help. She wants to build an app in Power BI and asks you how to publish the app.

Q12. Your client asks you to connect to their procurement departments Azure Analysis Service. You call up their data analyst, and he asks you what you need for the connection.

Q13. You are a BI analyst for a digital marketing company. You have built a complex report that requires many custom DAX measures and tables. After releasing your report, senior management complains that it takes too long to load some key visuals.

Q14. You have a Premium workspace at your company and you want to use automatic page refresh.

Q16. The board of your company would like to see a report on their mobiles. So you go ahead and optimize the report for mobile.

Q17. You discover a quality data source on your companys Azure SQL database. You decide to connect using direct query to the database. What two things are necessary to successfully connect?

Q19. You are asked by management to allow a consultants custom Power BI visual. However, by default, management wants no custom visuals. How would you enable the consultants visual while maintaining the default requirement in the most efficient manner?

Q20. What Text Analytics AI Insights are NOT available in Power BI.

Q21. You create a Power BI report for a software company that uses AI for transportation companies. The company has a sales team across several countries and you create row-level security (RLS) in the model. Sales managers are restricted to access the data from their own country.

Q22. You build a dashboard that has an important gauge visual for a furniture manufacturer. The head of manufacturing want an alert whenever the gauge exceeds a certain value.

Q23. What is NOT part of the Power BI Service dashboard theme?

Q24. You decide to add a KPI visual for your companys dashboard. You need to show total units this year, show the historic values at a monthly level and for the comparison use total units last year.

Q25. You import a customer table from a flat file into your data model. You have been asked to investigate the performance of your model and decide to check all the data sources view native query . When you come to the customer table, you find that the view native query does not display.

Q26. You create a report for a hospital and use row-level security (RLS) for doctors to view their metrics and salary using a doctors role. You also create a hospital manager role that can see all the data. The employee table you use for RLS has id, name, role and email address.

Q27. You import the below Transport table into your model and have been instructed to find the totals across destination ZIP codes. Which summarization option would you recommend for aggregating the below three columns?

Q28. Your manager at a construction materials company wants to know how category sales have changed over time with an animation. You decide that a chart with an animation to show changes across months would help visualize the data.

Q31. You have built a dashboard for the board of a soft drink company. One of the board members has some ideas he wants to test with several visuals from a report page. However, he he wants to be able to immediatelty see the updates in the dashboard after you make changes.

Q32. You work for a rapid fashion company and are tasked with calculating the percentage change in sales from last month. You are given a measure Sales Total that aggregates sales and you have date table you built in DAX.

Q33. Senior management wants you to add data classifications to your dashboards to raise awareness with those viewing your dashboards about what level of security should be used.

Q34. You have created a measure for the percentage of sales subcategory to sales and wish to apply conditional formatting as per the below exhibit. The rule you want to use is if the value is less than 10%, then shade the cell blue and if the value is greater than 10%, then shade the cell green.

Q35. You work for a wine maker who has a selection of white and red wines that are fermented in barrels. The process can take between 5 and 35 months. Your data set has columns for fermentation time, start and end date

Q36. Your company has a current year target of last years sales multiplied by an additional 10%. You have a date table called date and you have a measure to sum sales called Sales Total.

Q37. You work for a cryptocurrency exchange as a BI analyst. You are tasked with creating a report for weekly trends across the asset ranges. Your source dataset has over 150 million rows.

Q38. You work for a bicycle manufacturer and you have created a bar chart with sales by category.

Q39. Your users give you feedback that they would like your reports to have more interactivity. You add some interactivity.

Q40. You find that your visuals on a report page are taking a long time to load and you need to find the cause. You remember there is a way to get how each of your report elements, such as visuals and DAX formulas, are performing.

Q41. You have a dataset in Power BI Service, and you want to use Quick Insights to get some ideas for a dashboard. However, you notice that Quick Insights are not working.

Q42. You have two visuals as per the below exhibit. You have the sales by year on the left, and on the right, you have sales by category.

Q43. Your company has a Power BI Premium license and you want to use the AI features in your report to expose insights.

Q44. You have created a dashboard you want to share with your suppliers to help with the data communications between your organizations. Your supplier has a Power BI Pro license and uses Power BI within their own organization as well.

Q45. You work for a software company that enables cryptocurrency payments for retailers.

Q46. For your annual report, your company has produced a YouTube video. Your manager asks to add this YouTube video to your financial dashboard so the board members can see the video in the dashboard.

Q47. You have a large Power BI dashboard for stock prices that display weekly performance. The data set goes back to 1985. When the dashboard refreshes it takes visuals too long to load.

Q48. Your country has created a register for confirmed cases of COVID-19. The data is recorded in a large Azure SQL Database and is updated continuously. You have been contracted as a consultant to assist your government in creating a dashboard to visualize the data in Power BI.

Q49. You work for an electric engine manufacturer as a Power BI admin. You have two colleagues, Ray and Jane, who need access to your workspace. Ray will need to publish, unpublish, and change permissions for the apps. Jane needs to be able to publish reports to the workspace and delete content.

Q50. Your company uses a transport provider that charges freight costs and fuel surcharge costs as per the below exhibit for the Transport table.

Q51. You are checking your data for errors and want to see the average and standard deviation for a column.

Q52. You are the Power BI admin at your company. You have assigned a colleague as a member role in your workspace.

Q53. You work in a warehouse for a large eCommerce company. You have a Power BI Premium dashboard of the key logistics metrics called daily shipments. You would like to receive a daily snapshot by email of the daily shipments dashboard.

Q54. You are in Power Query Editor, and you see the below view across multiple columns.

Q56. Your company plans to use dataflows to process the data stored in the Common Data Service to prepare for Power BI reports and Dashboards.

Q57. You are a Power BI User Admin.

Q58. You want to share a dashboard with external guest users from another business.

Q59. You think that a decomposition tree may be useful for your analysis.

Q60. You have an Inventory table and a Date table (see exhibit below) and need to calculate a semi-additive measure for the closing inventory value.

Q61. How can you create a calculated table in Power BI?

Q63. What is the purpose of data aggregation?

Q65. In Power Query, how does referencing a query differ from duplicating a query?

Q2. You use an R script to build a custom visual. However, you find that you cannot see data marked N/A and you are getting an error when importing your data as a list.

Q12. Your client asks you to connect to their procurement departments Azure Analysis Service. You call up their data analyst, and he asks you what you need for the connection.

Q17. You discover a quality data source on your companys Azure SQL database. You decide to connect using direct query to the database. What two things are necessary to successfully connect?

Q19. You are asked by management to allow a consultants custom Power BI visual. However, by default, management wants no custom visuals. How would you enable the consultants visual while maintaining the default requirement in the most efficient manner?

Q24. You decide to add a KPI visual for your companys dashboard. You need to show total units this year, show the historic values at a monthly level and for the comparison use total units last year.

Q25. You import a customer table from a flat file into your data model. You have been asked to investigate the performance of your model and decide to check all the data sources view native query . When you come to the customer table, you find that the view native query does not display.

Q26. You create a report for a hospital and use row-level security (RLS) for doctors to view their metrics and salary using a doctors role. You also create a hospital manager role that can see all the data. The employee table you use for RLS has id, name, role and email address.

Q36. Your company has a current year target of last years sales multiplied by an additional 10%. You have a date table called date and you have a measure to sum sales called Sales Total.