PL 300

Ace your homework & exams now with Quizwiz!

You are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data in State is shown in the following exhibit: Valid: 96%, Error: 0%, Empty 4%, 69 distinct, 4 unique. How many non-null values that occur only once in State? 4, 65, 69, 73

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.You need to create a Power BI report that connects to the project management app.Which connector should you select?

Dataverse

You attempt to use Power Query Editor to create a custom column and receive the error message shown in the following exhibit: Expression.Error: We cannot apply operator & to types Text and Number. Details: Operator=& Left=A Right=1Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.NOTE: Each correct selection is worth one point. The error is caused by: error values in the source data, mismatched data types, Null values

Mismatched data types

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

Split the Logged column by using at as the delimiter

You have a table that contains the following three columns:City -✑ Total Sales✑ OccupationYou need to create a key influencers visualization as shown in the exhibit. How should you configure the visualization? What influences Total Sales to Increase, when occupation is professional, the average of Total sales increases by 3.41K To answer, select the appropriate options in the answer area. Analyze [City, Occupation, Total Sales], Explain by [City, Occupation, Total Sales]

Total Sales, Occupation

You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit: Table with Month values and sales data for column year 2020 and 2021. You need to shape the query to display the following three columns:• Month• Sales• Year. What should you select in Power Query Editor? A. Merge columns B. Transpose C. Unpivot columns D. Pivot column

Unpivot columns

You have a Microsoft Excel file in a Microsoft OneDrive folder.The file must be imported to a Power BI dataset.You need to ensure that the dataset can be refreshed in powerbi.com.Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. A. Excel Workbook B. Text/CSV C. Folder D. SharePoint folder E. Web

Web or SharePoint folder

You have the Azure SQL databases shown in the following table: Name (dev, uat, prod), Stage, Server URL. You plan to build a single PBIX file to meet the following requirements:• Data must be consumed from the database that corresponds to each stage of the development lifecycle.• Power BI deployment pipelines must NOT be used.• The solution must minimize administrative effort. How many Parameters should you create? 1, 2, or 3 and What should the Parameter Type be? Text, True/False, or Decimal Number

1 or Text

You are using Power BI Desktop to connect to an Azure SQL database. The connection is shown as SQL Server database where the server and database is entered, Import mode is selected, and relationship columns are included. What is the default timeout for the connection from Power BI Desktop to the database. Unlimited, one minute, or 10 minutes?

10 minutes

You need to create a Power BI report. The first page of the report must contain the following two views:✑ Sales By Postal Code✑ Sales by MonthBoth views must display a slicer to select a value for a field named Chain.The Sales By Postal Code view must display a map visual as shown in the following exhibit. Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views.What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Minimum number of bookmarks [1, 2, 3, 4], Property: [Data, Display, Current Page]

2, Display

You are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data in State is shown in the following exhibit: Valid: 96%, Error: 0%, Empty 4%, 69 distinct, 4 unique. How many different values are there in Sate including nulls? 4, 65, 69, 73

You have a Power BI visual that uses indicators to show values that are out of range as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. The visual type is [a line, a line and clustered column, an area] chart. The visual indicators that show values out of range are created by using [a custom visual, a trendline, anomaly detection, line chart markers]

A line chart, anomaly detection

You have a Microsoft SharePoint Online site that contains several document libraries.One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.What should you do? A. Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library. B. Get data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library. C. Get data from a SharePoint folder, enter the site URL, and then select Combine & Load. D. Get data from a SharePoint list, enter the site URL, and then select Combine & Load.

A. Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library.

You attempt to use Power Query Editor to create a custom column and receive the error message shown in the following exhibit: Expression.Error: We cannot apply operator & to types Text and Number. Details: Operator=& Left=A Right=1Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.NOTE: Each correct selection is worth one point. The desired outcome of the custom column is: 1A, A&1, A1

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

Add a column chart, a bookmark, and a button for users to choose a visual

You plan to create the chart shown in the following exhibit. Sales including Percentile line chart. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown? A. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.INC (Sales,sales[Total Sales],0.40) B. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.EXC (Sales,sales[Total Sales],0.40) C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile. D. Create a horizontal line that has a fixed value of 24,000.

Add a new percentile line that uses Total Sales as the measure and 40% as the percentile

You have the visual shown in the exhibit. (Click the Exhibit tab.) Sales Amount vs Unit Price Over Years by Country - Scatter ChartYou need to show the relationship between Total Cost and Total Sales over time.What should you do? A. Add a play axis. B. From the Analytics pane, add an Average line. C. Add a slicer for the year. D. Create a DAX measure that calculates year-over-year growth.

Add a play axis

You have a line chart that shows the number of employees in a department over time.You need to see the total salary costs of the employees when you hover over a data point.What should you do? A. Add salary to the drillthrough fields. B. Add salary to the visual filters. C. Add salary to the tooltips.

Add salary to the tooltips

You have a report that contains three pages. One of the pages contains a KPI visualization.You need to filter all the visualizations in the report except for the KPI visualization.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. A. Edit the interactions of the KPI visualization. B. Add the same slicer to each page and configure Sync slicers. C. Edit the interactions of the slicer that is on the same page as the KPI visualization. D. Configure a page-level filter. E. Configure a report-level filter.

Add the same slicer to each page and configure Sync slicers, Edit the interactions of the slicer that is on the same page as the KPI visualization

You are using Power BI Desktop to connect to an Azure SQL database. The connection is shown as SQL Server database where the server and database is entered, Import mode is selected, and relationship columns are included. The navigator will display? All the tables, only the tables that contain data, only tables that contain hierarchies

All the tables

You are creating a line chart in a Power BI report as shown in the following exhibit.Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. The dashed line representing the Year Average Employee Count was created by using [a trend line, a secondary axis, an average reference line, two measures in the Values bucket] To enable users to drill down to weeks or days, add the Weeks and Days field to the [axis, values, legend, secondary values] bucket

An average reference line, Axis

You have two Azure SQL databases that contain the same tables and columns.For each database, you create a query that retrieves data from a table named Customer.You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.What should you do to combine the Customer tables? Append Queries, Append Queries as New, Merge Queries, or Merge Queries as New

Append Queries as New (so that you can disable the old queries)

You need to create a visual as shown in the following exhibit: Table with MonthName, Total Sales w/ selected values highlighted in green red yellow, Sales Last Year, and % Growth to Last Year. The indicator color for Total Sales will be based on % Growth to Last Year. The solution must use the existing calculations only. How should you configure the visual? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Conditional formatting: [Background color, Data bars, Font color, Icons, Web URL] Format by: [Color scale, Field value, Rules]

Background color, Rules

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales.You need to create a measure that calculates the total sales from the equivalent month of the previous year.How should you complete the calculation? To answer, select the appropriate options in the answer area. Sales Previous Year = (Calculate, Evalulate, Sum, SumX)[Total Sales], (DATESMTDm PARALLELPERIOD, SAMEPERIODLASTYEAR, TOTALMTD), [Date], 'Date'[Date], 'Date'[Month]

CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Month]))

You publish a dataset that contains data from an on-premises Microsoft SQL Server database.The dataset must be refreshed daily.You need to ensure that the Power BI service can connect to the database and refresh the dataset.Which four actions should you perform in sequence? Add the dataset owner to the data source, Configure and on-premises data gateway, configure a virtual network data gateway, add a data source, configure a scheduled refresh

Configure an on-premises data gateway, add a data source, add the dataset owner to the data source, configure a scheduled refresh

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

Create a new group on the state column and set the Group type to List

You have the Power BI model shown in the following exhibit.: Country and Calendar tables with relationship to Purchase table. Purchase table has relationship to Purchase Detail. A manager can represent only a single country. You need to use row-level security (RLS) to meet the following requirements:✑ The managers must only see the data of their respective country.✑ The number of RLS roles must be minimized. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function. B. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function. C. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions. D. Create one role for each country. E. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function, For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

You have a Power BI imported dataset that contains the data model shown in the following exhibit: Star schema model. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. Changing the _____ setting of the relationships will improve report query performance. (Cardinality, Cross filter direction, Assume Referential Integrity). The data model is organized into a: Star schema, snowflake schema, denormalized table

Cross filter direction, star schema

You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.You add the following fields to the Explain By field:✑ Customer Country✑ Product Category✑ Supplier Country✑ Sales Employee✑ Supplier Name✑ Product Name✑ Customer CityThe key influencers visual returns the results shown in the following exhibit. What influences Quantity Per Order to Increase? When Customer City is Cunewald, Grax, Buise, Austria Average of Quantity per Order increases by 22.39, 22.21, 20.37, 18.8 What can you identify from the visual? A. Customers in Austria order 18.8 more units than the average order quantity. Most Voted B. Customers in Boise order 20.37 percent more than the average order quantity. C. Product Category positively influences the quantity per order. D. Customers in Cork order lower quantities than average.

Customers in Austria order 18.8 more units than the average order quantity

You maintain a Power BI workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)You need to modify the dashboard mobile layout to meet the following requirements:✑ Only show single-value visuals.✑ Minimize scrolling.What should you do? A. Decrease the size of the card visuals. Remove the map and bar chart visuals. B. Decrease the size of the map and bar chart visuals. Move all the card visuals to the top of the layout. C. Remove the card visuals. Increase the size of the map and bar chart visuals. D. Move the bar chart visuals to the top of the layout. Remove the map visuals. Decrease the size of the card visuals.

Decrease the size of the card visuals. Remove the map and bar chart visuals

You are creating a query to be used as a Country dimension in a star schema.A snapshot of the source data is shown in the following table: Table with Country column (duplicate values) and City column. You need to create the dimension. The dimension must contain a list of unique countries.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. A. Delete the Country column. B. Remove duplicates from the table. C. Remove duplicates from the City column. D. Delete the City column. E. Remove duplicates from the Country column.

Delete the City column and Remove the duplicates from the Country column

Data has the following refresh requirements: Customer must be refreshed daily, date must be refreshed once every three years, sales must be refreshed in near real time, and sales aggregate must be refreshed once per week. You must minimize the load times of visuals and ensure the data is loaded to the model based on the refresh requirements. There are relationships between Date and Sales, Customer and Sales, SalesAggregate and Customer, and Date and SalesAggregate. Which storage mode should you use for Sales?

DirectQuery

You have two Azure SQL databases that contain the same tables and columns.For each database, you create a query that retrieves data from a table named Customer.You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.What should you do to the original two SQL database queries? Delete the queries, disable including the query in report refresh, desable loading the query to the data model, duplicate the queries

Disable loading the query into the data model

You have two CSV files named Products and Categories.The Products file contains the following columns:✑ ProductID✑ ProductName✑ SupplierID✑ CategoryIDThe Categories file contains the following columns:✑ CategoryID✑ CategoryName✑ CategoryDescriptionFrom Power BI Desktop, you import the files into Power Query Editor.You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:✑ ProductID✑ ProductName✑ SupplierID✑ CategoryID✑ CategoryName✑ CategoryDescription. what should you do on the Categories query? Delete the query, disable the query load, or Exclude the query from report refresh

Disable the query load

You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:• Order Line ID• Product ID• Unit Price• Order ID• QuantityOrders are uniquely identified by using the order ID and can have multiple order lines. Each order line within an order contains a different product ID.You need to write a DAX measure that counts the number of orders.Which formula should you use? A. Count('Sales'[Order ID]) B. CountA('Sales' [Order ID]) C. CountRows('Sales') D. DistinctCount('Sales' [Order ID])

DistinctCount('Sales' [Order ID])

Dual

You have a Power BI report.You have a table named Data1 that contains 10 million rows.Data1 is used in the following visuals:✑ A card that shows the number of records✑ A bar chart that shows total transaction amount by territory✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territoryYou need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals.What should you do? A. Add a count field of the transaction amount to the size bucket of the scatter plot. B. Add a trend line to the scatter plot. C. Enable high-density sampling on the scatter plot. D. Apply a row filter to the Data1 query in Power Query Editor.

Enable high-density sampling on the scatter plot

You have a Power BI dashboard named DashboardA that contains a tile named TileA. TileA contains a treemap visual from a report named ReportA.You need to provide the users of DashboardA with additional tiles that relate to the contents of TileA.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. From Focus mode, pin the relevant visuals to DashboardA From Focus mode, review the generated visuals From DashboardA, select the TileA options and then select View Insights From ReportA, select the treemap visual options and then select Spotlight From ReportA, select Get Insights From DashboardA, select TileA to open ReportA

From DashboardA, select the TileA options and select View Insights, From Focus mode, review the generated visuals, From Focus mode, pin the relevant visuals to DashboardA

You have a Microsoft Excel spreadsheet named Excel1 that contains survey results.You have a Power BI dashboard named DashboardA that has Q&A enabled.You need to ensure that users who can access DashboardA can ask questions based on the contents of Excel1 and pin visuals based on their queries toDashboardA. The solution must minimize development time.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. From poiwerbi.com pin a range from Excel1 to DashboardA From Excel, format the data in Excel1 as a table From powerbi.com import Excel1 as a dataset From powerbi.com add a tile for the Excel1 dataset to DashboardA From Excel, create a named range by using the data in Excel1 From powerbi.com, upload Excel1

From Excel, format the data in Excel1 as a table, From powerbi.com, upload Excel1, From powerbi.com, pin a range from Excel1 to DashboardA

You have a folder that contains 100 CSV files.You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of the CSV files.Which three actions should you perform in sequence. To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. From Power BI Desktop, select Get Data and then select Folder. From Power Query Editor, expand the Attributes column, From Power Query Editor, remove the Content column. From Power Query Editor, remove the Content column. From Power Query Editor, remove the Attributes column. From Power BI Desktop, select Get Data, and then select Text/CSV, From Power Query Editor, combine the Content Column

From Power BI Desktop, select Get Data and then select Folder, From Power Query Editor, remove the Content column, From Power Query Editor, expand the Attributes column

You are creating a report in Power BI Desktop.You load a data extract that includes a free text field named coll.You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.What should you do? A. In the report, add a DAX calculated column that calculates the length of col1 B. In the report, add a DAX function that calculates the average length of col1 C. From Power Query Editor, add a column that calculates the length of col1 D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

From Power Query Editor, change the distribution for the Column profile to group by length for col1

You are building a Power BI report that uses data from an Azure SQL database named erp1. You import the following tables. You need to perform the following analyses:✑ Orders sold over time that include a measure of the total order value. Orders by attributes of products sold. The solution must minimize update times when interacting with visuals in the report. What should you do first? A. From Power Query, merge the Order Line Items query and the Products query. B. Create a calculated column that adds a list of product categories to the Orders table by using a DAX function. C. Calculate the count of orders per product by using a DAX function. D. From Power Query, merge the Orders query and the Order Line Items query.

From Power Query, merge the Orders query and the Order Line Items query

A user creates a Power BI report named ReportA that uses a custom theme.You create a dashboard named DashboardA.You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. A. Publish ReportA to Power BI. B. From ReportA save the current theme. C. Publish ReportA to the Microsoft Power BI Community theme gallery. D. From DashboardA, create a custom theme. E. From DashboardA, upload a JSON theme.

From ReportA save the current theme, From DashboardA, upload a JSON theme

You are creating a Power BI model in Power BI Desktop.You need to create a calculated table named Numbers that will contain all the integers from -100 to 100.How should you complete the DAX calculation? Numbers = [GENERATE, GENERATEALL, GENERATESERIES][(100, 1, 200), (-100, 100, 1), (-1, -100, 100)]

GENERATESERIES(-100, 100, 1)

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? A. highlight B. filter C. no impact

Highlight

You create a Power BI dataset that contains the table shown in the following exhibit: Business Unit Table - Cost Center, Headcount, ID, Name. You need to make the table available as an organizational data type in Microsoft Excel.How should you configure Key Column? Cost Center, Headcount, ID, Name

Import

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1: Products - abc, def, ghi, jkl, mno. Sheet2 contains the following table named Table2: Products - abc, xyz, tuv, mno, pqr, stu. You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values: Products - abc, xyz, tub, mno, pqr, stu, def, ghi, jkl. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Actions: From Power Query Editor, remove erros from the table. From Power Query Editor, select Table1 and the select Remove duplicates. From Power Query Editor, merge Table1 and Table2. From Power BI Desktop, import the data from Excel and select Table1 and Table2. From Power Query Editor, append Table2 to Table1

Import the data from Excel and select Table1 and Table2, From Power Query Editor, Append Table 2 to Table1, From Power Query Editor, select Table1 and then select Remove duplicates

You plan to create a report that will display sales data from the last year for multiple regions.You need to restrict access to individual rows of the data on a per region-basis by using roles.Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Publish the report, assign users to the role, add a filter to the report, create a role definition, Import the data into Power BI Desktop

Import the data into Power BI Desktop, Create a Role Definition, Publish the Report, Assign users to the role

You are building a Power BI report.Users will view the report by using their mobile device.You need to configure the report to display data based on each user's location.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. A. From Power Query Editor, detect the data types of the relevant columns. B. In Data Category, set the geographic data category for the relevant columns. C. Create a hierarchy for columns of the geography data type. D. Use the columns of the geography data type in all visuals. E. For the relevant columns, set synonyms to match common geographical terms.

In Data Category, set the geographic data category for the relevant columns, Use the columns of the geography data type in all visuals

You have a Power BI report. The report contains a visual that shows gross sales by date. The visual has anomaly detection enabled.No anomalies are detected.You need to increase the likelihood that anomaly detection will identify anomalies in the report.What should you do? A. Increase the Expected range transparency setting. B. Add a data field to the Legend field well. C. Increase the Sensitivity setting. D. Add a data field to the Secondary values field well. Reveal Solution Discussion 17

Increase the Sensitivity setting

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.Every Product has a ProductSubCategory.Not every ProductsubCategory has a parent ProductCategory.You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.How should you merge the tables? If the left table is Product and the Right Table is ProductSubCategory, what is the join kind?

Inner

You build a report to help the sales team understand its performance and the drivers of sales.The team needs to have a single visualization to identify which factors affect success.Which type of visualization should you use? A. Key influencers B. Line and clustered column chart C. Q&A D. Funnel chart

Key influencers

You are creating a Power BI model to analyze inventory.You load data into three tables named Date, Product, and Inventory. The Inventory table relates to the Date and Product tables by using one-to-many relationships.Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month.You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date. How should you complete the measure? Last Inventory Count = [AllSelected, Calculate, CalculateTable](SUM('Inventory'[QuantityAvailable]), [LastDate, LastNonBlankValue, Max]('Date'[Date]))

Last Inventory Count = CALCULATE(SUM('Inventory'[QuantityAvailable]), LASTDATE('Date'[Date]))

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.Every Product has a ProductSubCategory.Not every ProductsubCategory has a parent ProductCategory.You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.How should you merge the tables? If the left table is ProductSubCategory and the Right Table is ProductCategory what is the join kind?

Left Outer

You need to create a visualization that compares revenue and cost over time.Which type of visualization should you use? A. waterfall chart B. stacked area chart C. line chart D. donut chart

Line chart

You have a dataset that contains revenue data from the past year.You need to use anomaly detection in Power BI to show anomalies in the dataset.What should you configure? To answer, select the appropriate options in the answer area. Chart Type: [Line, Pie, Treemap], Chart Configuration: [Select the Show value as option, Enable Cross-report drill-through, populate the axis with a date field]

Line, populate the axis with a date field

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? A. Viewer B. Admin C. Contributor D. Member

Member

You have two CSV files named Products and Categories.The Products file contains the following columns:✑ ProductID✑ ProductName✑ SupplierID✑ CategoryIDThe Categories file contains the following columns:✑ CategoryID✑ CategoryName✑ CategoryDescriptionFrom Power BI Desktop, you import the files into Power Query Editor.You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:✑ ProductID✑ ProductName✑ SupplierID✑ CategoryID✑ CategoryName✑ CategoryDescriptionHow should you combine the queries? Append, Merge, Transpose

Merge

You create a data model in Power BI.Report developers and users provide feedback that the data model is too complex.The model contains the following tables: Sales Region Table w region_id, name. Region_Manager Table with region_id, manager_id. Sales Manager table w/ sales_manager_id, name, region_id. Manager Table w/ manager_id, name. The model has the following relationships:✑ There is a one-to-one relationship between Sales_Region and Region_Manager.✑ There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.✑ There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Merge Region Manager and Manager by using an inner join, Merge Sales Manager and Sales Region by using a left join, Merge Sales REgion and Sales Manager by using a

Merge Region Manager and Manager by using an inner join, Merge Sales Region and Sales Manager by using an inner join, Merge Sales Region and Region Manager by using an inner join

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

Merge the Customer and Address tables

Name

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 Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:• Due Date• Order Date• Delivery DateYou need to support the analysis of sales over time based on all three dates at the same time.Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.Does this meet the goal? A. Yes B. No

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? A. Yes B. No

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 an average line by using the Salary measure.Does this meet the goal? A. Yes B. No Reveal Solution

You have a report page that contains the visuals shown in the following exhibit: Sales USD by Store Location MAP visual with Highlight selected, Quarterly Sales USD by Buying Group line visual that is selected, Sales USD for Q1 2016 AND pRIOR yEAR with no filter selected, and Top 10 Sales Associates with Highlight selected. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.NOTE: Each correct selection is worth one point.Hot Area: Selecting a quarter on the line chart will [Cross-filter, cross-highlight, not affect] the clustered column chart. Selecting a data point on the Tailspin Toys line on the line chart will [crossfilter, cross-highlight, not affect] the map.

Not affect, cross filter

You attempt to connect Power BI Desktop to a Cassandra database.From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.You need to select an alternate data connector that will connect to the database.Which type of connector should you choose? A. Microsoft SQL Server database B. ODBC C. OLE DB D. OData

ODBC

You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.You need to build the dashboard.Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Pin items from the reports to the dashboard Open the dashboard Create a phone layout for the existing reports Edit the Dashboard mobile view Rearrange, resize, or remove items from the mobile layout

Pin items from the reports to the dashboard, Open the Dashboard, Edit the Dashboard mobile view, Rearrange, resize, or remove items from mobile layout

You are creating a dashboard by using the Power BI service.You have an existing report page that contains three charts.You need to add the charts to the dashboard while maintaining the interactivity between the charts.What should you do? A. Edit interactions in the report and set all interactions to Filter. B. Pin each chart as a tile. C. Edit the dashboard theme and pin each chart as a tile. D. Pin the report page as a live tile.

Pin the report page as a live tile

For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The data model contains several measures. You need to create a Power BI report from the existing data. The solution must minimize development effort. Which type of data source should you use?

Power BI Dataset

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions.Each sales region has an HR manager.You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.How should you provision access to the reports for the HR managers? A. Publish the reports in an app and grant the HR managers access permission. B. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace. C. Publish the reports to a different workspace other than the one hosting the datasets. D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Publish the reports in an app and grant the HR managers access permission

In Power Query Editor, you have a query named Sales Data that contains the following columns: Sale Date (Date), Product ID (Whole Number, Product Name (Text), Product Category (Text), Customer ID (Whole Number)You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the size of the dataset.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. A. Reference the Sales Data query to create the new queries. B. Disable the load for the Sales Fact query. C. Duplicate the Sales Data query to create the new queries. D. Clear Include in report refresh for the Sales Data query. E. Disable the load for the Sales Data query.

Reference the Sales Data query to create the new queries, Disable the load for the Sales Data query

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.You build a report analyzing the internal networks of employees based on whom they send emails to.You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.What should you do? A. From Model view, set the Subject and Body columns to Hidden. B. Remove the Subject and Body columns during the import. C. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Remove the Subject and Body columns during the import.

You have a Power BI query named Sales that imports the columns shown in the following table: Table with ID column Sale_Date, Customer_ID, Delivery_Time, Status, Canceled_Date. Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis.You need to reduce the load times of the query without affecting the analysis.Which two actions achieve this goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. A. Remove the rows in which Sales[Status] has a value of Canceled. B. Remove Sales[Sales_Date]. C. Change the data type of Sale[Delivery_Time] to Integer. D. Split Sales[Sale_Date] into separate date and time columns. E. Remove Sales[Canceled Date].

Remove the rows in which Sales[Status] has a value of Canceled, Remove Sales[CanceledDate]

You have data in a Microsoft Excel worksheet as shown in the following table. SKU, Price, Discount (errors in discount). You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:• If the discount column returns an error, a discount of 0.05 must be used.• All the rows of data must be maintained.• Administrative effort must be minimized.What should you do in Power Query Editor? A. Select Replace Errors. B. Edit the query in the Query Errors group. C. Select Remove Errors. D. Select Keep Errors.

Replace Errors

You have a report that contains four pages. Each page contains slicers for the same four fields.Users report that when they select values in a slicer on one page, the selections are not persisted on other pages.You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. A. Create a bookmark for each slicer value. B. Replace the slicers with report-level filters. C. Sync the slicers across the pages. D. Replace the slicers with page-level filters. E. Replace the slicers with visual-level filters.

Replace the slicers with report-level filters, sync the slicers across the pages

You have a report that includes a card visualization.You need to apply the following conditional formatting to the card while minimizing design effort:✑ For values that are greater than or equal to 100, the font of the data label must be dark red.✑ For values that are less than 100, the font of the data label must be dark gray.Which type of format should you use? A. Color scale B. Rules C. Field value

Rules

You have a Power BI model that contains a table named Date. The Date table contains the following columns:• Date• Fiscal Year• Fiscal Quarter• Month Name• Calendar Year• Week Number• Month Number• Calendar QuarterYou need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year, Calendar Quarter, and Calendar Month.Which DAX function should you include in the table definition? A. ADDCOLUMNS B. CALCULATE C. SUMMARIZE D. DATATABLE

SUMMARIZE

You have a Power BI model that contains the following data: Date table with Date Month Year columns and Sales Table with Sale and Date. The Date table relates to the Sales table by using the Date columns. You need to create a calculated table that will contain the following:• A row for each year• A column that contains the total sales per year How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.Sales Summary = [ROLLUP, SELECTCOLUMNS, SUMMARIZE](Sales, [Date[Date], Date[Year], Sales[Date], "Sales", SUM(Sales[Sale]))

Sales Summary = SUMMARIZE(Sales, Date[Year], "Sales", SUM(Sales[Sale]))

You receive annual sales data that must be included in Power BI reports. From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit: Table with Month, MonthNumber, and sales information in 2019, 2020, and 2021 year columns. You need to create a report that meets the following requirements:• Visualizes the Sales value over a period of years and months• Adds a slicer for the month• Adds a slicer for the yearWhich three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select the Month and MonthNumber columns, Select Unpivot other columns, Rename the attribute column as Year and the Value column as Sales, Select the 2019, 2020, and 2021 columns, Select Transpose

Select the Month and MonthNumber columns, Select Unpivot other columns, Rename the Attribute column as Year and the Value column as Sales

You have a Microsoft Excel spreadsheet that contains the data shown in the following table: Department Column (Mathhematics, Matthematics, Geography, Geography), Stage Column (1, 2, 1, 2), School1 (75, 80, 95, 80), School2 (65, 70, 65, 70), School3 (90, 80, 80, 80), School 3 (70, 75, 75, 75) columns. You plan to build a data model for a Power BI report.You need to prepare the data so that it is available to the model in the format shown in the following table: Department (Mathematics, Geography), School (School1, School1), Average Score (77.5, 87.5) column. Which three actions should you perform in sequence in Power Query Editor? Select the [Department] and [Stage] columns and unpivot the other columns Select and unpivot the [Department] and [Stage] columns Group by [Department] and [School] and create a new column named [Avg Score] that uses the AVERAGE function on the [Score] column Rename the [Attribute] column as [School] and the [Value] column as [Score] Group by [Department][School1][School2][School3][School4] and create a new column named [Avg Score] that uses the AVERAGE function on the [Stage] column

Select the [Department] and [Stage] columns and unpivot the other columns, Rename the [Attribute] column as [School] and the [Value] column as [Score], Group by [Department and [School] and create a new column named [Avg Score] that uses the AVERAGE function on the [Score] column

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column.What should you do? A. Select the donut chart and set the column chart interaction to Filter. B. Select the column chart and set the donut chart interaction to Filter. C. Select the donut chart and set the column chart interaction to None. D. Select the column chart and set the donut chart interaction to None. Reveal Solution Discussion 15

Select the column chart and set the donut chart interaction to Filter

You use Power Query Editor to preview the data shown in the following exhibit: Table with SKU column, Price column, and Discount column with several error data points. You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select the discount column, select the price column, For the discount column change Data Type to Decimal Number, For the discount column, change Data Type to Whole Number, Select Replace Errors to replace each error value with 0.05

Select the discount column, Select Replace Errors to replace each error value with 0.05, For the discount column, change Data Type to Decimal Number

You have an Azure SQL database that contains sales transactions. The database is updated frequently.You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.How should you configure the data connection? A. Add a SQL statement. B. Set the Command timeout in minutes setting. C. Set Data Connectivity mode to Import. D. Set Data Connectivity mode to DirectQuery.

Set Data Connectivity mode to DirectQuery

In Power BI Desktop, you have a dataset that contains a table.You create a table visual on a Power BI report page as shown in the following exhibit: Plant Name and Plant Image columns - Plant image has links to imageYou need to configure the visual to display the referenced image instead of the URL in the Plant Image column. What should you do? A. From the Formatting tab, select Values, and then set URL icons to On for the table. B. Set the Data category of the Plant Image field to Web URL. C. Set the Data type of the Plant Image field to Binary. D. Set the Data category of the Plant Image field to Image URL.

Set the Data category of the Plant Image field to Image URL

You are creating a Power BI report by using Power BI Desktop.You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.Which type of visual should you use? A. Q&A B. smart narrative C. key influencers D. decomposition tree Reveal Solution

Smart Narrative

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.The report is a single page that contains 15 AppSource visuals and 10 default visuals.Users say that the report is slow to load the visuals when they access and interact with the report.You need to recommend a solution to improve the performance of the report.What should you recommend? A. Change any DAX measures to use iterator functions. B. Enable visual interactions. C. Replace the default visuals with AppSource visuals. D. Split the visuals onto multiple pages.

Split the visuals onto multiple pages

You have a Power BI data model that imports data from a Microsoft Excel spreadsheet.You use Power Query to load a query that contains both renamed and custom columns.Later, you attempt to reload the query and receive the following error message.Expression.Error: The column 'Category' of the table wasn't found.What are two possible causes of the error? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. A. The column was removed from the source file. B. The column was renamed in the source file. C. The file is no longer in the specified location. D. The data type of the column was changed.

The column was removed from the source file, the column was renamed in the source file

You have two Power BI reports named ReportA and ReportB that each uses a distinct color palette.You are creating a Power BI dashboard that will include two visuals from each report.You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. A. Upload a snapshot. B. For the browser, set the color preference to dark mode. C. When pinning visuals to the dashboard, select Use destination theme. D. Select the dark dashboard theme. E. Turn on tile flow.

When pinning visuals to the dashboard, select Use destination theme, Select the dark dashboard theme

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 percentile line by using the Salary measure and set the percentile to 50%.Does this meet the goal? A. Yes B. No

Yes

From Power Query Editor, you attempt to execute a query and receive the following error message.Datasource.Error: Could not find file.What are two possible causes of the error? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. A. You do not have permissions to the file. B. An incorrect privacy level was used for the data source. C. The file is locked. D. The referenced file was moved to a new location.

You do not have permissions to the file, the referenced file was moved to a new location

You have the Power BI data model shown in the following exhibit. Country Table with relationship to Sales and Human Resources tables. The Country table contains the following data.: Country column, Manager Column, Email Column. You create two row-level security (RLS) roles named Manager and CFO. You plan to publish the dataset to the Power BI service. You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:• Each manager must see only the data in the Sales and Human Resources tables for their own country.• The CFO must be prevented from seeing the data in the Human Resources table.• The CFO must see the sales data of all countries. How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. DAX Expressions Given: [Country] = "USA", [Email] = userprincipalname(), [Manager] = "CFO", False(), True(). What expression should be used for Human Resources and Country.

[Email] = userprincipalname(), [Manager] = "CFO

You have a report in Power BI Desktop.You add a key influencers visual as shown in the exhibit: Key influencers for What influences attrition to increase. When Overtime is YES the average of attrition increases by .2. Bar chart shows that when overtime is yes the max average of attrition is .3 and when no its .1. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. Identifying additional factors that increate attrition can be achieved by [turning on Cross-report, adding more fields to Explain by, adding my fields to Expand by, moving fields from Explain by to Expand by]. Exployee attrition is [.11, .2, 1, 3] times greater when employees work overtime

adding more fields to Explain by, 3

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? A. decomposition tree B. funnel chart C. Q&A D. key influencers

decomposition tree

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? A. Q&A B. smart narrative C. decomposition tree D. key influencers Reveal Solution

key influencers

You have a collection of reports for the HR department of your company.You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.Which type of visualization should you use? A. ribbon chart B. scatter chart C. line chart D. key influencers

line chart

You build a report to analyze customer transactions from a database that contains the tables shown in the following table: Customer Table with CustomerID(primary key), Name, State, and Email. Transaction Table with TransactionID (primary key), CustomerID (foreign key), Date and Amount. You import the tables.Which relationship should you use to link the tables? A. one-to-many from Transaction to Customer B. one-to-one between Customer and Transaction C. many-to-many between Customer and Transaction D. one-to-many from Customer to Transaction

one-to-many from Customer to Transaction

You have a table that contains sales data and approximately 1,000 rows.You need to identify outliers in the table.Which type of visualization should you use? A. area chart B. scatter plot C. pie chart D. donut chart

PL 300

Related study sets

Econ 220 Exam #3 2

geology ch. 10

AVSC 1050 Final Exam

1x1 - 19er Reihe

Lab 4: The Cell

Ethical Hacking Module 2

AP BIOLOGY MIDTERM REVIEW Unit 2

Personal Finance Chapter 4: Planning Your Tax Strategy

Protein (PP5)

Astronomy chapter 5

Business Law Final

Chapter 10 Operations Management

MGMT 493 Chapter 11 - Berns

Chapter 23 AMH

ECO exam 1

Hofstede's Cultural Dimensions CH2 (3 Points)

Rell Part 2

HRTM Exam 4

MKT 1001 Chapters 7 and 8 Quiz

Microbiology, Ch 13 Nester's 9th