Coursera PL-300 Mock Exam 2

False

True or False: Only Power BI administrators can promote content in Power BI service.

True

True or False: Power BI allows you to add visual elements and images to your report tooltip.

True

True or False: You have a Power BI report with a live connection. One of the managers of the company is more comfortable using Excel for analyzing data. Power BI allows you to utilize the Analyze in Excel feature with a live-data connection to export the refreshable data from Power BI to Microsoft Excel.

Highly confidential Confidential Public General Restricted Unrestricted Consumer Protected Personal

You are applying sensitivity labels to your Power BI reports, which of the following are sensitivity labels in Power BI? Select all that apply. Highly confidential Confidential Public General Restricted Unrestricted Consumer Protected Personal Certified

Ribbon chart

You are creating a report to visualize sales by salespersons, trending over months. The visual must clearly show how salespersons are performing against each other and have a ranking for each period. Which visual from Power BI core visualization should you choose? Ribbon chart Treemap Clustered bar chart Scatter plot

Power BI service

A Power BI dashboard needs to be optimized for cellular devices. Which Power BI component can you use to optimize the report for mobile devices? Power BI service Power BI Desktop Power BI report builder Power BI mobile app

Decomposition tree

AI visuals are Power BI components designed to provide advanced analytics and insights by leveraging machine learning models and techniques. You are a sales manager of the company and want to analyze the revenue by region, category, and sales channel. Which of the following AI visuals is used to break down a specific value (revenue in this case) into its components? Q&A visual Waterfall chart Decomposition tree Key influencer visual

A SharePoint folder

For the sales department of your organization, you publish a report that imports data from Microsoft Excel located in a Microsoft SharePoint folder. The data model contains several DAX measures. You must create a Power BI report from the existing data with minimal development efforts. Which type of data source should you use? A Power BI dataset An Excel workbook Power BI dataflows A SharePoint folder

The Power query editor

Which Power BI interface do you need to use to identify the data anomalies present within your imported dataset from an Excel workbook? Advanced editor of Power query editor. The Power query editor The Model view of Power BI desktop. The Data view of Power BI desktop.

Scatter chart

In Power BI you can add symmetry shading along with x- and y-axis Constant lines to which of the following visuals? Scatter chart Area chart Line chart Waterfall chart

Semantic model Reports Dataflows

Which content type can be endorsed in Power BI? Select all that apply. Semantic model Reports Excel workbook Dataflows Live streaming dataset

From the query window, select Column profiling on the entire dataset.

In the Power query editor, the column statistics show a count of 1000 rows, but your query is retrieving data from a data source that contains 5000 rows. What should you do for the column statistics to show the statistics based on entire data rows? Add a Table.Buffer applied step using M in the query. Change the query load from Import to DirectQuery. From the query window, select Column profiling on the entire dataset. Create a Top N row count parameter for the query.

USERPRINCIPALNAME( )

Which function allows you to know the username of the person who is signed into Power BI service? LOOKUPVALUE( ) USEROBJECTID( ) USERPRINCIPALNAME( )

Split column

One of your columns in the data model contains information about the mailing address's city, state, and postal code. You must separate the fields to access the geospatial elements for map visualization. What transformation should you apply? Split column Modify data category Replace values Modify data type

The results show you the impact of user interaction on report elements so you can optimize.

Question 28 You have developed a Power BI report for the sales team of your company. The salespeople are frequently interacting with the report and complain that the report elements are taking too long to display upon each interaction. You have recorded the report performance from the performance analyzer. How do the results assist you in improving the report's performance? The results recommend reducing the data size. The results suggest you replace the visual elements. The results show you the impact of user interaction on report elements so you can optimize. The results recommend the data fresh frequency.

Use of slicers and filters Creation of multiple pages

Question 44 Which of the following features are not supported in Power BI dashboards? Select all that apply. Use of slicers and filters Setup of data Alerts Natural language queries Creation of multiple pages

Both reports and datasets are published to Power BI service.

Question 47 Which of the following statements regarding publishing reports from Power BI desktop to Power BI service is true? Only datasets are published to Power BI service. Both reports and datasets are published to Power BI service. Only reports are published to Power BI service.

Fields Calculations

Which of the following elements can you use to develop a quick measure in Power BI desktop? Select all that apply. Conditional columns Fields Power query M functions DAX Calculations

Power Automate

Which tool should you use to create a custom connector to access data from a third-party API? Power Query Power BI Power Apps Power Automate

Increasing the refresh speed. Reducing the size of data model.

What are the potential performance benefits of removing unnecessary columns from the data model? Select all that apply. Decreasing report page load times. Increasing the refresh speed. Reducing the size of data model. Increasing DAX performance.

Synonyms Review Questions Relationships

What features can you configure in the Q&A feature of Power BI desktop? Select all that apply. Modeling Visual formatting Synonyms Review Questions Relationships

The changes are automatically applied to all referencing queries

What happens when you make changes to the source query of a referenced query in Power BI? The changes only affect the current report. The changes are automatically applied to all referencing queries The reference queries do not change. The referencing queries become read-only.

Use folders to group related datasets.

What is the best way to organize related datasets? Use tags to categorize datasets. Use naming conventions to identify datasets. Use folders to group related datasets. Use a separate workspace for each dataset.

SUM

What is the default summarization of a numerical column in Power BI? SUM Count MIN Average

When you need to print the report in tabular format

When might you choose to use a Paginated report over an interactive report in Power BI? For ad-hoc queries. For real-time data analysis. When you need to print the report in tabular format When designing for mobile devices.

Create a Column chart displaying Date hierarchy on the X-axis and create a Slicer drop-down for salespersons.

You are developing a Power BI desktop report to visualize the sales performance of salespeople. The sales team is comprised of over 20 salespeople. You also need to make sure the sales values are visualized monthly. What should you do? Create a Bar chart displaying the salesperson on the Y-axis. Create a Column chart displaying salespersons on the X-axis and create a Slicer for data hierarchy. Create a Column chart displaying the month on the X-axis. Create a Column chart displaying Date hierarchy on the X-axis and create a Slicer drop-down for salespersons.

Merge the tables using left outer join kind based on the SalesOrderID.

You are importing data from a SQL Server database that contains two tables named SalesOrderDetails (left table) and SalesOrders (right table). You load both tables to Power BI desktop and the tables have a relationship based on theSalesOrderID column. You need to combine two tables into one and you must meet the following requirements: There is a row for every SalesOrderDetails row in the resulting table, even if there is no corresponding SalesOrder row. For every SalesOrderDetails row, the row in the resulting table includes the corresponding SalesOrder row data if the SalesOrder exists. Any SalesOrder row data that does not have a corresponding SalesOrderDetails row is not included in the resulting table. What should you do to combine the tables? Append the tables. Merge the tables using inner join based on the SalesOrderID. Merge the tables using full outer join kind based on the SalesOrderID. Merge the tables using left outer join kind based on the SalesOrderID.

Model view

You are importing your Power BI project data from a SQL Server database. Which Power BI desktop view can you use to change the storage mode of the tables? Model view Report view Page view Data view

CALCULATE

You are working on a Power BI data model that contains three data tables. A Sales table containing sales transactions, a Date table, and a Product table. You want to create a summary table to display the following: The total sales by each product category per year. Total quantity of each product within the category. You have created the following DAX measure: Annual Sales Summary = ADDCOLUMNS ( SUMMARIZE ( Sales, Date.[Year], 'Product'[Category] ), "Total Quantity", SUM ( Sales[Quantity] ) ) ) Which of the following DAX functions you should include in the DAX expression to compute accurate results? CALCULATETABLE FILTER TOPN CALCULATE

Change the background color with Conditional formatting

You developed a Table visual in a Power BI report and you want to highlight the valuable information about the profit margin in one of the columns of the table. You are asked to change the background color of the column displaying the red color if the profit margin is below a certain limit. How can you achieve this with minimal developmental efforts? Selectively change the background color from the Theme panel Define DAX measures for various colors to display in the Table visual Change the background color with Conditional formatting Format the background color from the Format visual of Power BI desktop

Change the data type of the logged column to Date.

You have a CSV file that contains user complaints. The table contains a column called Logged, which has data and the time of each complaint. The data is logged in the following format: 2022-12-21 at 08:35. You want to analyze the complaints by the logged date and utilize Power BI's built-in date hierarchy. What should you do? Apply transformation to extract the column's first characters that only contain the date. Change the data type of the logged column to Date. Split the logged column using 'at' as a delimiter. You can use the same column as the date hierarchy.

Single

You have a Power BI data model containing two tables Sales and Employees. The tables are related via a one-to-many relationship based on the EmployeeID column. You want to analyze the sales performance for each employee. Which cross-filter direction will you choose? Single Both None

Data is refreshed from the data source Queries used to populate visuals are refreshed

You have a Power BI data model that imports data from an on-premises SQL Server. You have implemented a scheduled refresh of the dataset. What happens to the Power BI report after each scheduled refresh? Select all that apply. Data is refreshed from the data source Queries used to populate visuals are refreshed Report visuals are refreshed Schema refresh that is change in data source table structure is shown Query caches are refreshed

Utilize the PATH DAX function to handle the organizational hierarchy.

You have a Power BI dataset where each employee is reporting to multiple managers in the organizational hierarchy. How can you handle such a situation? Utilize the PATH DAX function to handle the organizational hierarchy. Utilize the PATHLENGTH DAX function to handle the organizational hierarchy. Implement only the most important employee-manager relationship in your report. Create a separate report for each employee-manager relationship.

Set the Button type to page navigation and then use Conditional formatting to specify the destination. Create a DAX measure that outputs the correct page name based on the value of [Delayed response]. Use Conditional formatting to set the Button text.

You have a Power BI desktop report containing three pages: Main, Delayed Response, and On-time Response. You have added a Button to the Main page for navigation. You need to implement a solution that meets the following criteria: The navigation destination must change based on the output of a DAX measure name [Delayed Response]. If [Delayed Response] is greater than 5%, the Button must display the text "Delayed Response" and navigate to the Delayed Response page. Otherwise, the Button displays the text "On-time Response" and navigates to the On-time Response page. What actions should you perform? Select all that apply. Set the button type to Bookmark and then use Conditional formatting to specify the destination. Set the Button type to page navigation and then use Conditional formatting to specify the destination. Create a DAX measure that outputs the correct page name based on the value of [Delayed response]. Use Conditional formatting to set the Button text.

End users can change the aggregation type of implicit measures from the Values well of the visual.

You have a Power BI model where you need to decide when to use implicit measures over explicit measures. What is the feature of implicit measures that explicit measures do not have? Implicit measures can be used with Field parameters. Implicit measures can be used to create Quick measures. Implicit measures can be used as a drill-through field. End users can change the aggregation type of implicit measures from the Values well of the visual.

Dual

You have a Power BI model with the following fact tables and corresponding storage modes: FactStoreSales (Import mode) FactInternetSales (DirectQuery mode) The model contains a dimension table named DimDate that has a relationship to both fact tables of the data model. To combine data from the dimension table and the fact tables by minimizing the query execution time, which storage mode should you choose for the DimDate dimension table? Dual None Import DirectQuery

DATESBETWEEN DATESINPERIOD

You have a hospital emergency Power BI data model, and you want to know the emergency visits for the last 30 days. Which of the two DAX functions can you use to compute this measure? Select all that apply. SAMEPERIODLASTMONTH TOTALYTD DATESBETWEEN DATESINPERIOD

LASTNONBLANK

You have a warehouse Power BI data model that contains a table named Warehouse. The table has a column named Inventory count, which contains the current number of items for each row of a particular product type on a given day. The model has a DAX measure that calculates the sum of all values in the Inventory count column of the Warehouse table: Current Inventory = CALCULATE ( SUM ( 'Warehouse'[Inventory Count] ) ) You must ensure that the Current Inventory returns only the current total number of inventory items, rather than the sum of all inventory items. You also need to make sure the state holidays and weekends should be excluded from the calculation. What additional DAX function should you include in the query? LASTNONBLANK CALENDARAUTO LASTDATE DISTINCTCOUNT

Power query editor

You have accessed the data from a SQL Server as DirectQuery. The dataset contains millions of rows. The objective of the analysis is to group data by year and region. Creating aggregated tables has the capacity to reduce the dataset sourced through DirectQuery. Which Power BI element allows you to create aggregations? Power query editor Page view of Power BI desktop Model view of Power BI desktop Data view of Power BI desktop

Descriptive information about employees and departments

You have an HR Power BI data model containing a fact table with information about employee performance reviews and dimension tables for employees and departments. What type of data is likely stored in the dimension tables? Transactional data about employees Aggregated metric for employee performance Detailed performance review data Descriptive information about employees and departments

As a filter in the Filters on this Page well of the Filters pane. As an item in the Fields well of a slicer.

You have created a data model in Power BI desktop that contains DAX-calculated columns and measures. You want to create a report from the model. Where can you use DAX-calculated columns, without being able to use measures? Select all that apply. As a filter in the Filters on this Page well of the Filters pane. As a filter in the Filters on this visual well of the Filters pane. As an item in the Add drill-through fields here well of the Visualization pane. As an item in the Fields well of a slicer.

Modify the data model by adding an index column.

You have developed a query named Customers in Power BI desktop to append the rows from three external tables having customer data into a single customer table. You want to ensure each row in the new customer table has a unique ID value. What is the best way to add an ID column to the customer table? Change the data model by extending the Customers table with a counter column. Modify the data model by adding a counter column. Modify the data model by adding an index column. Change the data model by extending the Customers table with an index column.

Set the storage mode property of tables to DirectQuery.

You have imported a large data model to Power BI desktop, and you want to reduce the model size. Which technique should you use to reduce the model size? Set the storage mode property of tables to import. Configure the Query reduction option filter settings. Configure the Query reduction option Slicer settings. Set the storage mode property of tables to DirectQuery.

Contributor

You manage a Power BI workspace. You need to delegate the task to schedule data refreshes. The solution must use the principle of least privilege. Which role should you use? Viewer Contributor Admin Member

A Scatter plot

You need to create a Power BI report visualizing the sales data of a company so that customers of similar age will be grouped together. Which type of visual should you use from the visualization pane of Power BI desktop? A Scatter plot Card visual A KPI A Waterfall chart

Use CALENDAR with MIN and MAX to specify the dates.

You want to create a common date table within your Power BI data model. The start and end of the date table must match the date range available in the fact table of the data model. How can you create this table? Use the CALENDAR function and specify the dates. Use CALENDARAUTO and specify the dates. Use CALENDAR with MIN and MAX to specify the dates. Use CALENDARAUTO with MIN and MAX to specify the dates.

Disable Make this relationship active for both relationships.

Your Power BI data model has a Sales fact table and a Date table. The Sales table contains two date columns: ShipDate and OrderDate. Both date columns have a relationship to the Date column in the Date table, and DAX measures have been defined to use these relationships for calculations related to order date or ship date. You need to make sure that the Date table does not filter the Sales table unless it is using DAX measures that use these relationships. What should you do? Enable Make this relationship active for both relationships. Disable Make this relationship active for both relationships. Enable a security filter in both directions for both relationships. Set the cross-filter direction to Both for both relationships.

An on-premises data gateway

Your company has a SharePoint server located in a data center in Toronto. You are creating a report in Power BI service that uses Microsoft Excel files stored on the SharePoint server. You need to recommend a solution to ensure that the dataset for the report can automatically refresh daily. What should you include in the recommendation? A virtual private network (VPN) Azure Data box An on-premises data gateway

Filter Highlight

Your task is to edit a Power BI report by adjusting the behavior of report interactions. What type of interaction behavior can you change between visuals? Select all that apply. Drill through Filter Highlight Expand