Pl300

You are using Power BI Desktop to connect to an Azure SQL database.The connection is configured 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.NOTE: Each correct solution is worth one point. The default timeout for the connection from PowerBI Desktop to the database will be - Unlimited, one minute, 10 minutes The navigator will display - all the tables, only tables that contain data, only tables that contain hierarchies

The default timeout for the connection from PowerBI Desktop to the database will be - 10 minutes The navigator will display - only tables that contain data

DRAG DROP -You are preparing a financial report in Power BI.You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit. You need to prepare the data to support the following: ✑ Visualizations that include all measures in the data over time ✑ Year-over-year calculations for all the measures 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.Select and Place: Use headers as the first row Rename the Measure column as Year Rename the Attribute column as Year Use the first row as headers Transpose the table Unpivot all the columns other than Measure Change the data type of the Year column to Date

Transpose the table Use the first row as headers Unpivot all the columns other than Measure Rename the Measure column as Year

DRAG DROP -You need create a date table in Power BI that must contain 10 full calendar years, including the current year.How should you complete the DAX expression? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Select and Place: Date = var var1 = VALUE ( VALUE () ) return VALUE ( DATE(var1 -9, 01, 01), DATE(var1, 12, 31)) VALUES: CALENDAR, CALENDARAUTO, DATE, EOMONTH, TODAY, YEAR

YEAR, TODAY, CALENDAR

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

A. Key influencers

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

D. Member

DRAG DROP -You have a Microsoft Excel spreadsheet that contains the data shown in the following table. 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. Which three actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place: 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 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

C. line chart

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. 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: There are [answer] different values in State including nulls There are [answer] non-null values that occur only once in state

69 4

You have a Power BI report.You have the following tables. You have the following DAX measure.Accounts :=CALCULATE (DISTINCTCOUNT (Balances[AccountID]),LASTDATE ('Date'[Date])For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. YES/NO A table visual that displays the date hierarchy at the year level and the [accounts] measure will show the total number of accounts that were live throughout the year A table visual that displays the date hierarchy at the month level and the [accounts] measure will show the total number of accounts that were live throughout the month A table visual that displays the date hierarchy at the day level and the [accounts] measure will show the total number of accounts that were live that day

A table visual that displays the date hierarchy at the year level and the [accounts] measure will show the total number of accounts that were live throughout the year : NO A table visual that displays the date hierarchy at the month level and the [accounts] measure will show the total number of accounts that were live throughout the month : NO A table visual that displays the date hierarchy at the day level and the [accounts] measure will show the total number of accounts that were live that day : YES

You have a Power BI data model that analyzes product sales over time. The data model contains the following tables. A one-to-many relationship exists between the tables.The auto date/time option for the data model is enabled.You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct answer is worth one point. A. Create a relationship between the Date table and the Sales table. B. Disable the auto date/time option. C. Create a Date table and select Mark as Date Table. D. Disable the load on the Date table. E. Remove the relationship between the Product table and the Sales table.

A. Create a relationship between the Date table and the Sales table. C. Create a Date table and select Mark as Date Table.

You have the Power BI model shown in the following exhibit. 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.

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

You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month.You need to create an ad analytics system to meet the following requirements: ✑ Present ad impression counts for the day, campaign, and site_name. The analytics for the last year are required.Minimize the data model size. Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. A. Create one-to-many relationships between the tables. B. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function. C. Create a calculated table that contains Ad_id, Site_name, and Impression_date. D. Create a calculated measure that aggregates by using the COUNTROWS function.

A. Create one-to-many relationships between the tables. B. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function.

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 City The key influencers visual returns the results shown in the following exhibit. What can you identify from the visual? A. Customers in Austria order 18.8 more units than the average order quantity. 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.

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

You are building a data model for a Power BI report.You have data formatted as shown in the following table. You need to create a clustered bar chart as shown in the following exhibit. What should you do? A. From Power Query Editor, split the Machine-User column by using a delimiter. B. From Power Query Editor, create a column that contains the last three digits of the Machine-User column. C. In a DAX function, create two calculated columns named Machine and User by using the SUBSTITUTE function. D. In a DAX function, create two measures named Machine and User by using the SUBSTITUTE function.

A. From Power Query Editor, split the Machine-User column by using a delimiter.

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 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 ID Address contains the following columns: ✑ Address ID ✑ Address Line 1 ✑ Address Line 2 ✑ City ✑ State/Region ✑ Country ✑ Postal Code Each 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.

A. Merge the Customer and Address tables.

You have a Power BI model that contains a table named Employee. The table contains the following data. Each employee has one manager as shown in the ParentEmployeeID column.All reporting paths lead to the CEO at the top of the organizational hierarchy.You need to create a calculated column that returns the count of levels from each employee to the CEO.Which DAX expression should you use? A. PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID])) B. PATHITEM(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1,INTEGER) C. PATHCONTAINS(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1) D. PATH(Employee[EmployeeID],Employee[ParentEmployeeID])

A. PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))

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? A. Power BI dataset B. a SharePoint folder C. Power BI dataflows D. an Excel workbook

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

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

You use Power BI Desktop to load data from a Microsoft SQL Server database.While waiting for the data to load, you receive the following error.You need to resolve the error.What are two ways to achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. A. Reduce the number of rows and columns returned by each query. B. Split log running queries into subsets of columns and use Power Query to merge the queries. C. Use Power Query to combine log running queries into one query. D. Disable query folding on long running queries.

A. Reduce the number of rows and columns returned by each query. B. Split log running queries into subsets of columns and use Power Query to merge the queries.

You have a Power BI query named Sales that imports the columns shown in the following table. 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].

A. Remove the rows in which Sales[Status] has a value of Canceled. E. Remove Sales[Canceled Date].

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date andOrders and between City and Orders.The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.City[State Province] = "Kentucky"Role2 contains the following filter.Date[Calendar Year] = 2020 -If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model? A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020. B. The user will receive an error and will not be able to see the data in the report. C. The user will only see data for which the State Province value is Kentucky. D. The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.

A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.

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. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in the query.You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.Solution: You split the IoT DateTime column into a column named Date and a column named Time.Does this meet the goal? A. Yes B. No

A. Yes

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.During the development process, you need to import a sample of the data from the Order table.Solution: You add a WHERE clause to the SQL statement.Does this meet the goal? A. Yes B. No

A. Yes

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 Date You need to support the analysis of sales over time based on all the date foreign keys. 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.Does this meet the goal? A. Yes B. No

A. Yes

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 Date You need to support the analysis of sales over time based on all the date foreign keys. Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date andDelivery Date.Does this meet the goal? A. Yes B. No

A. Yes questionably - could be no

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

A. highlight

You have a table that contains the following three columns: City - ✑ Total Sales ✑ Occupation You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.) How should you configure the visualization? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Analyze: City, Occupation, Total Sales Explain by: City, Occupation, Total Sales

Analyze: Total Sales Explain by: Occupation

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

B. Rules

You have the Power BI model shown in the following exhibit There are four departments in the Departments table.You need to ensure that users can see the data of their respective department only.What should you do? A. Create a slicer that filters Departments based on DepartmentID. B. Create a row-level security (RLS) role for each department, and then define the membership of the role. C. Create a DepartmentID parameter to filter the Departments table. D. To the ConfidentialData table, add a calculated measure that uses the CURRENTGROUP DAX function.

B. Create a row-level security (RLS) role for each department, and then define the membership of the role.

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.What should you do? A. Create an inactive relationship between the tables and select Apply security filter in both directions. B. Create an active relationship between the tables and select Apply security filter in both directions. C. Create an inactive relationship between the tables and select Assume referential integrity. D. Create an active relationship between the tables and select Assume referential integrity.

B. Create an active relationship between the tables and select Apply security filter in both directions.

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.

B. From ReportA save the current theme. E. From DashboardA, upload a JSON theme.

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.

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

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. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in the query.You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You change the IoT DateTime column to the Date data type.Does this meet the goal? A. Yes B. No

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. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in the query.You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.Does this meet the goal? A. Yes B. No

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.During the development process, you need to import a sample of the data from the Order table. Solution: You add a report-level filter that filters based on the order date.Does this meet the goal? A. Yes B. No

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.During the development process, you need to import a sample of the data from the Order table.Solution: From Power Query Editor, you import the table and then add a filter step to the query.Does this meet the goal? A. Yes B. No

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.During the development process, you need to import a sample of the data from the Order table.Solution: You write a DAX expression that uses the FILTER function.Does this meet the goal? A. Yes B. No

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 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 the date foreign keys. Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.Does this meet the goal? A. Yes B. No

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 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 Date You need to support the analysis of sales over time based on all the date foreign keys.Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table.Does this meet the goal? A. Yes B. No

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. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in the query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.Solution: You remove the IoT GUID column and retain the IoT ID column.Does this meet the goal? A. Yes B. No

B. No Could be yes

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

B. ODBC

You have a Power BI report for the procurement department. The report contains data from the following tables. There is a one-to-many relationship from Suppliers to LineItems that uses the ID and Supplier ID columns.The report contains the visuals shown in the following table You need to minimize the size of the dataset without affecting the visuals.What should you do? A. Merge Suppliers and LineItems. B. Remove the LineItems[Description] column. C. Remove the rows from LineItems where LineItems[Invoice Date] is before the beginning of last month. D. Group LineItems by LineItems[Invoice ID] and LineItems[Invoice Date] with a sum of LineItems[Price].

B. Remove the LineItems[Description] column.

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.

B. Remove the Subject and Body columns during the import.

You have a Power BI report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables. There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns.The report contains the visuals shown in the following table. The dataset takes a long time to refresh.You need to modify Posts and Traffic queries to reduce load times.Which two actions will reduce the load times? Each correct answer presents part of the solution.NOTE:Each correct selection is worth one point. A. Remove the rows in Posts in which Posts[Publish Date] is in the last seven days. B. Remove the rows in Traffic in which Traffic[URL Visited] does not contain ג€blogג€. C. Remove Traffic[IP Address], Traffic[Browser Agent], and Traffic[Referring URL]. D. Remove Posts[Full Text] and Posts[Summary]. E. Remove the rows in Traffic in which Traffic[Referring URL] does not start with ג€/ג€.

B. Remove the rows in Traffic in which Traffic[URL Visited] does not contain ג€blogג€. D. Remove Posts[Full Text] and Posts[Summary].

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. Remove unused columns from tables in the data model. C. Replace the default visuals with AppSource visuals. D. Increase the number of times that the dataset is refreshed.

B. Remove unused columns from tables in the data model.

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. Implement row-level security (RLS). B. Remove unused columns from tables in the data model. C. Replace the default visuals with AppSource visuals. D. Enable visual interactions.

B. Remove unused columns from tables in the data model.

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. Replace the default visuals with AppSource visuals. B. Remove unused columns from tables in the data model. C. Change the imported dataset to DirectQuery D. Increase the number of times that the dataset is refreshed.

B. Remove unused columns from tables in the data model.

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.

B. Replace the slicers with report-level filters. C. Sync the slicers across the pages.

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.

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

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. Change the data type of the Logged column to Date. B. Split the Logged column by using at as the delimiter. C. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number. D. Apply the Parse function from the Date transformations options to the Logged column.

B. Split the Logged column by using at as the delimiter.

You are creating a quick measure as shown in the following exhibit. You need to create a monthly rolling average measure for Sales over time.How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Base value: Month, Total Cost, Total Order Qty, Total Sales, Year Date: Date, Month, Total Sales, Year Period: Days, Months, Quarters, Years

Base value: Total Sales Date: Date Period: Months

You plan to create the chart shown in the following exhibit. 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.

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

You have the Power BI data model shown in the following exhibit. The Sales table contains records of sales by day from the last five years up until today's date.You plan to create a measure to return the total sales of March 2021 when March 2022 is selected.Which DAX expression should you use? A. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date]) B. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] ) C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] )) D. SUM(Sales[Sales])

C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))

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 first 11 characters of the logged column. B. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number. C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date. D. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. TheEnhanced Dataflows Compute Engine is turned on for the dataflow.You need to use the dataflow in a report. The solution must meet the following requirements: ✑ Minimize online processing operations. ✑ Minimize calculation times and render times for visuals. ✑ Include data from the current year, up to and including the previous day.What should you do? A. Create a dataflows connection that has DirectQuery mode selected. B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset. C. Create a dataflows connection that has Import mode selected and schedule a daily refresh. D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

C. Create a dataflows connection that has Import mode selected and schedule a daily refresh.

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? A. Microsoft Teams Personal Analytics B. SQL Server database C. Dataverse D. Dataflows

C. Dataverse

You are creating a sales report in Power BI for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table: The report will facilitate the following analysis: ✑ The count of orders and the sum of total sales by Order Date ✑ The count of customers who placed an order ✑ The average quantity per order You need to reduce data refresh times and report query times.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. A. Set the data type for SalesOrderNumber to Decimal Number. B. Remove the CustomerKey and ProductKey columns. C. Remove the TaxAmt and Freight columns. D. Filter the data to only the NorthWest region sales territory.

C. Remove the TaxAmt and Freight columns. D. Filter the data to only the NorthWest region sales territory.

You are creating a Power BI model that contains a table named Store. Store contains the following fields. You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City.What should you do to ensure that the locations are mapped properly? A. Change the data type of City, State/Province, and Country. B. Set Summarization for City, State/Province, and Country to Don't summarize. C. Set the data category of City, State/Province, and Country. D. Create a calculated column that concatenates the values in City, State/Province, and Country.

C. Set the data category of City, State/Province, and Country.

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.

C. Split the Logged column by using at as the delimiter.

DRAG DROP -You are modifying a Power BI model by using Power BI Desktop.You have a table named Sales that contains the following fields. You have a table named Transaction Size that contains the following data. You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value 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. Transaction Size = VAR SalesTotal = 'Sales'[Sales] VAR FilterSegment = VALUE( 'Transaction Size', VALUE ( 'Transaction Size' [min] <= SalesTotal, 'Transaction Size'[max] >= SalesTotal)) VAR Result = VALUE (DISTINCT ( 'Transaction Size'[Transaction Size] ), FilterSegment) RETURN Result

CALCULATE, AND, FILTER

DRAG DROP-You have a Power BI data model that contains two tables named Products and Sales.A one-to-many relationship exists between the tables.You have a report that contains a report-level filter for Products.You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.How should you complete the DAX measure? To answer, drag the appropriate DAX functions to the correct targets. Each function 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. Percent of product sales = VAR ProductSales = SUM ('Sales'[Sales]) VAR AllSales = DAX function (SUM('Sales'[Sales]), DAX function ('Products' [Product])) RETURN DIVIDE (ProductSales, AllSales) DAX function: ALL, ALLSELECTED, CALCULATE, FILTER, SELECTEDVALUE

CALCULATE, FILTER

You are creating a Microsoft Power BI data model that has the tables shown in the following table. The Products table is related to the ProductCategory table through the ProductCategoryID column. Each product has one product category.You need to ensure that you can analyze sales by product category.How should you configure the relationship from ProductCategory to Products? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Cardinality: One-to-Many, One-to-one, Many-to-Many Cross-filter direction: Single, Both

Cardinality: One-to-Many Cross-filter direction: Single

DRAG DROP-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 an 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

You have a Power BI imported dataset that contains the data model 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.NOTE: Each correct selection is worth one point.Hot Area: Changing the [answer] setting of the relationships will improve report query performance. : Cardinality, Cross filter direction, Assume Referential Integrity The data model is organized into a [answer] : star schema, snowflake schema, denormalized table

Changing the [answer] setting of the relationships will improve report query performance. : Assume Referential Integrity The data model is organized into a [answer] : star schema

You have two CSV files named Products and Categories. The Products file contains the following columns: ✑ ProductID✑ ProductName✑ SupplierID✑ CategoryID The Categories file contains the following columns: ✑ CategoryID✑ CategoryName✑ CategoryDescription From 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 How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Combine the queries by performing a: Append, Merge, Transpose On the categories query: Delete the query, Disable the query load, Exclude the query from report refresh

Combine the queries by performing a: Merge On the categories query: Disable the query load

You need to create a visual as shown in the following exhibit 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

Conditional Formatting: Background color Format by: Rules

You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.) The 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 .✑ SalesAggregate must be refreshed once per week. You need to select the storage modes for the tables. The solution must meet the following requirements: ✑ Minimize the load times of visuals. ✑ Ensure that the data is loaded to the model based on the refresh requirements. Which storage mode should you select for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Customer: Direct Query, Dual, Import Date: DirectQuery, Dual, Import Sales: DirectQuery, Dual, Import SalesAggregate: DirectQuery, Dual, Import

Customer: Dual Date: Dual Sales: DirectQuery SalesAggregate: Import

You build a report to analyze customer transactions from a database that contains the tables shown in the following table. 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

D. one-to-many from Customer to Transaction

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

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

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

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.

D. Pin the report page as a live tile.

You import a Power BI dataset that contains the following tables: ✑ Date ✑ Product ✑ Product InventoryThe Product Inventory table contains 25 million rows. A sample of the data is shown in the following table. The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to the Product table by using theProductKey column.You need to reduce the size of the data model without losing information.What should you do? A. Change Summarization for DateKey to Don't Summarize. B. Remove the relationship between Date and Product Inventory C. Change the data type of UnitCost to Integer. D. Remove MovementDate.

D. Remove MovementDate.

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.

D. Set Data Connectivity mode to DirectQuery.

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

D. SharePoint folder E. Web

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.

D. Split the visuals onto multiple pages.

You have the Power BI data model shown in the following exhibit. You need to create a measure to count the number of product categories that had products sold during a selected period.How should you complete the DAX expression? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Product Categories Sold = CALCULATE ( _____________________ _____________________) DISTINCTCOUNT('Product' [ProductCategory]), COUNT('Product' [ProductCategory]), DISTINCTCOUNT('Sales' [ProductID]), SUM('Sales' [SalesQuantity]) 'Sales' , 'Product' , 'Product' [ProductCategory] , 'Date'

DISTINCTCOUNT('Product' [ProductCategory]) 'Date'

DRAG DROP -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. Select and Place: Pin items from the reports to the dashboard Open the dashbord Create a phone layout for the existing reports Edit the dashboard mobile view Rearrange, resize, or remove items from the mobile layout

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

You are creating an analytics report that will consume data from the tables shown in the following table. There is a relationship between the tables.There are no reporting requirements on employee_id and employee_photo.You need to optimize the data model.What should you configure for employee_id and employee_photo? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Employee_id: Change Type, Delete, Hide, Sort Employee_photo: Change Type, Delete, Hide, Sort

Employee_id: Hide Employee_photo: Delete

DRAG DROP -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.Select and Place: 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 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, expand the Attributes column From Power Query Editor, combine the content column

DRAG DROP -You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.Sheet1 contains the following table named Table1. Sheet2 contains the following table named Table2. 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. 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 and Place: From Power Query Editor, remove errors from the table; From Power Query Editor, select Table1, and then 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

From Power Query Editor, append Table2 to Table1 From Power Query Editor, remove errors from the table From Power Query Editor, select Table1, and then select Remove Duplicates

DRAG DROP -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.Select and Place: 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 ReportA, select Get Insights From DashboardA, select the TileA options, and then select View Insights From focus mode, pin the relevant visuals to DashboardA

You have a Power BI data model that contains a table named Stores. The table has the following columns: • Store Name• Open Date• Status• State• City You need to create a calculated column named Active Store Name that meets the following requirements: • When the value of the Status column is "A", the value in the Store Name column must be returned. • When the value of the Status column is NOT "A", the value in the Store Name column that is prefixed with "Inactive - " must be returned. How should you complete the DAX expression? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Active Store Name = ______ ([Status] = "A", [Store Name], "Inactive - " __________ [Store Name]) IF, SWITCH, TRUE &, &&, +

IF, &

You have a report in Power BI Desktop.You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.) 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. Identifying additional factors that increase attrition can be achieved by [answer] : turning on cross-report, adding more fields to Explain by, adding more fields to Expand by, moving fields from Explain to Expand by Employee attrition is [answer] times greater when employees work overtime : 0.11, .2, 1, 3

Identifying additional factors that increase attrition can be achieved by [answer] : moving fields from Explain to Expand by Employee attrition is [answer] times greater when employees work overtime : 3

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.Select and Place: Publish the report Assign users to the role Add a filter to the report Create a role definition Import the data to PowerBI desktop

Import the data to PowerBI desktop Create a role definition Assign users to the role Publish the report

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. 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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.Select and Place: 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 an inner join Merge [Sales_Region] and [Sales_Manager] by using an inner join as a new query named [Sales_Region_and_Manager] Merge [Sales_Region] and [Region_Manager] by using a right join as a new query named [Sales_Region_and_Region_Manager] Merge [Sales_Region] and [Region_Manager] by using an inner join

Merge [Sales_Region] and [Sales_Manager] by using an inner join Merge [Region_Manager] and [Manager] by using an inner join Merge [Sales_Region] and [Region_Manager] by using a right join as a new query named [Sales_Region_and_Region_Manager]

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 answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Option to use to combine the Customer tables: Append queries, Append queries as new, Merge queries, Merge queries as new Action to perform on the original two SQL database queries: Delete the queries, Disable including the query in the report refresh, Disable loading the query to the data model, Duplicate the queries

Option to use to combine the Customer tables: Append queries as new Action to perform on the original two SQL database queries: Disable loading the query to the data model

DRAG DROP -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? To answer, drag the appropriate merge types to the correct queries. Each merge type 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. Select and Place: JOIN KINDS: Full outer Inner Left anti Left outer Right anti Right outer

Product - Product Subcategory : Inner ProductSubCategory - ProductCategory : Left outer

You are enhancing a Power BI model that has DAX calculations.You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.Which DAX functions should you use? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Sales PYTD = VAR startyear = STARTOFYEAR ( PREVIOUSYEAR ( 'Calendar'[Date] ) ) VAR enddate = LASTDATE ( Sales[Date]) - 365 RETURN : CALCULATE ( , DATESBETWEEN ( , SAMEPERIODLASTYEAR ( , SUM ( (Sales[sales]), : CALCULATE ( , DATESBETWEEN ( , SAMEPERIODLASTYEAR ( , SUM ( ('Calendar' [Date], startyear, enddate) : CALCULATE ( , DATESBETWEEN ( , SAMEPERIODLASTYEAR ( , SUM (

RETURN : CALCULATE ( (Sales[sales]), : SUM ( ('Calendar' [Date], startyear, enddate) :SAMEPERIODLASTYEAR (

You create a Power BI dataset that contains the table shown in the following exhibit. You need to make the table available as an organizational data type in Microsoft Excel. How should you configure the properties of the table? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Row label: Cost center, Headcount, ID, Name Key Column: Cost center, Headcount, ID, Name Is Featured Label: Yes, No

Row label: Cost center Key Column: ID Is Featured Label: Yes

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.NOTE: Each correct selection is worth one point. Sales Previous Year = CALCULATE, EVALUATE, SUM, SUMX [Total Sales], DATESMTD, PARALLELPERIOD, SAMEPERIODLASTYEAR, TOTALMTD [Date], 'Date' [Date], 'Date' [Month]

Sales Previous Year = CALCULATE [Total Sales], PARALLELPERIOD 'Date' [Month]

You are building a financial report by using Power BI.You have a table named financials that contains a column named Date and a column named Sales.You need to create a measure that calculates the relative change in sales as compared to the previous quarter.How should you complete the measure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Sales QoQ% = IF ( ISFILTERED ('financials' [Date]), ERROR("Uh oh."), VAR PREV_QUARTER = : CALCULATE, CALCULATE TABLE, DATEADD, DIVIDE, FILTER, FIND (SUM('financials'[sales]), : CALCULATE, CALCULATETABLE, DATEADD, DIVIDE, FILTER, FIND ('financials'[Date].[Date], -1 QUARTER) ) RETURN : CALCULATE, CALCULATETABLE, DATEADD, DIVIDE, FILTER, FIND (SUM('financials'[Sales]) - PREV_QUARTER, PREV_QUARTER)

Sales QoQ% = IF ( ISFILTERED ('financials' [Date]), ERROR("Uh oh."), VAR PREV_QUARTER = : CALCULATE (SUM('financials'[sales]), : DATEADD RETURN : DIVIDE

DRAG DROP -You receive revenue data that must be included in Microsoft Power BI reports.You preview the data from a Microsoft Excel source in Power Query as shown in the following exhibit. You plan to create several visuals from the data, including a visual that shows revenue split by year and product.You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.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 and Place: Select department and product and unpivot columns Select use first row as headers Select department and product and unpivot other columns Rename the attribute column to year and the value column to revenue Select use header as first row Rename the attribute column to revenue and the value column to year

Select department and product and unpivot other columns Rename the attribute column to revenue and the value column to year Select use first row as headers

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. 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 year Which three actions should you perform in sequence? 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, 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 Power BI report named Orders that supports the following analysis: ✑ Total sales over time ✑ The count of orders over time ✑ New and repeat customer counts The data model size is nearing the limit for a dataset in shared capacity.The model view for the dataset is shown in the following exhibit. The data view for the Orders table is shown in the following exhibit. The Orders table relates to the Customers table by using the CustomerID column.The Orders table relates to the Date table by using the OrderDate column.For each of the following statements, select Yes if the statement is true, Otherwise, select No.NOTE: Each correct selection is worth one point. YES/NO Summarizing Orders by the CustomerID, OrderID, and OrderDate columns will reduce the model size while still supporting the current analysis Removing the CustomerID column from Orders will reduce the model size while still supporting the current analysis Removing the UnitPrice and Discount columns from Orders will reduce the model size while still supporting the current analysis

Summarizing Orders by the CustomerID, OrderID, and OrderDate columns will reduce the model size while still supporting the current analysis : NO Removing the CustomerID column from Orders will reduce the model size while still supporting the current analysis : NO Removing the UnitPrice and Discount columns from Orders will reduce the model size while still supporting the current analysis : YES

You are creating a Power BI model and report.You have a single table in a data model named Product. Product contains the following fields: ✑ ID ✑ Name ✑ Color ✑ Category ✑ Total SalesYou need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value 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.Select and Place: Top 8 products = VALUE (8, 'Product' , 'Product'[Total Sales], VALUE) Values: ASC, DESC, RELATEDTABLE, CALCULATETABLE, MAXX, TOPN

TOPN, DESC

You have a Power BI report that contains a measure named Total Sales.You need to create a new measure that will return the sum of Total Sales for a year up to a selected date.How should you complete the DAX expression? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Measure = : TOTALYTD, CALCULATE, SUM, EVALUATE ([Total Sales], : 'Date'[Date], TODAY(), EOMONTH('Date'[Date]), LASTDATE('Date'[Date])

TOTALYTD, 'Date'[Date]

You plan to create Power BI dataset to analyze attendance at a school. Data will come from two separate views named View1 and View2 in an Azure SQL database.View1 contains the columns shown in the following table. View2 contains the columns shown in the following table. The views can be related based on the Class ID column.Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during two different periods, but the class will have a different class ID.You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis: ✑ The count of classes that occur by period ✑ The count of students in attendance by period by day ✑ The average number of students attending a class each month. In which table should you include the Teacher First Name and Period Number fields? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Teacher first name: Attendance fact, Class dimension, Teacher dimension, Teacher fact Period Number: Attendance fact, Class dimension, Teacher dimension, Teacher fact

Teacher first name: Teacher fact Period Number: Attendance fact

You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.) The related dimension tables are imported into the model.Sales contains the data shown in the following table. You are evaluating how to optimize the model.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area: YES/NO The SalesRowID and AuditID columns can be removed from the model without impeding the analysis goals Both the OrderDateKey and OrderDate columns are necessary to perform the basket analysis The TaxAmt column must retain the current number of decimal places to perform the basket analysis

The SalesRowID and AuditID columns can be removed from the model without impeding the analysis goals : YES Both the OrderDateKey and OrderDate columns are necessary to perform the basket analysis : NO The TaxAmt column must retain the current number of decimal places to perform the basket analysis : NO

You have a column named UnitsInStock as shown in the following exhibit. UnitsInStock has 75 non-null values, of which 51 are unique.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. When a table visual is created in a report and UnitsInStock is added to the values, there will be [answer] in the table : 0 rows, 1 row, 51 rows, 75 rows Changing the summarize by setting of the UnitsInStock column, and then adding the column to a table visual will [answer] the numbers of rows in the table visual : maintain, reduce, increase

When a table visual is created in a report and UnitsInStock is added to the values, there will be [answer] in the table : 75 rows Changing the summarize by setting of the UnitsInStock column, and then adding the column to a table visual will [answer] the numbers of rows in the table visual : reduce