CERTIFICACÍON PL-300 Flashcards by Viviane Candeias

You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter?
Filter :
TOP N or Basic or Advanced
Level:
Page or Visual or ReporT

Filter: Top N
Level: Visual

TOP N only works on a visual. The option doesn’t appear in Page or Repor

How well did you know this?

Not at all

Perfectly

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?
A. pie chart
B. scatterplot
C. bar chart

The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region

C. bar chart

The bar chart makes more sense due to the complexity of two added factors ie. country and shipping region. Otherwise you will have to create two Pie Charts

How well did you know this?

Not at all

Perfectly

You need to create a KPI visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area.

INDICADOR:
Date[month],
Sales[sales_amount],
Sales[sales_id],
Targets[sales_target],
Weekly_Returns[total_returns]

TREND AXIS:
Date[month],
Sales[sales_amount],
Target[sales_target],
Weekly_Returns[total_returns]

TARGET GOALS:
Date[month],
Sales[sales_amount],
Target[sales_target],
Weekly_Returns[total_returns]

Um KPI no Power BI geralmente contém três componentes principais:

Valor Atual: A métrica que está sendo monitorada, como vendas ou produção.
Valor-Alvo: O valor de referência ou meta com o qual o valor atual será comparado, como uma meta de vendas ou limite de desempenho.
Indicador Visual: Um elemento visual que mostra se o valor atual está dentro do esperado, abaixo ou acima da meta. Esses indicadores visuais geralmente são setas, ícones ou cores que facilitam a interpretação rápida do desempenho.

INDICADOR: SALES[sales_amount]
TREND AXIS: Date[month]
TARGET GOALS: Targets[sales_target]

How well did you know this?

Not at all

Perfectly

What is the minimum number of Power BI datasets needed to support the reports?

A. a single imported dataset
B. two imported datasets
C. two DirectQuery datasets
D. a single DirectQuery dataset

Security Requirements -
The reports must be made available to the board from powerbi.com. An Azure Active Directory (Azure AD) group will be used to share information with the board.
Contoso identifies the following security requirements for analyst access:
Analysts must be able to access all balance sheet and product catalog data.
Analysts must be able to access only the profit and loss data of their respective business unit.
Analysts must be able to create new reports from the dataset that contains the profit and loss data, but the reports built by the analysts must NOT be included in the quarterly reports for the board.
Analysts must NOT be able to share the quarterly reports with anyone.
Analysts must NOT be able to make new reports by using the balance sheet data.

B. two imported datasets

How well did you know this?

Not at all

Perfectly

You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

1.You need an on-premises data gateway to refresh the dataset( )
2.You nedd to configure a scheduled refresh of the dataset( )
3.You can usa Basic Authentication on the dataset to connect to the data ( )

Litware plans to leverage data from an Azure SQL database that stores data for the company’s live e-commerce website.
Litware uses Azure Active Directory (Azure AD) to authenticate users.

1.NO
2.NO
3.YES
(tinha poucas respostas no examtopics ve se tem alguma actualização)

1- You definitely don’t need a gateway as Azure SQL is could based.
2- The question says that “transactions must be updated within 5 minutes”. Therefore, (unless you plan to create a composite model) you should connect to the DB in direct query mode, hence you don’t need to schedule any refresh.
3- Azure SQL allow to use OAuth2. This doesn’t mean that you can’t use basic authentication anymore. The question asks if you CAN use basic authentication and you can still use it, even though you have the option to use azure authentication.

How well did you know this?

Not at all

Perfectly

What should you create to meet the reporting requirements of the sales department?

A. a measure column that uses the following formula: SUMX(FILTER(‘Sales’, ‘Sales’[sales_amount] > 0)),[sales_amount])
B. a calculated column that uses the following formula: ABS(Sales[sales_amount])
C. a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))
D. a measure that uses the following formula: SUM(Sales[sales_amount])

The sales department requires reports that contain the number of sales transactions.

A. a measure column that uses the following formula: SUMX(FILTER(‘Sales’, ‘Sales’[sales_amount] > 0))

How well did you know this?

Not at all

Perfectly

You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.

PERMISSIONS REQUIRED IN POWERBI.COM:
Acess permissions to an app
The member role to the workspace
The Viewer role to the workspace

PERMISSIONA FOR THE PROFIT AND LOSS DATASET:
Build
Delete
Reshare

Contoso identifies the following security requirements for analyst access:
Analysts must be able to access all balance sheet and product catalog data.
Analysts must be able to access only the profit and loss data of their respective business unit.
Analysts must be able to create new reports from the dataset that contains the profit and loss data, but the reports built by the analysts must NOT be included in the quarterly reports for the board.
Analysts must NOT be able to share the quarterly reports with anyone.
Analysts must NOT be able to make new reports by using the balance sheet data.

PERMISSIONS REQUIRED IN POWERBI.COM:
Access permissions to an app
PERMISSIONA FOR THE PROFIT AND LOSS DATASET:
Reshare

TEM QUE VERIFICAR SE REALMENTE É ESSA RESPOSTA NO SITE, POIS TINHAM DUVIDAS

How well did you know this?

Not at all

Perfectly

**How should you distribute the reports to the board? **To answer, select the appropriate options in the answer area:
Grant access by: 1.sharing indivual reports, 2.using a workspace membership 3.Using an app
Grant acess to: 1.A dynamic distruition list 2. a mail-enable security group in azure active directory. 3.Individual user emails

AZURE SQL DATABASE
The company wants to provide the board with a single package of reports that will contain custom navigation and links to supplementary information.

3.Using an app
2.A mail-enabled security gourp in Azure active Directory

essa reposta nao coincido com a que tá no examtopics…depois verificar

How well did you know this?

Not at all

Perfectly

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.
What should you do?
A. From each report in powerbi.com, select Refresh visuals.
B. From Power BI Desktop, download the PBIX file and refresh the data.
C. Configure a scheduled refresh without using an on-premises data gateway.
D. Configure a scheduled refresh by using an on-premises data gateway.

abendo que data an sources vem do Azure sql database

C. Configure a scheduled refresh without using an on-premises data gateway.

How well did you know this?

Not at all

Perfectly

You need to update the Power BI model to ensure that the analysts can quickly build drill-downs from business unit to product in a visual.
What should you create?

A. a group
B. a calculated table
C. a hierarchy
D. a calculated column

C. a hierarchy

for drill-down always need hierarchy

How well did you know this?

Not at all

Perfectly

Question
What should you create to meet the reporting requirements of the sales department?

A. a measure that uses a formula of COUNTROWS(Sales)
B. a calculated column that use a formula of COUNTA(Sales[sales_id])
C. a calculated column that uses a formula of SUM(Sales[sales_id])
D. a measure that uses a formula of SUM(Sales[sales_id])

In the Sales table, the sales_id column represents a unique transaction (Sales[sales_id])
The sales department requires reports that contain the number of sales transactions.

A. a measure that uses a formula of COUNTROWS(Sales)

How well did you know this?

Not at all

Perfectly

What should you do to address the existing environment data concerns?

A. a calculated column that uses the following formula: ABS(Sales[sales_amount])
B. a measure that uses the following formula: SUMX(FILTER(‘Sales’, ‘Sales’[sales_amount] > 0)),[sales_amount])
C. a measure that uses the following formula: SUM(Sales[sales_amount])
D. a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

Existing Environment. Data Concerns
You are concerned with the quality and completeness of the sales data. You must ensure that negative and missing sales_amount values do NOT contribute to the total sales amount calculation.

B. a measure that uses the following formula: SUMX(FILTER(‘Sales’, ‘Sales’[sales_amount] > 0),[sales_amount])

How well did you know this?

Not at all

Perfectly

You need to create a calculated column to display the month based on the reporting requirements.
Which DAX expression should you use?

A. FORMAT(‘Date’[date],”MMM YYYY”)
B. FORMAT(‘Date’[date_id],”MMM”) & “ “ & FORMAT(‘Date’[year], “#”)
C. FORMAT(‘Date’[date_id],”MMM YYYY”)
D. FORMAT(‘Date’[date],”M YY”)

Existing Environment. Reporting Requirements
Litware identifies the following reporting requirements:
Users must be able to see the month in each report as shown in the following example: Feb 2020.
‘Date’[date], TYPE DATE
‘Date’[date_id], TYPE INT

A. FORMAT(‘Date’[date],”MMM YYYY”)

How well did you know this?

Not at all

Perfectly

You need to create the required relationship for the executive’s visual.
What should you do before you can create the relationship?

A. Change the data type of Sales[region_id] to Whole Number.
B. Change the data type of Sales[region_id] to Decimal Number.
C. In the Sales table, add a measure for Sum(sales_amount).
D. Change the data type of Sales[sales_id] to Text.

Sales[region_id] TYPE IS VARCHAR
Sales_Region[region_id] TYPE IS INTEGER
The sales managers must be able to see only the sales data of their respective region.
The sales managers require a visual to analyze sales performance versus sales targets.

A. Change the data type of Sales[region_id] to Whole Number.

How well did you know this?

Not at all

Perfectly

You need to get data from the Microsoft SQL Server tables.
What should you use to configure the connection?

A. Import that uses a Microsoft account
B. Import that uses a database credential
C. DirectQuery that uses a database credential
D. DirectQuery that uses the end-user’s credentials

Reporting Requirements
The maximum allowed latency to include transactions in reports is five minutes.

C. DirectQuery that uses a database credential

VERIFICAR SE ESSA CONTINUA SENDO A REPOSTA CORRETA

How well did you know this?

Not at all

Perfectly

You need to create the dataset.
Which dataset mode should you use?

A. Import
B. DirectQuery
C. Composite
D. live connection

DOIS DATA SOURCES NO POWERBI 1 AZURE SQL DATABASE COM 2 GB E O OUTRO MICROSOFT EXCEL SPREADSHEET COM 5 MB.

C. Composite

TÁ BEM BALANÇADA A RESPOSTA NO EXAMTOPICS

How well did you know this?

Not at all

Perfectly

pergunta PAGINA 28 QUESTION 2 TOPIC 6

C. Distribute an app to the users in the Azure Active Directory group of the sales department.

How well did you know this?

Not at all

Perfectly

pergunta PAGINA 28 QUESTION 3 TOPIC 7

1) Create four roles
2) add DAX filters
3) publish
4) add role members

DISSERAM QUE ESSA CAIU NO EXAME EM 04/06/2024

How well did you know this?

Not at all

Perfectly

Which DAX expression should you use to get the ending balances in the balance sheet reports?

A. CALCULATE ( SUM( BalanceSheet[BalanceAmount] ), LASTDATE ( ‘Date’[Date] ) )
B. CALCULATE ( SUM( BalanceSheet[BalanceAmount] ), DATESQTD(‘Date’[Date]) )
C. FIRSTNONBLANK (‘Date’[Date] SUM( BalanceSheet[BalanceAmount] ) )
D. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE (‘Date’[Date] ))

A. CALCULATE ( SUM( BalanceSheet[BalanceAmount] ), LASTDATE ( ‘Date’[Date] ) )

Explicação:
Em um balanço patrimonial, o saldo final geralmente se refere ao valor na data mais recente de um determinado período. A expressão LASTDATE(‘Date’[Date]) recupera a última data no período selecionado, e CALCULATE(SUM(BalanceSheet[BalanceAmount]), LASTDATE(‘Date’[Date])) calcula o saldo nessa última data, que é a maneira mais comum de obter o saldo final em relatórios financeiros.

How well did you know this?

Not at all

Perfectly

You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable
Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?

A. Microsoft Information Protection sensitivity labels
B. tiles
C. comments
D. Active Directory groups

A. Microsoft Information Protection sensitivity labels

Explicação:
Os rótulos de sensibilidade do Microsoft Information Protection (MIP) são projetados para ajudar a classificar e proteger informações sensíveis, como Informações Pessoais Identificáveis (PII). Ao aplicar esses rótulos aos dashboards do Power BI, você pode indicar aos usuários que determinados dashboards contêm PII sem alterar o design do dashboard ou exigir configurações adicionais. Essa abordagem também se integra perfeitamente com o Power BI e outros serviços da Microsoft, garantindo um impacto mínimo na funcionalidade do dashboard

How well did you know this?

Not at all

Perfectly

pergunta PAGINA 27 QUESTION 25 TOPIC 4

Analyze in Excel
Grant build permission

CAIU NO EXAME JULHO/2024

How well did you know this?

Not at all

Perfectly

You have five reports and two dashboards in a workspace.
You need to grant all organizational users read access to one dashboard and three reports.
Solution: You create an Azure Active Directory group that contains all the users. You share each selected report and the one dashboard to the group.
Does this meet the goal?
A. Yes
B. No

A. Yes

By creating an Azure Active Directory (AAD) group that contains all the users and sharing each selected report and the one dashboard to the group, you can grant read access to the selected resources to all users in the organization. This approach simplifies the management of access permissions since you can manage access for all users in one central place, the AAD group, instead of granting permissions to each user individually.

How well did you know this?

Not at all

Perfectly

You publish a dataset to the Power BI service. The dataset contains a connection to an on-premises Microsoft SQL Server database.

You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway.

You confirm the following with the administrator of the gateway:

You have the appropriate permissions to use the gateway.
The data source was created on the gateway.
The gateway has a status of Running.

What is the most likely reason the gateway is unavailable?
A. The type of data source is not supported by the on-premises data gateway.
B. The server name in the PBIX file does not match the data source name in the gateway.
C. The credentials for the data source are invalid.
D. The data source is configured to use single sign-on (SSO).

B. The server name in the PBIX file does not match the data source name in the gateway.

In Power BI, when you configure a data source to use an on-premises data gateway, the server name and other connection details in your PBIX file must match the data source configuration in the gateway. If there’s a mismatch in the server name or other connection details, the scheduled refresh won’t work, and you won’t be able to select the appropriate gateway.

How well did you know this?

Not at all

Perfectly

You have a Power BI dataset and a connected report.

You need to ensure that users can analyze data in Microsoft Excel only by connecting directly to the dataset.

You grant the users the Build permission for the dataset.

What should you do next?

A. Certify the dataset used by the report.
B. Change the default visual interaction for the report.
C. For the report, change the Export data setting to None.
D. For the report, change the Export data setting to Summarized data, data with current layout and underlying data.

C. For the report, change the Export data setting to None.

Question said “Only by connecting directly to the dataset.” it means the user should not be able to EXPORT the data from report.

How well did you know this?

Not at all

Perfectly

You have a Power BI workspace named BI Data that contains a dataset named BI Finance. You have the Build permission for the BI Finance dataset, but you do NOT have permissions for the workspace. You need to connect to BI Finance and create a report. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. From the Power BI service, create a dataflow to the dataset by using DirectQuery. B. From Power BI Desktop, connect to a Dataverse data source. C. From the Power BI service, create a new report and select a published dataset. D. From Power BI Desktop, connect to a shared dataset.

**C**.From the Power BI service, create a new report and select a published dataset. With Build permission on the dataset, you can create a new report in the Power BI service and select the BI Finance dataset as the basis for your report. **D**. From Power BI Desktop, connect to a shared dataset. You can also use Power BI Desktop to connect to the BI Finance dataset if it's shared. The Build permission enables you to use the dataset to create new content in Power BI Desktop.

You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) tabular model located on your company's internal network. You plan to publish the report to the Power BI Service. What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the tabular model? A. a scheduled refresh of the semantic model B. an OData feed C. an On-premises data gateway D. a subscription

C. an On-premises data gateway | pagina 27 ## Footnote ver se essa continua sendo a resposta correcta

You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the Viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do? A. Create a subscription. B. Create a data alert. C. Share the dashboard to the user. D. Tag the user in a comment.

A. Create a subscription. ## Footnote A is correct, you need a subscription, not an alert as alerts don't include a snapshot and they will only be sent based on a certain condition whereas here you want daily notifications, not just when the value exceeds a certain threshold.

You have five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports. Solution: **You publish an app to the entire organization.** Does this meet the goal? A. Yes B. No

A. Yes ## Footnote caiu no exame 2023

You have five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports. **Solution: You enable included in app for all assets. Does this meet the goal?** A. Yes B. No

B. No ## Footnote caiu no exame 2023

You have five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports. **Solution: You assign all the users the Viewer role to the workspace. Does this meet the goal?** A. Yes B. No

B. No ## Footnote in this way all users will see all workspace content not only the one dashboard and 3 reports

From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do? A. From powerbi.com, add users to the HR role for the dataset. B. From powerbi.com, share the dataset to the HR team members. C. From Power BI Desktop, change the Row-Level Security settings. D. From Power BI Desktop, import a table that contains the HR team members.

A. From powerbi.com, add users to the HR role for the dataset. ## Footnote This action directly assigns the HR team members to the RLS role named HR that you have defined in your Power BI dataset. By adding users to the RLS role, you ensure that the RLS policies are enforced when these users view the reports, thereby restricting data access according to the rules defined in the HR role

You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements: ✑ A line chart that shows the number of defective products manufactured by day ✑ A KPI visual that shows the current daily percentage of defective products manufactured You need to be notified when the daily percentage of defective products manufactured exceeds 3%. What should you create? A. a subscription B. an alert C. a smart narrative visual D. a Q&A visual

B. an alert ## Footnote We can set alerts on KPI, Cards and gauge .

You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network. You plan to publish the report to the Power BI Service. What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube? A. an OData feed B. an On-premises data gateway C. a subscription D. a scheduled refresh of the dataset

B. an On-premises data gateway ## Footnote estava no exame em 2023

You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson. Salespeople must see only the data from their region. You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople. A salesperson reports that she believes she should see more data. You need to verify what data the salesperson currently sees. What should you do? A. Use the Test as role option to view data as the salesperson's user account. B. Use the Test as role option to view data as the Sales role. C. Instruct the salesperson to open the report in Microsoft Power BI Desktop. D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

A. Use the Test as role option to view data as the salesperson's user account. ## Footnote Using the Test as role feature in Power BI, you can impersonate the salesperson's account and see the data as they would see it. This will help you determine if the salesperson is seeing the correct data based on their region and role.

You have a dataset that is used infrequently and refreshes every hour. You receive a notification that the refresh was disabled due to inactivity. **Which two actions will cause the scheduled refresh schedule to resume?** Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Enable query caching for the dataset. B. Import the dataset to Microsoft Excel. C. From the Power BI service, open a dashboard that uses the dataset. D. From the Power BI service, open a report that uses the dataset. E. From PowerShell, run the get-powerbireport cmdlet.

C. From the Power BI service, open a dashboard that uses the dataset. D. From the Power BI service, open a report that uses the dataset. ## Footnote Acessar o relatório ou o dashboard vinculado ao dataset: Ao visualizar um relatório ou dashboard que usa o dataset desativado, o Power BI registra a atividade e pode reativar a atualização agendada.

You have a Power BI workspace that contains a dataset, a report, and a dashboard. The following groups have access: ✑ External users can access the dashboard. ✑ Managers can access the dashboard and a manager-specific report. ✑ Employees can access the dashboard and a row-level security (RLS) constrained report. **You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.** What should you use? A. comments B. chat in Microsoft Teams C. alerts D. subscriptions

A. comments ## Footnote B. Chat in Microsoft Teams: the chat is not directly tied to the Power BI service. External users may not have access to the chat. Incorrect. C. Alerts: not for communication purposes and do not allow for tagging. Incorrect. D. Subscriptions: used to send snapshots of your dashboards or reports at a scheduled time, not interactive and would not be suitable for tagging administrators.Incorrect. => A is correct.

You have a PBIX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do? A. From Power Query Editor, create new queries. B. From Power Query Editor, modify the source of each query. C. Create a PBIT file, open the file, and change the data sources when prompted. D. Modify the Data source settings.

D. Modify the Data source settings. | caiu no exame em 02/2024

You have a Power BI workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do? A. Create a row-level security (RLS) role and add the user to the role. B. Share the reports with the user. C. Grant the Read permission for the datasets to the user. D. Add the user as a member of the workspace. E. Add the user as a Viewer of the workspace.

D. Add the user as a member of the workspace. ## Footnote Contributor is the lowest possible role to create dashboards, but the answers only provide Member as a role, so this is it.

You have a report in Power BI named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report. **The solution must prevent other reports from being affected.** What should you do? A. Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset. B. Apply row-level security (RLS) to the shared dataset. C. Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report. D. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.

D. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report. ## Footnote caiu no exame em 2023

In Power BI Desktop, you are creating visualizations in a report based on an imported dataset. **You need to allow Power BI users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data.** What should you do? A. From the Power BI service, configure the dataset permissions. B. From Power BI Desktop, configure the Data Load settings for the current file. C. From Power BI Desktop, modify the data source permissions. D. From Power BI Desktop, configure the Report settings for the current file.

D. From Power BI Desktop, configure the Report settings for the current file.

You have a Power BI report that uses row-level security (RLS). You need to transfer RLS membership maintenance to an Azure network security team. **The solution must NOT provide the Azure network security team with the ability to manage reports, datasets, or dashboards.** What should you do? A. Grant the Read and Build permissions for the Power BI datasets to the Azure network security team. B. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team. C. Instruct the Azure network security team to create security groups. Configure RLS to use the groups. D. Add the Azure network security team as members of the RLS role.

C. Instruct the Azure network security team to create security groups. Configure RLS to use the groups.

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 mail-enabled security group 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? A. Change the Microsoft Power BI license type of the sales manager. B. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports. C. Manage the permissions of the underlying dataset. D. Request that the sales manager be added to the correct Azure Active Directory group.

D. Request that the sales manager be added to the correct Azure Active Directory group. ## Footnote Explicación: En este escenario, como se está utilizando Row-Level Security (RLS) y los roles están asignados a grupos de seguridad de correo habilitados, cuando un gerente de ventas cambia a una región diferente, lo que se debe hacer es asegurarse de que esté agregado al grupo de Active Directory correcto que tiene acceso a la nueva región. Esta acción se realiza fuera de Power BI, en el nivel de administración de Active Directory. Cambiar la pertenencia al grupo correcto garantizará que el gerente de ventas pueda ver los datos correctos para la nueva región en Power BI.

You have more than 100 published datasets. Ten of the datasets were verified to meet your corporate quality standards. You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do? A. Promote the datasets. B. Certify the datasets. C. Feature the dataset on the home page. D. Publish the datasets in an app.

B. Certify the datasets. ## Footnote Certified datasets make it easier for organizations to steer users toward trusted and authoritative datasets. This "stamp of approval" for a dataset can only be applied by a specific group of Power BI users as defined in a new tenant setting. Once a dataset is certified, it shows up prominently in the new dataset discovery experience, making sure report authors can effortlessly find and leverage these high-quality sources of data

You have a Power BI report that contains one visual. **You need to provide users with the ability to change the visual type without affecting the view for other users**. What should you do? A. From the Bookmarks pane, select Focus mode, and then select Add. B. From Report settings, select Personalize visuals. C. From Visual options in Report settings, select Use the modern visual header with updated styling options. D. From Tabular Editor, create a new perspective.

B. From Report settings, select Personalize visuals.

You have a Power BI report that contains a card. The card displays the value for year-to-date revenue. You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed. What should you do? A. Convert the card into a text box. B. Add the value to the chart title text. C. Populate the alt text with a static value. D. Populate the alt text by using conditional formatting with a DAX measure.

Correct Answer: D

You have a Power BI report that contains a table visual. The visual contains a column. The column contains whole numbers ranging from of 1 to 20. You need to use conditional formatting to meet the following requirements: * Visually compare the values without having to read the text containing the number. * Show a different format for each distinct value. * Hide the numeric value of ColumnA. * Minimize development effort. Which formatting should you use? A. font color B. icons C. data bars D. background color

Correct Answer: C

You have a Power BI report that contains the visual shown in the following exhibit. a figura esta na pagina 24 question 91 topic 3 You need to make the visual more accessible to users who have color vision deficiency. What should you do? A. Change the font color of values in the Sales column to white. B. Change the red background color to orange. C. Add additional measures to the table values. D. Add icons to represent the sales status of each product.

Correct Answer: D

You have a Power BI app that contains a report named Report1. You add a new page to Report1. You need to ensure that users can view the new page. The solution must minimize administrative effort. What should you do? A. Update the audience in the app. B. Update the app. C. Update the contact information in the app. D. Unpublish and create a new app.

Correct Answer: B

pagina 24 question 1 topic 4

YES - NO - YES

You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement? A. Microsoft Intune policies B. row-level security (RLS) C. sensitivity labels D. dataset certifications

C. sensitivity labels

You have a Microsoft Excel file on a file server. You create a Power BI report and import a table from the Excel file. You publish the report. You need to ensure that the data refreshes every four hours. What should you do first? A. Upload the Excel file to a Power BI workspace. B. Create a subscription to the report. C. Deploy an on-premises data gateway. D. Edit the data source credentials.

C. Deploy an on-premises data gateway.

You have a Power BI report that contains the visuals shown in the following table. pagina 23 question 76 topic 3 You need to modify the location of each visual. What should you modify for each visual? A. the layer order B. the padding C. the position D. the tab order

C. the position

You have a Power BI report. The report contains a line chart that displays sales data for several regions. You need to add an element to the report that will enable users to filter the sales data to include only a selected region. Which two elements achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. a slicer visual B. a drillthrough filter C. a table visual D. a card visual E. a Key Performance Indicator (KPI) visual

A. a slicer visual and C. a table visual

You have the CSV file shown in the following table. a tabela esta na pagina 23 question 79 topic 3 You use Power Query Editor to preview the data in the file. You need to transform the data to meet the following requirements: * The first column must contain the month. * The second column must contain the year. * The third column must contain the order amount for the month and year. Which transformation should you use first? A. remove B. unpivot C. transpose D. pivot

B. unpivot

You are creating a Power BI single-page report. Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader. You need to ensure that the users can consume content on a report page in a logical order. What should you configure on the report page? A. the layer order B. the X position C. the bookmark order D. the tab order

D. the tab order

You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. figura na pagina 23 question 81 topic 3 Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. First-level elements colors B. Theme colors C. Divergent colors D. Sentiment colors

B. Theme colors C. Divergent colors

You need to use Power BI to create a visual that will allow users to compare the sales performance of five sales regions for the current month. Which visual should you use? A. a line chart B. a stacked bar chart C. a 100% stacked bar chart D. a waterfall chart

B. a stacked bar chart

HOTSPOT - You have a Power BI workspace. You need to create two reports that meet the following requirements: * Report1: Optimized for printing and can be delivered to users via a scheduled email subscription * Report2: Optimized for dynamic user interactivity Which format should you use for each report? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. IMAGEM PAGINA 23 QUESTION 84 TOPIC 3

Box1:Power bi Paginated Box2:Power bi | A RESPOSTA CORRECTA ESTA NOS COMENTARIOS

pagina 22 question 66 topic 3

Key phrase extraction Sentimental Analysis Language Detection ## Footnote - Key Phrase Extraction: a text analysis technique that extracts important words and phrases from the input text - Sentiment analysis: is the process of analyzing digital text to determine if the emotional tone of the message is positive, negative, or neutral - Language Detection: usually used to identify the language of business texts like emails and chats

You have a Power BI report named ReportA. You have a Power BI tenant that allows users to export data. You need to ensure that consumers of ReportA cannot export any data from visuals. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. From Power BI Desktop, modify the Report settings. B. From Power BI Desktop, modify the Data Load settings. C. From the Power BI service, modify the dataset permissions. D. From the Power BI service, modify the Report settings.

A. From Power BI Desktop, modify the Report settings. D. From the Power BI service, modify the Report settings.

You have a Power BI report that will be rendered on a vertical display. You need to maximize the portion of the screen area used by the report. What should you do? A. From the Canvas background setting of Power BI Desktop, configure the Image fit setting. B. From the Canvas settings of Power BI Desktop, set a custom width and height. C. From Power BI Desktop, select Personalize visuals. D. From the Power BI service, enable the Pages pane.

B. From the Canvas settings of Power BI Desktop, set a custom width and height.

You need to create a visual that compares profit across 10 product categories fora selected quarter. What is the best visual to use to achieve the goal? A. an area chart B. a funnel chart C. a clustered bar chart D. a line chart

C. a clustered bar chart

You have a Power BI dataset named Finance that is hosted in a Power BI workspace. The finance team at your company is NOT currently a member of any Power BI workspace roles. You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset. What should you do? A. Grant the finance team build permissions to the Finance dataset. B. Provide an Excel workbook that is connected to the Finance dataset. C. Create a row-level security (RLS) role and add the finance team to the role as members. D. Grant the finance team write permissions to the Finance dataset.

A. Grant the finance team build permissions to the Finance dataset.

You have a Power BI report that contains a visual. The visual contains a measure. You need to ensure that the report meets the following requirements: * All values must be set to two decimal places. * All negative values must be displayed in red font and parentheses. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. For the visual, apply conditional formatting to the background color. B. Configure the measure to use a custom format. C. For the visual, apply conditional formatting to the font color. D. For the visual, set Value decimal places to 2.

B. Configure the measure to use a custom format. C. For the visual, apply conditional formatting to the font color.

You have a Power BI model that contains two tables named Population and Date. The Population table contains two columns named PopulationAmount and DateKey. DateKey contains date values that represent the first day of a year and are used to create a many-to-one relationship with the Date table. The Power BI model contains two measures that have the following definitions. Total Population = Sum(‘Population’[PopulationAmount]) 2023 Population = CALCULATE([Total Population], ‘Date'[Year] = 2023) You create a table visual that displays Date[Year] and [2023 Population]. What will the table visual show? A. one row per year that contains blank values for every year except 2023 B. one row per date that contains the population value for the corresponding year repeated in each row C. a single row for the year 2023 that contains the related population value D. one row per year that contains the same value repeated for each year

D. one row per year that contains the same value repeated for each year | é uma tabela

You have a Power BI dataset that contains quarterly sales performance data. You need to enable managers to review the data in a format that meets the following requirements: * Is optimized for printing. * Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats. What should you create? A. a template app B. a dashboard C. a paginated report D. an interactive report

C. a paginated report

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 median line by using the Salary measure.** Does this meet the goal? A. Yes B. No

yes

You have a Power BI report that contains four pages. All the pages contain a slicer for a field named Country. You need to ensure that when a user selects a country on page 1, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages. What should you do? A. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters. B. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters. C. Move the Country slicer from page 2 and page 3 to page 1. D. Sync the Country slicer on page 1, page 2, and page 3.

D. Sync the Country slicer on page 1, page 2, and page 3.

pagina 21 question 60 topic 3

Add a bookmark navigation button -> Group the three bookmarks -> Change the Bookmark property for the button. | resposta correcta esta nos comentarios

You plan to use Power BI to create sales invoices for customers. The solution must meet the following requirements: * Sales invoices must be exported in a PDF format. * The PDF exports must show all columns and rows clearly. What should you create? A. a paginated report that contains a tablix B. a dashboard that contains a table C. an interactive report that contains a table D. an interactive report that contains a matrix

A. a paginated report that contains a tablix

You have a Power BI report that contains a page. The page contains the following: * A shape named Shape1 * A card named Sales Summary * A clustered bar chart named Sales by Region You need to ensure that Sales Summary renders on top of Shape1. What should you modify? A. Tab order in the Selection pane B. Layer order in the Selection pane C. Maintain layer order in the General visual settings D. Vertical alignment in the Canvas settings

B. Layer order in the Selection pane

You have a Power BI report named Report1 and a dashboard named Dashboard1. Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard1. What should you do? A. Refresh the dataset used by Report1 and Dashboard1. B. Pin the Sales by month bar chart to Dashboard1. C. Select Refresh visuals for Dashboard1. D. Edit the details for the dashboard tile of Dashboard1.

B. Pin the Sales by month bar chart to Dashboard1. ## Footnote When you pin a visual to a dashboard, you are essentially taking a snapshot of that visual at that point in time and adding it to the dashboard as a tile. Any changes made to the original visual in the report will not automatically reflect in the dashboard tile. To display the bar chart on Dashboard1, you need to pin the new Sales by month bar chart to Dashboard1.

In Power BI Desktop, you are creating a report that will contain three pages. You need to create a custom tooltip page and prepare the page for use. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. For the tooltip page, set Allow use as tooltip to On. B. For the target page, set Allow use as tooltip to On. C. Configure filters on the target visual. D. For the tooltip page, configure filters. E. Add and configure visuals on the tooltip page.

A. For the tooltip page, set Allow use as tooltip to On. D. For the tooltip page, configure filters. E. Add and configure visuals on the tooltip page.

You have a Power BI report. You have a table named Data1 that contains 10 million rows. Data1 is used in the following visuals: ✑ A card that shows the number of records ✑ A bar chart that shows total transaction amount by territory ✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory **You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals.** What should you do? A. Add a count field of the transaction amount to the size bucket of the scatter plot. B. Add a trend line to the scatter plot. C. Enable high-density sampling on the scatter plot. D. Apply a row filter to the Data1 query in Power Query Editor.

C. Enable high-density sampling on the scatter plot.

You have a Power BI workspace named Inventory that contains a dataset, a report, and a dashboard. You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Ask a question by using Q&A. B. Hide the report page. C. Pin the visual to the dashboard. D. Use quick insights on the dashboard. E. Add the visual to the report.

A. Ask a question by using Q&A. C. Pin the visual to the dashboard. | saiu no exame

You have a Power BI report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do? A. On each page, modify the interactions of the slicer. B. Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2. C. Sync the slicers on Page1 and Page3.

C. Sync the slicers on Page1 and Page3.

You have a Power BI report that contains five pages. Pages 1 to 4 are visible and page 5 is hidden. You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report. What should you do first? A. Add a blank button to page 1. B. Add a page navigation button to page 1. C. Create a bookmark for each page. D. Add a bookmark navigation button to page 1.

B. Add a page navigation button to page 1.

You build a Power BI report that displays IoT temperature data streaming from a refrigerator. You publish the report to the Power BI service. You need to be notified when the temperature rises above four degrees Celsius. What should you do? A. Set an alert on a KPI visual in the report. B. Pin a card visual to a dashboard and create a subscription. C. Pin a card visual to a dashboard and set an alert on the tile. D. Pin a report page to a dashboard and set an alert on the page.

C. Pin a card visual to a dashboard and set an alert on the tile. | SAIU NO EXAME

PAGINA 20 QUESTION 53 TOPIC 3 (CAIU NO EXAME)

A. Create and apply a custom dashboard theme. | CAIU NO EXAME

You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do? A. From Power BI Desktop, customize the current theme. B. From Power BI Desktop, use a built-in report theme. C. Create a theme as a PBIVIZ file and import the theme into Power BI Desktop. D. Create a theme as a JSON file and import the theme into Power BI Desktop.

D. Create a theme as a JSON file and import the theme into Power BI Desktop.

You have a Power BI report that contains one page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three visuals: * Switch the measures used in the visuals. * Change the visualization type. * Add a legend. The solution must minimize development effort. What should you do? A. Create a bookmark for each acceptable combination of visualization type, measure, and legend in the bar chart. B. Edit the interactions between the three visuals. C. Enable personalization for the report. D. Enable personalization for each visual.

C. Enable personalization for the report.

You have a Power BI semantic model that contains two queries. You discover that a report based on the model has performance issues. You plan to use Power Query to reduce the data loaded to the model. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point. A. Apply group by and summarize techniques. B. Combine the queries by using Append. C. Remove unnecessary columns and rows. D. Combine the queries by using Merge. E. Create a new query group.

A. Apply group by and summarize techniques. C. Remove unnecessary columns and rows.

You have an on-premises data gateway. You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode. **Solution: You create aggregations to summarize results.** Does this meet the goal? A. Yes B. No

B. No ## Footnote Create aggregations to summarize results. This seems to be saying group and summarize after the data has come through the gateway as an import. This will not reduce the traffic as it has already come through the gateway. Answer : B.No.

You have an on-premises data gateway. You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode. **Solution: You increase Automatic page refresh intervals.** Does this meet the goal? A. Yes B. No

B. No ## Footnote The correct answer is No. Automatic Refresh can only be used in direct query mode

You have an on-premises data gateway. You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode. **Solution: You configure incremental refresh.** Does this meet the goal? A. Yes B. No

A. Yes ## Footnote Incremental refresh allows you to load only new or changed data, rather than refreshing the entire dataset. This can significantly reduce the amount of data that needs to be processed and transferred, especially in large datasets.

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment. How should the visual interactions be set on the column chart when the bar chart is selected? A. highlight B. filter C. no impact

A. highlight ## Footnote The keyword is 'Show a portion of the result.'

A user creates a Power BI report named ReportA that uses a custom theme. You create a dashboard named DashboardA. You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Publish ReportA to Power BI. B. From ReportA save the current theme. C. Publish ReportA to the Microsoft Power BI Community theme gallery. D. From DashboardA, create a custom theme. E. From DashboardA, upload a JSON theme.

B. From ReportA save the current theme. E. From DashboardA, upload a JSON theme.

You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use? A. waterfall chart B. stacked area chart C. line chart D. donut chart

C. line chart | ...over time -> Line chart

You build a report to help the sales team understand its performance and the drivers of sales. **The team needs to have a single visualization to identify which factors affect success.** Which type of visualization should you use? A. Key influencers B. Line and clustered column chart C. Q&A D. Funnel chart

A. Key influencers | WAS ON THE EXAM 02 03 2024

pagina 16 question 8 topic 3

A. Customers in Austria order 18.8 more units than the average order quantity. ## Footnote The "Qty x order" is measured in Quantity of Items, then, as stated in option A, Austrian customers order 18.8 more units that the average as it's explained on the left pane of the visual.

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values in a slicer on one page, the selections are not persisted on other pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Create a bookmark for each slicer value. B. Replace the slicers with report-level filters. C. Sync the slicers across the pages. D. Replace the slicers with page-level filters. E. Replace the slicers with visual-level filters.

B. Replace the slicers with report-level filters. C. Sync the slicers across the pages.

You have a report that includes a card visualization. You need to apply the following conditional formatting to the card while minimizing design effort: ✑ For values that are greater than or equal to 100, the font of the data label must be dark red. ✑ For values that are less than 100, the font of the data label must be dark gray. Which type of format should you use? A. Color scale B. Rules C. Field value

B. Rules

You are creating a dashboard by using the Power BI service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do? A. Edit interactions in the report and set all interactions to Filter. B. Pin each chart as a tile. C. Edit the dashboard theme and pin each chart as a tile. D. Pin the report page as a live tile.

D. Pin the report page as a live tile.

You are building a Power BI report. Users will view the report by using their mobile device. You need to configure the report to display data based on each user's location. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. From Power Query Editor, detect the data types of the relevant columns. B. In Data Category, set the geographic data category for the relevant columns. C. Create a hierarchy for columns of the geography data type. D. Use the columns of the geography data type in all visuals. E. For the relevant columns, set synonyms to match common geographical terms.

B. In Data Category, set the geographic data category for the relevant columns. D. Use the columns of the geography data type in all visuals.

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings. You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column. What should you do? A. Select the donut chart and set the column chart interaction to Filter. B. Select the column chart and set the donut chart interaction to Filter. C. Select the donut chart and set the column chart interaction to None. D. Select the column chart and set the donut chart interaction to None.

B. Select the column chart and set the donut chart interaction to Filter.

You are creating a Power BI report by using Power BI Desktop. **You need to include a visual that shows trends and other useful information automatically.** The visual must update based on selections in other visuals. Which type of visual should you use? A. Q&A B. smart narrative C. key influencers D. decomposition tree

B. smart narrative | This was on the exam today. Passed with 917/1000

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? A. Yes B. No

B. No | This was in the exam

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? A. Yes B. No

B. No | This was in the exam

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? A. Yes B. No

A. Yes | This was in the exam

pagina 17 question 25 topic 3

are 20 values tha occur elm, american | This Question was in the exam today 9/12/2023

You have a Power BI report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. **You need to enable users to choose between viewing the report as a line chart or a column chart**. The solution must minimize development and maintenance effort. What should you do? A. Enable report readers to personalize visuals. B. Create a separate report page for users to view the column chart. C. Add a column chart, a bookmark, and a button for users to choose a visual. D. Create a mobile report that contains a column chart.

A. Enable report readers to personalize visuals. ## Footnote Also C is correct but I guess the key is 'The solution must minimize development' so A should be the correct one

You have two Power BI reports named ReportA and ReportB that each uses a distinct color palette. You are creating a Power BI dashboard that will include two visuals from each report. You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Upload a snapshot. B. For the browser, set the color preference to dark mode. C. When pinning visuals to the dashboard, select Use destination theme. D. Select the dark dashboard theme. E. Turn on tile flow.

C. When pinning visuals to the dashboard, select Use destination theme. D. Select the dark dashboard theme.

pagina 18 question 28 topic 3

Line, Populate the axis with date field ## Footnote Remember that "Show Anomalies" only works with line charts (as of this writing)

# 1. You have a line chart that shows the number of employees in a department over time. **You need to see the total salary costs of the employees when you hover over a data point**. What should you do? A. Add salary to the drillthrough fields. B. Add salary to the visual filters. C. Add salary to the tooltips.

C. Add salary to the tooltips.

pagina 18 question 30 topic 3

D. a forecast | This was in the exam

pagina 18 question 31 topic 3

B. decomposition tree

Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state. You need to view the employees by region as quickly as possible. What should you do? A. Create a new aggregation that summarizes by state. B. Create a new aggregation that summarizes by employee. C. Create a new group on the state column and set the Group type to List. D. Create a new group on the state column and set the Group type to Bin.

C. Create a new group on the state column and set the Group type to List.

You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department **that shows historical employee counts and predicts trends during the next six months**. Which type of visualization should you use? A. ribbon chart B. scatter chart C. line chart D. key influencers

C. line chart

pagina 18 question 34 topic 3

B. The dashboard tile cache refreshed.

pagina 18 question 35 topic 3

-2 -Display

pgina 19 questao 36 topic 3

A. Add a play axis. | This question was on the exam today 9/12/2023.

You are building a Power BI report to analyze customer segments. You need to identify c**ustomer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics**. The solution must minimize analysis effort. Which type of visualization should you use? A. decomposition tree B. funnel chart C. Q&A D. key influencers

A. decomposition tree

You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use? A. area chart B. scatter plot C. pie chart D. donut chart

B. scatter plot

You have a report that contains three pages. One of the pages contains a KPI visualization. **You need to filter all the visualizations in the report except for the KPI visualization.** Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Edit the interactions of the KPI visualization. B. Add the same slicer to each page and configure Sync slicers. C. Edit the interactions of the slicer that is on the same page as the KPI visualization. D. Configure a page-level filter. E. Configure a report-level filter.

B. Add the same slicer to each page and configure Sync slicers. C. Edit the interactions of the slicer that is on the same page as the KPI visualization.

pasgina 19 question41 topic 3

1 A LINE 2 ANOMALY DETECTION

You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. **You need to include a visual that identifies which fields have the greatest impact on Spend**. Which type of visual should you use? A. Q&A B. smart narrative C. decomposition tree D. key influencers

D. key influencers | This question was on the exam today 9/12/2023

You have a Power BI report. The report contains a visual that shows gross sales by date. The visual has anomaly detection enabled. No anomalies are detected. You need to increase the likelihood that anomaly detection will identify anomalies in the report. What should you do? A. Increase the Expected range transparency setting. B. Add a data field to the Legend field well. C. Increase the Sensitivity setting. D. Add a data field to the Secondary values field well.

C. Increase the Sensitivity setting.

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured. You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings. What should you do? A. Create an inactive relationship between the tables and select Apply security filter in both directions. B. Create an active relationship between the tables and select Apply security filter in both directions. C. Create an inactive relationship between the tables and select Assume referential integrity. D. Create an active relationship between the tables and select Assume referential integrity.

B. Create an active relationship between the tables and select Apply security filter in both directions.

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend? A. Change any DAX measures to use iterator functions. B. Enable visual interactions. C. Replace the default visuals with AppSource visuals. D. Split the visuals onto multiple pages.

D. Split the visuals onto multiple pages.

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky" Role2 contains the following filter. Date[Calendar Year] = 2020 - If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model? A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020. B. The user will receive an error and will not be able to see the data in the report. C. The user will only see data for which the State Province value is Kentucky. D. The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.

A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.

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: From Power Query Editor, you import the table and then add a filter step to the query.** Does this meet the goal? A. Yes B. No

B. No

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? A. Yes B. No

B. No

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 add a WHERE clause to the SQL statement. Does this meet the goal? A. Yes B. No

A. Yes | This was on the exam today. Passed with 917/1000

You are creating a report in Power BI Desktop. You load a data extract that includes a free text field named coll. **You need to analyze the frequency distribution of the string lengths in col1.** The solution must not affect the size of the model. What should you do? A. In the report, add a DAX calculated column that calculates the length of col1 B. In the report, add a DAX function that calculates the average length of col1 C. From Power Query Editor, add a column that calculates the length of col1 D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions. Each sales region has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers? A. Publish the reports in an app and grant the HR managers access permission. B. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace. C. Publish the reports to a different workspace other than the one hosting the datasets. D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

A. Publish the reports in an app and grant the HR managers access permission.

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user? A. Viewer B. Admin C. Contributor D. Member

D. Member

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? 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.

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

uestion #34Topic 1 You plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps. From Power BI Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements: * Use Analytics views. * Filter data from the cloud. Which connector should you use? A. OData queries B. Azure DevOps (Boards only) C. Azure DevOps Server (Boards only) D. OData Feed

D. OData Feed

# ``` ``` You have a data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. **Solution: You implicitly convert the values into the required type.** Does this meet the goal? A. Yes B. No

B. No

You have a data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. **Solution: You change the semantic model mode.** Does this meet the goal? A. Yes B. No

B. No

You have a data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. **Solution: You normalize casing in the source query or Power Query Editor.** Does this meet the goal? A. Yes B. No

A. Yes

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI semantic model. You need to ensure that the semantic model can be refreshed in PowerBi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Web B. Excel Workbook C. Folder D. Text/CSV E. SharePoint folder

A. Web E. SharePoint folder

From Power Query Editor, you attempt to execute a query and receive the following error message. Datasource.Error: Could not find file. What are two possible causes of the error? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. You do not have permissions to the file. B. An incorrect privacy level was used for the data source. C. The file is locked. D. The referenced file was moved to a new location.

A. You do not have permissions to the file. D. The referenced file was moved to a new location.

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do? A. Apply the Parse function from the Data transformations options to the Logged column. B. Change the data type of the Logged column to Date. C. Split the Logged column by using at as the delimiter. D. Create a column by example that starts with 2018-12-31.

C. Split the Logged column by using at as the delimiter.

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table. **You need to combine the tables into a single query that contains the unique columns of each table.** What should you select in Power Query Editor? A. Merge queries B. Combine files C. Append queries

A. Merge queries

You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network. You are notified that the Excel data source was moved to a new location. You need to update the PBIX file to use the new location. What are three ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. From the Datasets settings of the Power BI service, configure the data source credentials. B. From the Data source settings in Power BI Desktop, configure the file path. C. From Current File in Power BI Desktop, configure the Data Load settings. D. From Power Query Editor, use the formula bar to configure the file path for the applied step. E. From Advanced Editor in Power Query Editor, configure the file path in the M code.

B. From the Data source settings in Power BI Desktop, configure the file path. D. From Power Query Editor, use the formula bar to configure the file path for the applied step. E. From Advanced Editor in Power Query Editor, configure the file path in the M code.

You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection? A. Add a SQL statement. B. Set the Command timeout in minutes setting. C. Set Data Connectivity mode to Import. D. Set Data Connectivity mode to DirectQuery.

D. Set Data Connectivity mode to DirectQuery.