PL-300 Free Practice Questions — Page 15

Question 132

You are reviewing a Power BI data model. You have a calculated table that has the following definition. ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB ) You need to identify the results of the DAX expression. Which rows will be returned in ProductList?

Question 133

You have a Power BI report that contains the visuals shown in the following table. You need to modify the location of each visual. What should you modify for each visual?

Question 134

You have a Power BI model that contains the following data. The Date table relates to the Sales table by using the Date columns. The model contains the following DAX measure. Total Sales = SUM(Sales[Sale]) You need to create another measure named Previous Quarter to display the sales one quarter before the selected period. Which DAX calculation should you use?

Question 135

HOTSPOT - You have a query named All Sales that imports sales data into a Power BI model. You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements: • Use All Sales as the source for three other queries named Sales Fact, Product Dimension, and Customer Dimension. • Minimize maintenance effort. What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 136

HOTSPOT - You are creating a Power BI report that will show the number of current employees over time. The report will use Import storage mode for all tables. The employment data will be imported from Azure SQL Database in a monthly snapshot. The data will be stored in a table named Headcount and will contain the following: • One row per employee for each month the employee is employed • In each row, a date key that shows the first day of the month of each snapshot You have a related date table that contains dates for the years 2020 to 2030. You need to create a semi-additive DAX measure that will return the count of employees for the last available date in a year, quarter, or month. How should you complete the measure? To answer, select the appropriate options in the answer area.

Question 137

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table. You need to combine the tables into a single query that contains the unique columns of each table. What should you select in Power Query Editor?

Question 138

You publish a dataset to the Power BI service. The dataset contains a connection to an on-premises Microsoft SQL Server database. You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway. You confirm the following with the administrator of the gateway: • You have the appropriate permissions to use the gateway. • The data source was created on the gateway. • The gateway has a status of Running. What is the most likely reason the gateway is unavailable?

Question 139

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?

Question 140

You have a Power BI model that contains two tables named Population and Date. The Population table contains two columns named PopulationAmount and DateKey. DateKey contains date values that represent the first day of a year and are used to create a many-to-one relationship with the Date table. The Power BI model contains two measures that have the following definitions. Total Population = Sum(‘Population’[PopulationAmount]) 2023 Population = CALCULATE([Total Population], ‘Date'[Year] = 2023) You create a table visual that displays Date[Year] and [2023 Population]. What will the table visual show?

Question 141

DRAG DROP - You have two Microsoft Excel workbooks in a Microsoft OneDrive folder. Each workbook contains a table named Sales. The tables have the same data structure in both workbooks. You plan to use Power BI to combine both Sales tables into a single table and create visuals based on the data in the table. The solution must ensure that you can publish a separate report and dataset. Which storage mode should you use for the report file and the dataset file? To answer, drag the appropriate modes to the correct files. Each mode may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.