PART 1-PL-300-Power BI Data Analyst Associate (Intermediate LV1)

2- 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

3- 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

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

5.1- You have two Azure SQL databases that contain the same tables and columns. Option to use to combine the Customer tables …........

• Append Queries
• Append Queries as New
• Merge Queries
• Merge Queries as New

5.2- You have two Azure SQL databases that contain the same tables and columns. Action to perform on the original two SQL database queries …..............

• Delete the queries
• Disable including the query in report refresh
• Disable loading the query to the data model
• Duplicate the queries

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

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

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

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

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

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

• A. Excel Workbook
• B. Text/CSV
• C. Folder
• D. SharePoint folder
• E. Web

12.1- 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. There are ….............. Different values in State including nulls

• 4
• 65
• 69
• 73