PL300 TEST2

1 Your goal is to adjust this table to match the desired format. What should you do?

• a) From the Format menu, click Trim.
• b) From the Extract menu, click Last Characters.
• c) From the Split Column menu, click By Delimiter.
• d) From the Extract menu, click Text After Delimiter.

2

• a) Delete the query, import the data into Microsoft SQL Server, and then import the data from SQL Server.
• b) In Query Editor, add a calculated column that totals the sales amount column.
• c) Change the Data Type of sales amount column to Numeric.
• d) Refresh the data model.

3 You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data. In Power BI Desktop, you are using a query to retrieve data from the cube. However, the query only retrieves 25,499 records, whereas the data warehouse that is the source of the cube contains 26,423 records. You need to adjust the query to ensure that it retrieves all 26,423 records.

• a) From Query Editor, refresh all the data.
• b) Change the query to use Live connection mode.
• c) Delete the Remove Duplicates step.
• d) Add an Unpivot Columns step.

4 You are planning to use Power BI Desktop to import data from 100 CSV files. These files, which are stored on a network share, contain data from different stores but share the same structure. Your task is to combine these CSV files into a single table, ensuring that the administrative effort is kept to a minimum. What steps should you take to achieve this?

• a) Add a folder data source and use the Combine Files command.
• b) Add a folder data source and use the Merge Queries command.
• c) Add a Microsoft Excel data source and use the Merge Queries command.
• d) Add text/CSV data sources and use the Append Queries command

5

• a) Combine Files
• b) Merge Queries
• c) Merge Columns
• d) Append Queries

6. What should you do?

• a) Unpivot
• b) Pivot
• c) Use First Row as Headers
• d) Transpose

7

• a) Temperature Measurements Fact
• b) Date Dimension
• c) Location Dimension
• d) Location Fact

8. 1) 1st join kind

• Inner
• Full outer
• Left Anti
• Left outer
• Right Anti

8. 2) 2st join kind

• Left outer
• Full outer
• Inner
• Left Anti
• Right Anti

• 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