Microsoft Power BI Certification (PL-300) Practice Test 17

Global delivery firms hire Power BI analysts because every engagement eventually needs a dashboard the account team can refresh without the original author. Power BI is the handoff: data analysts design the model, data scientists attach experiment insight, and the published report becomes the weekly ritual. The PL-300 credential names you a Microsoft Power BI Data Analyst Associate and travels between accounts. Benefits include a standard employers can filter for and a renewal path so the badge does not go stale. This Free Microsoft Power BI Data Analyst Associate Certification (PL-300) Practice Test 17 is the right first step if you are still deciding whether to register. Demand of this kind is common at Capgemini, Cognizant, and Infosys. U.S. base pay varies by city and industry: junior data analysts often earn $58,000–$75,000, mid-level analysts commonly earn $78,000–$108,000, and senior data analysts frequently reach $112,000–$145,000. Synergisticit JOPP helps jobseekers get certified, prepared, and hired at top tech companies through our Job Placement programs—Java DevOps Full Stack JOPP and Data Science JOPP.

If you want to learn how to get hired as a Power BI Data Analyst, Data Scientist, Data Engineer, AI or ML engineer, Java developer, or software engineer, contact Synergisticit for expert upskilling and marketing connections to companies. Visit Synergisticit Contact Us and Synergisticit JOPP.

Welcome to your Microsoft Power BI - Test-17

Name

Phone

Q1. You are working with a large dataset in Power BI that contains sensitive information. The dataset needs to be refreshed on a regular basis to reflect the latest data from the source system. However, you need to ensure that only authorized users can access the refreshed dataset. What should you do to achieve this?

Select 1 option(s):

A. Configure Row-Level Security (RLS) in Power BI to restrict access to the sensitive data based on user roles or attributes.

B. Use Azure Data Factory to schedule the dataset refresh and encrypt the data at rest.

C. Implement Multi-Factor Authentication (MFA) for all users accessing the Power BI report.

D. Enable Data Classification labels in Power BI to identify and protect sensitive data within the dataset.

Q2. You have a CSV file containing user complaints. The file includes a column named “Logged“ that stores the date and time each complaint occurred in the format “2018-12-31 at 08:59“. To analyze the complaints by the logged date and utilize a built-in date hierarchy, what approach should you take?

Select 1 option(s):

A. Apply a transformation to extract the date portion from the “Logged“ column and set its data type to Date.

B. Split the “Logged“ column using “at“ as the delimiter and select the date portion as a new column.

C. Use the “Parse“ function from the Date transformation options to convert the “Logged“ column to a Date data type.

D. Add a conditional column that checks if the “Logged“ column starts with “2018“ and set the data type of the new column to Whole Number.

Q3. You have a CSV file that contains user complaints. The file has a column named “Logged“ which contains the date and time each complaint occurred in the 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?

Select 1 option(s):

A. Apply a transformation to extract the first 11 characters of the “Logged“ column.

B. Add a conditional column that outputs “2018“ if the “Logged“ column starts with “2018“ and set the data type of the new column to Whole Number.

C. Create a column by example that starts with “2018-12-31“ and set the data type of the new column to Date.

D. Apply a transformation to extract the last 11 characters of the “Logged“ column and set the data type of the new column to Date.

Q4. A company wants to analyze customer feedback data stored in a Microsoft Excel workbook using Power BI. The workbook contains multiple worksheets, and each worksheet represents a different product category. The company wants to create separate visuals for each product category in the Power BI report. What should you do to achieve this?

Select 1 option(s):

A. Import each worksheet from the Excel workbook as a separate table in Power Query and create visuals for each table.

B. Convert each worksheet into a separate Power BI dataset and create visuals for each dataset.

C. Combine all the worksheets into a single table in Power Query and use a slicer to filter the data by product category.

D. Manually copy and paste the data from each worksheet into separate tables in the Power BI report and create visuals for each table.

Q5. Your organization has multiple regional offices, and each office has its own HR department. You have a set of Power BI reports that need to be accessible to each regional HR department while maintaining data isolation and preventing layout changes. What is the recommended approach?

Select 1 option(s):

A. Create separate workspaces for each regional HR department and publish the reports in their respective workspaces.

B. Implement row-level security (RLS) to restrict data access for each regional HR department while keeping the reports in a centralized workspace.

C. Publish the reports to a centralized workspace and assign individual access permissions to HR managers based on their regional departments.

D. Convert the reports to Power BI Apps and distribute them to each regional HR department, ensuring data segregation and report layout protection.

Q6. You are responsible for managing a Power BI workspace that contains sensitive financial data. You need to grant a user the ability to add new members to the workspace while adhering to the principle of least privilege. Which role should you assign to the user?

Select 1 option(s):

A. Viewer

B. Admin

C. Contributor

D. Member

Q7. You have a Microsoft Power BI report that connects to a SQL Server database. The report is experiencing slow performance when loading data from a specific table that contains millions of rows. What should you do to improve the performance of the report?

Select 1 option(s):

A. Apply query folding to the SQL Server query in Power Query Editor to optimize data retrieval.

B. Enable data compression on the SQL Server database to reduce the size of the table.

C. Create a summary table or aggregate the data in the SQL Server database to reduce the number of rows accessed by the report.

D. Use DirectQuery mode instead of import mode to query the SQL Server database in real-time.

Q8. You have a Power BI report that retrieves data from a SQL Server database. The report takes a significant amount of time to load, especially when applying filters or interacting with visuals. What should you do to improve the performance of the report?

Select 1 option(s):

A. Enable query folding to optimize the data retrieval from the database.

B. Increase the refresh frequency of the dataset to ensure up-to-date data.

C. Create indexes on the database tables used by the report.

D. Implement incremental refresh to load only new or modified data.

Q9. You have a Power BI report that contains multiple visuals, including a table and a bar chart. You want to apply the same visual style (e.g., font, color scheme) to all visuals in the report. What should you do?

Select 1 option(s):

A. Manually adjust the formatting settings for each visual individually.

B. Use a report template to apply the desired visual style to all visuals in the report.

C. Copy and paste the formatting from one visual to other visuals in the report.

D. Apply a theme to the report to automatically style all visuals based on predefined settings.

Q10. You have a SharePoint document library that contains Excel workbooks. The workbooks are updated daily with new data. You want to automate the process of importing the data from the Excel workbooks into Power BI. What should you do to achieve this?

Select 1 option(s):

A. Use Power Query to connect to the SharePoint document library and set up scheduled data refresh in Power BI.

B. Convert the Excel workbooks into Power BI datasets and set up scheduled refresh in the Power BI service.

C. Use Power Automate to trigger a refresh of the data in Power BI whenever a new file is added to the SharePoint document library.

D. Manually import the data from the Excel workbooks into Power BI whenever updates are made to the files.

Q11. You are building a Power BI report that requires data from a web-based API. However, you notice that there is no specific connector available for the API in the Get Data connector list. What should you do to retrieve data from the API into Power BI?

Select 1 option(s):

A. Use the Web connector to connect to the API and retrieve the data.

B. Export the data from the API to a supported file format (e.g., JSON or CSV), and then use the corresponding connector to import the data into Power BI.

C. Create a custom connector using Power Query M language to connect to the API and retrieve the data.

D. Utilize Power Automate to fetch the data from the API and push it to a supported data source that can be connected to Power BI.

Q12. A company wants to track the performance of their marketing campaigns using Power BI. They have data stored in various cloud-based platforms such as Google Analytics, Facebook Ads, and Twitter Ads. The company wants to consolidate this data into a single Power BI report for analysis. Which approach should you recommend to connect Power BI with these cloud-based platforms?

Select 1 option(s):

A. Use the built-in connectors for each platform to import the data directly into Power BI.

B. Export the data from each platform and import it into Power BI using the Text/CSV connector.

C. Manually copy and paste the data from each platform into a single Excel workbook, then import the workbook into Power BI using the Excel Workbook connector.

D. Use Power Automate to automate the data extraction from each platform and import it into Power BI using the appropriate connectors.

Q13. A company wants to analyze customer data stored in a Microsoft Excel workbook using Power BI. The workbook is regularly updated with new data, and they want to ensure that the Power BI report reflects the latest information without manual intervention. What should you do to achieve this?

Select 1 option(s):

A. Use Power Query Editor to connect to the Excel workbook and set up scheduled data refresh in Power BI.

B. Convert the Excel workbook into a Power BI dataset and set up scheduled refresh in the Power BI service.

C. Use Power Automate to automate the process of importing data from the Excel workbook into Power BI.

D. Manually refresh the data in Power BI whenever updates are made to the Excel workbook.

Q14. You have a Power BI report that contains multiple visuals and is accessed by users in a shared capacity environment. Users have reported slow performance when interacting with the visuals. What should you recommend to improve the performance of the report?

Select 1 option(s):

A. Optimize the DAX calculations and formulas used in the report.

B. Increase the shared capacity resources allocated to the App workspace.

C. Implement query caching to improve the retrieval of data for the visuals.

D. Utilize Power BI Paginated Reports for better performance with large datasets.

Q15. Your company has implemented a custom connector that retrieves employee attendance data, including check-in and check-out timestamps. You need to create a Power BI report that presents attendance trends without disclosing the specific timestamps to the report recipients. How can you accomplish this while maintaining data privacy?

Select 1 option(s):

A. Calculate and display average check-in and check-out times without revealing the individual timestamps.

B. Apply data aggregation techniques to summarize attendance data at different time intervals (e.g., daily, weekly) and present the aggregated trends in the report.

C. Implement dynamic data masking on the check-in and check-out timestamps to conceal the specific values while still showing attendance patterns.

D. Exclude the check-in and check-out timestamps from the report dataset and focus on visualizing attendance trends based on other relevant metrics, such as daily attendance count or absenteeism rate.

Q16. You have imported a dataset into Power BI Desktop that contains a column named “Comments“ with free-text data. You want to analyze the sentiment of the comments. What should you do to perform sentiment analysis without affecting the model size?

Select 1 option(s):

A. Use Power Query Editor to add a column that assigns sentiment scores to the comments based on natural language processing.

B. Add a DAX calculated column that assigns sentiment scores to the comments based on predefined rules.

C. Utilize Power Automate to extract the comments and perform sentiment analysis using a cloud-based AI service.

D. Apply the Text Analytics feature in Power Query Editor to analyze the sentiment of the comments directly within the query.

Q17. You are working on a Power BI project that requires connecting to an Oracle database. However, when you try to establish the connection, you notice that there is no specific Oracle connector available in the Get Data connector list. What should you do to connect Power BI to the Oracle database?

Select 1 option(s):

A. Use the ODBC connector to establish a connection to the Oracle database.

B. Install the Oracle client software on your machine and then select the Oracle connector from the Get Data connector list.

C. Export the data from the Oracle database to a supported file format (e.g., CSV or Excel), and then use the corresponding connector to import the data into Power BI.

D. Create a custom connector using Power Query M language to connect to the Oracle database.

Q18. You have a Microsoft Power BI report stored in an App workspace with shared capacity. The report utilizes an imported dataset that includes a large fact table with 12 million rows. Users have experienced sluggish performance when interacting with the report‘s visuals. What action should you suggest to enhance the report‘s performance?

Select 1 option(s):

A. Enable visual interactions to optimize the response time.

B. Refactor the DAX measures to utilize iterator functions for faster calculations.

C. Apply row-level security (RLS) to limit data access for improved performance.

D. Remove any unnecessary columns from the tables in the data model to reduce the file size.

Q19. You have a Power BI data model that consists of two tables named Sales and Product. There is a one-to-many relationship between Product and Sales. The Sales table contains the columns: SalesID, ProductID, Quantity, and Amount. The Product table contains the columns: ProductID, ProductName, and Category. You want to create a report that shows the total sales amount by category. Which visualization should you use?

Select 1 option(s):

A. Stacked bar chart

B. Line chart

C. Scatter chart

D. Pie chart

Q20. You are developing a Power BI report that analyzes customer satisfaction survey responses. The survey includes multiple choice questions with options ranging from “Very Satisfied“ to “Very Dissatisfied.“ You want to ensure that the report viewers can see the overall satisfaction level without seeing individual responses. What should you do to achieve this?

Select 1 option(s):

A. Aggregate the survey responses by satisfaction level and display the aggregated data in the report.

B. Implement row-level security (RLS) to restrict access to individual survey responses based on user roles.

C. Use data masking techniques to obfuscate the specific responses while showing the overall satisfaction level.

D. Remove the multiple choice question responses from the data source and only display the aggregated satisfaction level in the report.

Q21. You are working on a project where you have a custom connector that retrieves sensitive data about customer purchases, including customer names, addresses, and purchase details. You need to create a Power BI report that analyzes the purchase trends without exposing the customer information to the report recipients. What should you do?

Select 1 option(s):

A. From Model view, set the customer name and address columns to Hidden.

B. Remove the customer name and address columns during the import.

C. Implement row-level security (RLS) so that the report recipients can only see aggregated results without accessing individual customer data.

Q22. You have a CSV file containing user complaints, and one of the columns is “Logged,“ which includes the date and time each complaint occurred in the format “2018-12-31 at 08:59“. You want to analyze the complaints by the logged date using a built-in date hierarchy. What is the recommended approach to achieve this?

Select 1 option(s):

A. Convert the Logged column to the DateTime data type.

B. Extract the date portion from the Logged column using the Power Query Editor.

C. Split the Logged column using “at“ as the delimiter to separate the date and time.

D. Apply the Parse function to the Logged column using the specified date format.

Q23. You are a business intelligence developer working on a Power BI project. The project involves creating a dashboard that provides real-time insights into sales data. The sales data is stored in a cloud-based Microsoft Azure SQL Database. The dashboard needs to be accessible to both internal users within your organization and external partners. What should you do to achieve these requirements?

Select 1 option(s):

A. Create a Power BI report that connects directly to the Azure SQL Database using DirectQuery mode. Publish the report to the Power BI service and share it with internal users and external partners.

B. Import the sales data from the Azure SQL Database into Power BI using the appropriate connector. Create a Power BI dashboard based on the imported data. Publish the dashboard to the Power BI service and share it with internal users and external partners.

C. Use Power Automate to extract the sales data from the Azure SQL Database and push it to a cloud-based data storage solution. Connect Power BI to the cloud-based data storage solution and create a dashboard based on the data. Share the dashboard with internal users and external partners.

D. Export the sales data from the Azure SQL Database to a Microsoft Excel file. Import the Excel file into Power BI using the appropriate connector. Create a Power BI dashboard based on the imported data. Share the dashboard with internal users and external partners.

Q24. A company has multiple data sources, including an on-premises SQL Server database, an Azure SQL Database, and a Salesforce CRM. They want to create a centralized data model in Power BI that combines data from these sources for reporting and analysis purposes. The solution should minimize data duplication and ensure data consistency. Which approach should you recommend for building the data model in Power BI?

Select 1 option(s):

A. Import the data from each source into separate Power BI datasets and create relationships between the datasets.

B. Use DirectQuery mode to connect directly to each data source and create relationships in Power BI.

C. Create dataflows for each data source and use Power Query Editor to build the data model in Power BI.

D. Build a centralized data warehouse that consolidates the data from all sources and connect Power BI to the data warehouse.

Q25. A company wants to create a Power BI report that includes data from a variety of sources, including a SQL Server database, a SharePoint list, and a Salesforce CRM. They want to ensure that the data is refreshed regularly and available for analysis in real-time. Which feature of Power BI should you use to accomplish this?

Select 1 option(s):

A. Power Query Editor

B. DirectQuery mode

C. Scheduled Refresh

D. Power BI Gateway

Q26. You are building a Power BI report that includes data from multiple sources, including an on-premises SQL Server database and a cloud-based CRM system. The on-premises SQL Server database is behind a firewall and can only be accessed through a VPN connection. What should you do to ensure that the Power BI report can retrieve data from both sources?

Select 1 option(s):

A. Install and configure an on-premises data gateway to establish a secure connection between the Power BI service and the on-premises SQL Server database.

B. Export the data from the on-premises SQL Server database and import it into the cloud-based CRM system. Connect Power BI directly to the cloud-based CRM system to retrieve the combined data.

C. Use Power Automate to extract data from the on-premises SQL Server database and push it to a cloud-based data storage solution. Connect Power BI to the cloud-based data storage solution to retrieve the combined data.

D. Create a VPN connection from the Power BI service to the on-premises SQL Server database. Configure the Power BI report to use the VPN connection for data retrieval.

Q27. You have a Power BI report that includes a table visual displaying sales data. The sales data is grouped by region and includes the columns: Region, Salesperson, and SalesAmount. You want to add a calculated column to the table that calculates the percentage of each salesperson‘s sales amount out of the total sales amount for the region. Which DAX formula should you use?

Select 1 option(s):

A. Salesperson Sales Percentage = DIVIDE([SalesAmount], CALCULATE(SUM([SalesAmount]), ALLEXCEPT(Table1, [Region])))

B. Salesperson Sales Percentage = DIVIDE([SalesAmount], SUMX(FILTER(Table1, Table1[Region] = EARLIER(Table1[Region])), [SalesAmount]))

C. Salesperson Sales Percentage = DIVIDE([SalesAmount], SUMX(FILTER(ALL(Table1), Table1[Region] = EARLIER(Table1[Region])), [SalesAmount]))

D. Salesperson Sales Percentage = DIVIDE([SalesAmount], CALCULATE(SUM([SalesAmount]), Table1[Region] = EARLIER(Table1[Region])))

Q28. You have a Power BI report that is experiencing slow performance when loading visuals. The report uses an imported dataset with a large fact table. What should you recommend to improve the performance of the report?

Select 1 option(s):

A. Implement query folding to optimize the data retrieval from the source.

B. Apply filters to reduce the amount of data loaded into the visuals.

C. Create summary tables or aggregates to pre-calculate and optimize the data.

D. Utilize Power BI performance analyzer to identify and optimize slow-performing visuals.

Q29. You have a Microsoft Power BI report that contains a large amount of data and multiple visuals. The report is taking a long time to load and users are experiencing performance issues. What should you do to improve the performance of the report?

Select 1 option(s):

A. Increase the shared capacity of the Power BI workspace.

B. Optimize the DAX calculations and formulas used in the report.

C. Reduce the number of visuals displayed on the report page.

D. Use direct query mode instead of importing the data.

Q30. You have a Power BI report that includes a large dataset with multiple tables. The report is accessed by a large number of users concurrently, and they are experiencing slow performance when interacting with the visuals. What can you do to improve the performance of the report?

Select 1 option(s):

A. Implement query folding in Power Query Editor to optimize data retrieval from the dataset.

B. Enable query caching in the Power BI service to store and reuse query results for faster data access.

C. Optimize the data model by removing unnecessary relationships and calculations to reduce the complexity of the dataset.

D. Enable incremental refresh on the dataset to only load and update the data that has changed since the last refresh.

Q31. You are designing a Power BI report that displays sales data for different regions. The report includes a slicer that allows users to select a specific region. You want to display a visual that shows the sales trend over time for the selected region. Which visualization should you use?

Select 1 option(s):

A. Stacked area chart

B. Scatter plot

C. Line chart

D. Waterfall chart

Q32. How can you ensure that your assets are compliant with industry standards and regulations?

Select 1 option(s):

Use Azure Policy

Use Azure Security Center

Use Azure Compliance Manager

Use Azure Advisor

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

Select 1 option(s):

A. Promote the datasets.

B. Certify the datasets.

C. Feature the dataset on the home page.

D. Publish the datasets in an app.

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

Select 1 option(s):

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.

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

Select 1 option(s):

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.

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

Select 1 option(s):

A. highlight

B. filter

C. no impact

Q37. How can you ensure that your assets are always up-to-date and secure?

Select 1 option(s):

Use Azure Security Center

Use Azure Backup

Use Azure Site Recovery

Use Azure Monitor

Q38. What is the best way to manage workspaces in Power BI?

Select 1 option(s):

A. Create a new workspace for each department

B. Use a single workspace for all departments

C. Use a single workspace for each report

D. Use a single workspace for each user

Q39. 4. How can you create a hierarchy in Power BI?

Select 1 option(s):

By dragging and dropping columns onto the hierarchy pane

By using the drill-down feature

By creating a new column with a hierarchy formula

By using the grouping feature

Q40. What is the difference between structured and unstructured data?

Select 1 option(s):

Structured data has a defined format

Unstructured data has a defined format

Structured data is easy to analyze

Unstructured data is easy to analyze

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

Select 1 option(s):

A. comments

B. chat in Microsoft Teams

C. alerts

D. subscriptions

Q42. How can you create a hierarchy in Power BI?

Select 2 option(s):

Use the Manage Hierarchies dialog box

Use the Query Editor

Use the Data Model view

Use the Visualizations pane

Q43. What is the difference between a dataset and a dataflow in Power BI?

Select 1 option(s):

A dataset is a single table of data, while a dataflow can contain multiple tables

A dataflow is a single table of data, while a dataset can contain multiple tables

A dataset is used for real-time data, while a dataflow is used for historical data

A dataflow is used for real-time data, while a dataset is used for historical data

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

Select 1 option(s):

A. Create a subscription.

B. Create a data alert.

C. Share the dashboard to the user.

D. Tag the user in a comment.

Q45. What is the purpose of a gateway in Power BI?

Select 1 option(s):

To connect on-premises data sources to Power BI

To create visualizations

To share data with other users

To manage data sources

Q46. What is the purpose of a data model in Power BI?

Select 1 option(s):

To organize and structure data for analysis

To visualize data in a report

To create dashboards for end users

To import data from external sources

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

Select 1 option(s):

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.

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

Select 1 option(s):

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.

Q49. How can you create a measure in Power BI?

Select 2 option(s):

Use the Power BI Desktop

Use the Power BI Service

Use the Power BI Mobile App

Use Excel

Q50. You want to show the distribution of customer ratings for a product. Which chart type would be best to use?

Select 1 option(s):

A. Box plot

B. Line chart

C. Pie chart

D. Scatter chart

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

Select 1 option(s):

A. Viewer

B. Admin

C. Contributor

D. Member

Q52. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.You need to create a reference line to show which employees are above the median salary.Solution: You create a constant line and set the value to .5.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

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

Select 1 option(s):

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.

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

Select 1 option(s):

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.

Q55. What is the best way to manage your assets‘ access and permissions?

Select 1 option(s):

Use Azure Active Directory

Use Azure Role-Based Access Control

Use Azure Security Center

Use Azure Policy

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

Select 1 option(s):

A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

B. Change the data type of the Logged column to Date.

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

D. Apply a transformation to extract the first 11 characters of the Logged column.

Q57. In a project, you need to create a data model that can handle multiple languages. Which data type should you use for the language field?

Select 1 option(s):

A. Text

B. Choice

C. Lookup

D. Managed Metadata

Q58. You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:✑ Customer ID✑ Customer Name✑ Phone✑ Email Address✑ Address IDAddress contains the following columns:✑ Address ID✑ Address Line 1✑ Address Line 2✑ City✑ State/Region✑ Country✑ Postal CodeEach Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.What should you do?

Select 1 option(s):

A. Merge the Customer and Address tables.

B. Group the Customer and Address tables by the Address ID column.

C. Transpose the Customer and Address tables.

D. Append the Customer and Address tables.

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

Select 1 option(s):

A. Q&A

B. smart narrative

C. decomposition tree

D. key influencers

Q60. What is the best way to deploy and maintain assets in a hybrid environment?

Select 1 option(s):

Use Azure Resource Manager templates

Use PowerShell scripts

Use Azure CLI

Use Azure Portal

Q61. How can you add a dataset to a workspace in Power BI?

Select 1 option(s):

Import a dataset from a file

Connect to a data source

Create a new dataset

Delete a dataset

Q62. How can you manage data sources in Power BI?

Select 4 option(s):

Add or remove data sources

Edit data source credentials

Refresh data sources

Share data sources with other users

Unattempted

Q63. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have 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?

Select 1 option(s):

A. Yes

B. No

Q64. You are building a Power BI report to analyze customer segments. You need to identify customer 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?

Select 1 option(s):

A. decomposition tree

B. funnel chart

C. Q&A

D. key influencers

Q65. Overview:

You work for a company that uses Power Bl for financial reporting. Analysis and insights for sales are now required.
Existing Environment:
Power Bl service is used and workspaces have been created. Power Bl Desktop is installed.
Data Sources:
Sales data is stored in an Azure SQL database. Dimension data for Territory and Country is held in an Excel workbook in SharePoint Online.
Sales schema – The schema for the sales data is shown in the Schema exhibit. Product Ids are alphanumeric and consist of three letters followed by three numbers. The Sales amount is net of any taxes The Tax rate is 20 percent on all sales.
Territory workbook – The data for territories is shown in the Territory workbook exhibit.
Issues:
You observe the following issues:
The labels for country are not consistent for territories.
The labels used are not the commonly used names in your company.
The labels do not follow naming corporate standards with capitalization, no special characters, and no abbreviations.
Users must be able to analyze sales by product type.
The tax amount on sales must be available in visualizations.
Sales managers are unable to create visualizations for sales grouped by Product type.
Sales managers must only be able to see sales for their territory.
Sales Schema

Territory Workbook

QUESTION
You need to create the relationship to support the Sales Manager’s visualizations.
What should you do before creating the relationship?

Select 1 option(s):

Change the data type of Sales[Productld] to Whole number.

Create a measure for sum of Sales[Amount].

Change the data type of Product[ProductTypeld] to Whole number.

Add a transformation to add a calculated column to extract the numeric value from Product[Productld].