PL-300 Exam – Practice 17

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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

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?

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?

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?

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?

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

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

How can you create a hierarchy in Power BI?

What is the difference between structured and unstructured data?

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?

How can you create a hierarchy in Power BI?

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

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?

What is the purpose of a gateway in Power BI?

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

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?

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?

How can you create a measure in Power BI?

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

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?

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?

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?

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?

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

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?

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?

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?

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?

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

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

How can you manage data sources in Power BI?

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?

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?

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
 

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