Coursera PL-300 Mock Exam 3

Ace your homework & exams now with Quizwiz!

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? Power BI dataflows An Excel workbook A Power BI dataset A SharePoint folder

Incremental refresh

Which Power BI refresh options require you to set parameters? On-demand refresh Incremental refresh Scheduled refresh

Measures are dynamic calculations and are not stored in the data model.

A Power BI data model has measures and calculated columns. What is the benefit of using measures over calculated columns? Measures can be used in the calculated columns to create complex calculations. Measures can be used for data transformation operations. Measures are dynamic calculations and are not stored in the data model. Measures can assist in data load operations.

Selection pane from Power BI desktop.

A fundamental principle of data storytelling is a cohesive report page and visuals should be placed in a logical order. Which Power BI element allows you to visualize the order of visuals in the report page and configure them according to the narrative of your data story? Page navigator from Power BI desktop. Visualizations pane of Power BI desktop. Selection pane from the query editor. Selection pane from Power BI desktop.

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? Key influencer visual Q&A visual Decomposition tree Waterfall chart

Column quality

For a query append in the query editor, you want to know the percentage of empty cells in each column. Which of the data preview options should you select? Column distribution Column profile Column quality Show whitespaces

USERPRINCIPALNAME( )

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

Using data profiling tools

How can you ensure data accuracy before analysis? Use data modeling tools Using data profiling tools Use data visualization tools Use data transformation tools

Select all visuals to be grouped, navigate to the Format ribbon, and select Group. Select all visuals to be grouped, right-click on any visual, and select Group from the context menu.

How can you group layers of visual elements in your Power BI desktop report? Select all that apply. 0 / 1 point Right-click on any visual and select Group from the context menu Select all visuals to be grouped, navigate to the Format ribbon, and select Group. Select all visuals to be grouped, right-click on any visual, and select Group from the context menu. Drag and drop the visual elements.

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? Change the query load from Import to DirectQuery. Create a Top N row count parameter for the query. Add a Table.Buffer applied step using M in the query. From the query window, select Column profiling on the entire dataset.

Alt

Power BI desktop supports many accessibility tools. Which keyboard keys let you access the accessibility features? Tab + A Alt Tab Alt + A

Both categorical and numerical data fields can be used

Question 35 In Power BI desktop, what types of fields can you use to create a data hierarchy enabling users to drill down to granular details of analysis? Only numerical values Hierarchies can only be created with Data/time data fields Both categorical and numerical data fields can be used Only text-based data

Power BI service

Question 39 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 mobile app Power BI service Power BI report builder Power BI Desktop

Dataflows Paginated reports

Sensitivity labels are a way to classify critical content and protect your sensitive data without losing productivity. Which of the following components can you apply Sensitivity labels to in Power BI Service? Select all that apply: Dataflows Workbooks Paginated reports Semantic models (Datasets)

To retrieve data from data sources To create custom visualizations To perform complex data transformations

What are the ways you can use Python in Power BI? Select all that apply. To retrieve data from data sources to perform report optimization To create a functional data model To create custom visualizations To perform complex data transformations

Lineage view

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

Relationships Synonyms Review Questions

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

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. 1 / 1 point The Model view of Power BI desktop. The Power query editor. Visualizations pane of Power BI desktop. Advanced editor.

Calculations Fields

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

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 are dynamic calculations that do not take space in the data model Measures can reference columns directly. Measures can only be created using DAX in Power BI. Measures can reference other measures during calculations.

Reference queries allow you to reuse query logic and transformation.

Which statement is true about reference queries in Power BI? Reference queries allow you to reuse query logic and transformation. Reference queries allow you to integrate data efficiently. Reference queries enable faster data load. Reference queries allow you to combine tables with similar structures.

Date/time Numeric

You are analyzing the sales of your company in a Power BI desktop report. You need to identify the types of data you will be able to use to create Bins that group sales data. Which Data types should you identify? Select all that apply. Text Binary Date/time Numeric Boolean

Personal Confidential Highly confidential

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

False

You are creating and managing dataflows for your organization. The company's data is hosted in on-premises SQL Server. True or False: To create the dataflows, you do not need to install and configure data gateways.

Dimension table

You are designing a data model for hospital emergency visits. You want to capture patient information like name, address, insurance details, email, and phone number. Which type of table should you store this information? Look up table Fact table Dimension table Measure table

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 Column chart displaying salespersons on the X-axis and create a Slicer for data hierarchy. Create a Column chart displaying Date hierarchy on the X-axis and create a Slicer drop-down for salespersons. Create a Column chart displaying the month on the X-axis. Create a Bar chart displaying the salesperson on the Y-axis.

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 SalesOrderDetailsrow is not included in the resulting table. What should you do to combine the tables? Merge the tables using inner join based on the SalesOrderID. Append the tables. Merge the tables using left outer join kind based on the SalesOrderID. Merge the tables using full outer join kind based on the SalesOrderID.

Scatter plot

You are planning to create a report in Power BI desktop to visualize the relationship between the number of orders received and the number of orders shipped by product category. You must identify the visual that will clearly identify the outliers in the dataset by displaying them away from the cluster of data. Which visual should you choose? Scatter plot Treemap Card Gauge

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? 1 / 1 point FILTER CALCULATE CALCULATETABLE TOPN

Add a Button to clear all the Slicers

You are working on a Power BI report that contains multiple Slicers. A new user of the report might not be able to visualize the entire data because of the active selection of Slicers. What should you do to enhance the user experience? Add a Bookmark Duplicate the report page and remove the Slicers from the duplicated page Add a Button to clear all the Slicers

Create aggregations based on DirectQuerysourced tables. Reduce the data volume by importing only necessary columns. Connect Power BI via DirectQuery mode.

You are working on an on-premises SQL Server dataset to develop a real-time analytical solution. In addition to providing real-time analysis, you need to optimize the query performance. What actions should you take to optimize the query performance? Select all that apply. Query the original data source for all analytical requirements Import the data to Power BI memory. Create aggregations based on DirectQuerysourced tables. Reduce the data volume by importing only necessary columns. Connect Power BI via DirectQuery mode.

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? Format the background color from the Format visual of Power BI desktop 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

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 slicers. You need to add filters. You need to display visuals that use different datasets. You need to display visuals from multiple pages.

Set up a Both cross-filter direction between the Product and Sales tables. Set up a many-to-many relationship between the Date and the Sales tables.

You have a Power BI data model that contains three data tables: Sales, Products, and Date. Both the Product and Date table are related to the Sales table via one-to-many relationships. You want to analyze products sold by year. What should you do to analyze annual product sales? Select all that apply. Use USERRELATIONSHIP to handle the cross-filter direction. Set up a Both cross-filter direction between the Product and Sales tables. Set up a many-to-many relationship between the Date and the Sales tables. Set up a many-to-many relationship between the Product and the Sales tables. Set up cross filter direction to Both between Date and Sales tables.

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 new queries from the Power query editor. Modify the source of each query in the Power query editor. Modify the data source settings. Create a Power BI file, open the file, and change the data source when prompted.

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? None Dual DirectQuery Import

The Analyze feature cannot be used for the first data point of the visual.

You have a Waterfall chart showing the increase and decrease of Sales by States in Power BI report in Power BI service and want to analyze the data using the Analyze feature of Power BI. You selected the first data point of the Waterfall chart and the Analyze option is not available in the context menu. What could be the probable reason? The Analyze feature cannot be used for the first data point of the visual. The Analyze feature can only be used in Power BI desktop. The Waterfall chart does not support the Analyze feature.

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? Transpose Reverse rows Pivot Extract

DATESINPERIOD DATESBETWEEN

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 DATESINPERIOD DATESBETWEEN

LASTDATE

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? DISTINCTCOUNT LASTDATE CALENDAR CALENDARAUTO

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? Data view of Power BI desktop Power query editor Model view of Power BI desktop Page view of 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 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 reducing the data size. The results recommend the data fresh frequency.

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? 1 / 1 point Contributor Viewer Member Admin

SharePoint

You need to create a data source that can be used offline. Which type of data source should you use? Common data services SQL Server SharePoint Microsoft OneDrive

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 BI desktop table view Power BI desktop model view Power query editor Power BI desktop report view

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

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 supports per-table configuration. Import mode supports Quick insights. Import mode minimizes disk space usage. Import mode has minimal need for data refresh. Import mode supports the Q&A feature.

KPI Gauge Card visual

You want to create Alerts to notify users if the data on the dashboard changes above or below a certain threshold. Which Power BI visual allows you to set and manage Alerts in Power BI service? Select all that apply: KPI Gauge Custom visuals Card visual Python visual

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 CALENDAR with MIN and MAX to specify the dates. Use CALENDARAUTO and specify the dates. Use CALENDARAUTO with MIN and MAX to specify the dates.

Left inner join

You want to merge two queries in the Power query editor where you want to keep the entire data from the first table while only matching rows from the second table. Which type of join should you choose? Right outer join Left outer join Right inner join Left inner join

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? 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. Enable Make this relationship active for both relationships.


Related study sets

EMT Chapters 24, 25, 26, 27, 29, 30, 31, 32

View Set

Ch.5 - Earthquake's and Earth's Interior

View Set

Cross-Cultural Issues - Identity Development Models

View Set

FS HN 367 (Medical Terminology) Final Study Guide

View Set

Chapter 2: Introduction to the C Language

View Set

Myers' Psychology for the AP® Course, 3E, Module 82

View Set