Coursera PL-300 Mock Exam 4

Live connection to the dataset is not supported. You cannot use drill down with anomaly detection. DirectQuery connectivity is not supported.

Anomaly detection is a powerful feature of Power BI where you can detect anomalies within your time series data. Which of the following features are not supported by anomaly detection? Select all that apply. Live connection to the dataset is not supported. You cannot use drill down with anomaly detection. Line charts are not supported. DirectQuery connectivity is not supported.

LASTDATE

Question 22 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 Current Inventory returns only the current total number of inventory items, rather than the sum of all inventory items. What additional DAX function should you include in the query? CALENDARAUTO CALENDAR DISTINCTCOUNT LASTDATE

Dimension tables

Row-level security is commonly applied to which type of tables in Power BI? Lookup tables Dimension tables Data tables Fact tables

Five hundred thousand

The Analyze in Excel feature allows you to summarize data in Excel with a live connection. What is the maximum row limit of summarized data with a live connection? The same as the source dataset. Five hundred thousand Three hundred thousand You cannot analyze data in Excel as summarization with a live connection.

True

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

True

True or False: You can only subscribe to external users to a Power BI report or dashboard if your report or dashboard is hosted in a Premium capacity.

True

True or False: You have a Power BI dashboard where you added a Custom tile. The Tile is taking data from a Live-streaming dataset. Power BI does not allow you to set and manage Alerts on the live-streaming dataset dashboard tiles.

false

True or False: You have imported a Power BI data model from a huge Excel spreadsheet. You need to create aggregations to improve model performance but creating and managing aggregations is limited to DirectQuery sourced datasets.

false

True or False: You have imported a data model to Power BI desktop. You need to create a number of time intelligence calculations using DAX. The data model does not have a dedicated date table. To create the time intelligence measures, the first step is to create a common date table within your data model.

Lineage view

What feature in Power BI service can you use to troubleshoot the flow of data from the source to destination? Quick insights Usage metrics report Query caching Lineage view

Relationships Synonyms Review Questions

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

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 are automatically applied to all referencing queries The referencing queries become read-only. The reference queries do not change. The changes only affect the current report.

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? When you need to print the report in tabular format For ad-hoc queries. When designing for mobile devices. For real-time data analysis.

Both Power BI desktop and Service.

Which Power BI component lets you test the row-level security using different security roles? Power BI service. Both Power BI desktop and Service. Power BI desktop. Power BI mobile app.

USERRELATIONSHIP CROSSFILTER KEEPFILTERS

Which of the following DAX functions can be used as filter modification functions within CALCULATE? Select all that apply. USERRELATIONSHIP FILTERS CROSSFILTER KEEPFILTERS FILTER

The Model view of Power BI desktop. The Power query editor.

Which of the following Power BI components can you use to configure the column and table properties of your data model? Select all that apply. The Model view of Power BI desktop. Advanced editor. The Power query editor. Visualizations pane of Power BI desktop.

Measures are dynamic calculations that do not take space in the data model Measures can reference other measures during calculations.

Which of the following statements about Measures in Power BI is true? Select all that apply. Measures can reference columns directly. Measures are dynamic calculations that do not take space in the data model Measures can reference other measures during calculations. Measures can only be created using DAX in Power BI.

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? Report view Data view Model view Page view

OneDrive for business SharePoint - Team sites

You are planning to get data from flat files for your company. The company wants a scheduled refresh for the dataset by using Microsoft 365 credentials. Which two of the following locations should you recommend? Select all that apply. OneDrive for business SharePoint - Team sites Personal OneDrive account Local file

The number of users and the need for centralized management

You are setting a data gateway for your organization, and you need to decide between a personal and enterprise gateway. What factors influence your decision? Both gateways provide the same features The type of data sources, for example, SQL and SharePoint The number of users and the need for centralized management The physical location of the data centers

Variables improve the overall performance of the resulting DAX measure. Variables improve the overall readability of the resulting DAX measure.

You are working on a complex data model that requires various DAX measures to define a range of business metrics. You decided to use variables while creating DAX formulas. What are the benefits of using variables in DAX expressions over using original expressions? Select all that apply. Variables improve the overall performance of the resulting DAX measure. Variables have additional functions that can be used in the DAX measure. Variables improve the overall readability of the resulting DAX measure. Variables allow users to change the data source connection in the DAX measure.

Use the Select columns command to select the columns to keep.

You connect the Power query editor to a database table. You need to remove the Row ID column. You need to make sure that the new columns do not display in the table model during a scheduled data refresh in the future. What transformation should you use? Select Row ID and use the Remove Other Columns command. Use the Transpose command, then filter the rows to remove Row ID. Use the Remove Column command on the Row ID column. Use the Select columns command to select the columns to keep.

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? 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 Selectively change the background color from the Theme panel

Advanced editor of Power query editor

You developed a query in Power BI desktop that retrieves data from an Excel spreadsheet. During the data analysis, you identify the need to view and modify multiple steps of data transformation in the entire M code. Which Power BI interface allows you to accomplish that? The Model view of Power BI desktop. The Formula bar of the query editor. Advanced editor of Power query editor The Power query editor.

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? None Both Single

You need to display visuals that use different datasets.

You have a Power BI data model from which you need to create reports and dashboards. In which scenario do you need a dashboard for a report in Power BI? You need to add filters. You need to add slicers. You need to display visuals from multiple pages. You need to display visuals that use different datasets.

Using the USERRELATIONSHIP function.

You have a Power BI data model where the fact table is related to the Calendar table via multiple inactive relationships based on OrderDate, DeliveryDate, and ShipDate. How can you use the inactive relationship while defining DAX measures? Using the CROSSFILTER function. Managing the relationship from the Manage relationship window Using the USERRELATIONSHIP function. Using the KEEPFILTERS function.

It creates a separate path for each employee-manager relationship.

You have a Power BI dataset where each employee is reporting to multiple managers in the organizational hierarchy. How does a PATH function of DAX handle such a situation? The PATH function cannot handle multiple reporting relationships. It creates a separate path for each employee-manager relationship. It concatenates all paths for each manager. It chooses the shortest path for each employee.

Calculated tables Measures

You have a Power BI desktop data mode that you need to enhance. Which model items can you add to the model using DAX? Select all that apply. Hierarchies Calculated tables Display folder Measures

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 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]. Set the button type to Bookmark and then use Conditional formatting to specify the destination. Use Conditional formatting to set the Button text.

Modify the data source settings.

You have a Power BI file that imports several tables from Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the Power BI file. The solution must minimize the administrative efforts. What should you do? Create a Power BI file, open the file, and change the data source when prompted. Create new queries from the Power query editor. Modify the data source settings. Modify the source of each query in the Power query editor.

Add a visual for sales breakdown by category on a Tooltip.

You have a Power BI report displaying a Column chart of Sales on the Y-axis and Countries on the X-axis. When users hover the cursor on any data point the tooltip displays the sales values along with the name of the country. How can you display the sales breakdown by each category within the same country? Add a visual for sales breakdown by category on a Tooltip. Add a separate visual displaying sales breakdown by product category. Create a separate report page for each product category. Add a Category slicer where users can select a category.

Each Slicer must use the same column

You have a Power BI report that uses a dataset imported from the database. The report contains a Slicer that you need to sync so that it can be used on other report pages. What is required to sync the slicers between report pages? Each Slicer must have the same title. Each Slicer must use the same column Each Slicer must be visible. Each Slicer must be the same slicer type.

Transpose

You have a dataset representing each month (January, February, March) as individual columns. What transformation in the query editor can you use to rearrange the data, making months appear as rows instead of columns? Reverse rows Pivot Extract Transpose

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? Aggregated metric for employee performance Transactional data about employees Detailed performance review data Descriptive information about employees and departments

True

You have applied changes in the data source structure including renaming, remove, and add columns. True or False: The refresh can only be applied to Power BI desktop.

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

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 show you the impact of user interaction on report elements so you can optimize. The results recommend the data fresh frequency. The results recommend reducing the data size. The results suggest you replace the visual elements.

Append

You have two Excel sheets with data from separate reporting units. Both spreadsheets contain the same column names and structure. What Power query editor feature will you use to create a unified dataset? Group Append Merge Manage

Admin

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

Constant line

You need to add an analytical line to a visual within your report. The value for the line must be equal to the result of a DAX measure that always returns a consistent single value. The DAX measure must only be used to populate the analytics line. Which type of analytics line should you use? Max line Average line Constant line Min line

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 Waterfall chart Card visual A KPI A Scatter plot

Power query editor

You need to create aggregations to improve model performance of a DirectQuery sourced dataset in Power BI. Which Power BI component allows you to create aggregations? Power query editor Power BI desktop model view Power BI desktop table view Power BI desktop report view

Import mode supports the Q&A feature. Import mode supports Quick insights.

You need to decide between DirectQuery mode and Import mode for your dataset's import mode. What are the benefits of Import storage mode versus DirectQuery storage mode? Select all that apply. Import mode has minimal need for data refresh. Import mode supports the Q&A feature. Import mode supports per-table configuration. Import mode supports Quick insights. Import mode minimizes disk space usage.

Waterfall chart

You need to visualize the running total of a company by fulfilling the following criteria. The initial and final value columns must start on the horizontal axis. The intermediate values must be floating columns. Which type of visualization should you choose? Waterfall chart Funnel chart Combo chart Scatter plot

Custom column

You want to add a new column to the Power BI table that categorizes customers as high value if their total sales are above $10,000. Which transformation in the query editor allows you to create such a column without using the DAX expression? Custom column Extract Conditional split Group by

=List.Dates(#date(2021,05,31), 365, #duration(1,0,0,0))

You want to create a date table starting from May 31, 2021, and ending one year later. What M code will you use to create this table? =List.Dates(#date(2021,05,31), 365, #duration(1,0,1,0)) =List.Dates(#date(2021,05,31), 365, #duration(0,0,0,1)) =List.Dates(#date(2021,05,31), 365, #duration(1,0,0,0)) =List.Dates(#date(2021,05,31), 1, #duration(1,0,0,0))

Merge queries

Your Power BI dataset has a table where each row represents a city, and there are columns for the population in different years like Population_2019, Population_2020, and so on. You want to display the data with a single column for the year and another column for the population. What transformation step can you achieve in Power BI? Pivot column Unpivot columns Split columns Merge queries

Power query editor.

Your data model contains a huge dataset that you want to reduce. Which Power BI interface can you use to reduce the data? Data view of Power BI desktop. Advanced editor. Power query editor. Data modeler.

Date

Your data model contains a sales table with an OrderDate column. You want to analyze and visualize the sales data grouped by month. What transformation command of the Power query editor lets you create a month column without using DAX expression? Extract Trim Group By Date

Highlight Filter

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. 1 / 1 point Expand Highlight Drill through Filter