Question 1

When a connector in Microsoft Power BI does not support DirectQuery mode, which of the following statements is true?

Accepted Answer

The connector will default to Import mode. (CORRECT)

Question 2

At the beginning of the data analysis process, which of the following activities are important to ensuring a successful analysis outcome? Select all that apply.

Accepted Answer

Identifying the required data for the analysis, Inspecting the data to ensure it meets requirements, Connecting to the data sources, Identifying which data sources can provide the required data (CORRECT)

Question 3

Which of the following storage modes will copy data to Microsoft Power BI? Select all that apply.

Accepted Answer

Dual mode, Import mode (CORRECT)

Question 4

Which of the following are the benefits of using a shared dataset? Select all that apply.

Accepted Answer

The dataset acts as a single source of truth. The dataset can scale as the organization grows. The dataset is accessible from both office and remote locations. (CORRECT)

Question 5

True or False: A shared dataset is more secure than a local dataset.

Accepted Answer

False (CORRECT)

Question 6

Which of the following categories are assessed by the Exam PL-300? Select all that apply.

Accepted Answer

Prepare and model the data, Visualize and analyze the data, Deploy and maintain assets (CORRECT)

Question 7

Which of the following is considered a key responsibility of a data analyst? Select all that apply.

Accepted Answer

Identify which data is required, Connect to the data sources, Identify which data sources can provide the data (CORRECT)

Question 8

Which of the following storage modes will store data in Microsoft Power BI? Select all that apply.

Accepted Answer

Import mode, Dual mode (CORRECT)

Question 9

Which of the following data profiling tools allows you to inspect the percentage of valid, error, and empty data in a column?

Accepted Answer

Column quality (CORRECT)

Question 10

You’re preparing a dataset for import into Microsoft Power BI and have accidentally changed a column to the wrong data type. What is the next action you can take to correct the mistake? Select all that apply.

Accepted Answer

Edit the Changed Type step in the Applied Steps list. Remove the step from the Applied Steps list. (CORRECT)

Question 11

True or False: Column profile displays the minimum and maximum values within the first 1000 rows for a specific column.

Accepted Answer

True (CORRECT)

Question 12

You are importing a dataset of 10 rows that contains a Date type column. One of the values in the Date column is Bicycle. Which of the following statements is correct? Select all that apply.

Accepted Answer

Column quality will show 10% of values as Error. You can replace the value using the Replace Errors feature. (CORRECT)

Question 13

True or False: Distinct values refer to the number of values that only occur once in the dataset.

Accepted Answer

False (CORRECT)

Question 14

In which of the following scenarios can you use parameter values? Select all that apply.

Accepted Answer

To filter data dynamically from a data source, To dynamically switch between a test and production data source (CORRECT)

Question 15

Which of the following are limitations that must be considered when using dataflows?

Accepted Answer

There is limited visibility of dependencies between dataflows. To refresh more than 10 dataflows, a Premium subscription is required.  The maximum number of linked dataflows is 32. (CORRECT)

Question 16

You are importing a dataset containing 500 rows. Which of the following should be validated before importing the data? Select all that apply.

Accepted Answer

Column Profile shows that the total rows is equal to 500. Column Quality shows data is 100% valid. Column Data Types are correct. (CORRECT)

Question 17

Why is it important to ensure that data is good quality? Select all that apply.

Accepted Answer

To ensure effective decision-making, To help ensure accurate reporting (CORRECT)

Question 18

The sales team at Adventure Works has two tables of data for tracking bicycle sales: Sales and Product. Each row in the Sales table is associated with one of the bicycles in the Product table. Which of the following cardinalities is most suitable between the Sales and the Product table?

Accepted Answer

Many-to-one (CORRECT)

Question 19

The inventory team at Adventure Works has two tables of data for tracking inventory levels: Stock and Product. If a product is not in stock, there is no row in the Stock table for the product. The team wants to merge the tables into a single table containing products that are in stock. If Stock is the left table and Product is the right table, which of the following join types will achieve the desired outcome? Select all that apply.

Accepted Answer

Inner Join, Left Outer Join (CORRECT)

Question 20

True or False: When performing an append query, the columns of both tables must be the same.

Accepted Answer

False (CORRECT)

Question 21

You are importing a data source containing two columns: SalePrice and Cost. You need to create a calculated column to represent the Profit. Which of the following DAX queries will achieve the desired result?

Accepted Answer

Profit = SalePrice - Cost (CORRECT)

Question 22

True or False: Reducing columns and rows will reduce the required storage space for a table.

Accepted Answer

True (CORRECT)

Question 23

You need to create a calculated column for the tax amount per sale. The tax amount is 25% of the SalesAmount column. Which of the following DAX formulas will create the column?

Accepted Answer

TaxAmount = 25 * SalesAmount (CORRECT)

Question 24

You have created a duplicate query in Microsoft Power BI from a query that contained transformations. Which of the following statements is true? Select all that apply.

Accepted Answer

Transformations copied from the original query will execute in both queries, Changes to transformations in the original query will not impact the duplicate query. (CORRECT)

Question 25

You have a Product table as a left table and a Category table as a right table. You want to merge these tables so that you have a table containing only products and each product row containing its category name or null. Which of the following joins is most suitable?

Accepted Answer

Left Outer Join (CORRECT)

Question 26

Left Outer Join (CORRECT)

Accepted Answer

One-to-one (CORRECT)

COURSE 8 – MICROSOFT PL-300 EXAM PREPARATION AND PRACTICE

Module 1: Preparing Data

MICROSOFT POWER BI DATA ANALYST PROFESSIONAL CERTIFICATE

Complete Coursera Study Guide

TABLE OF CONTENT

INTRODUCTION – Preparing data

Learning Objectives

SELF-REVIEW: WHAT DID YOU LEARN? 1

1. When a connector in Microsoft Power BI does not support DirectQuery mode, which of the following statements is true?

2. At the beginning of the data analysis process, which of the following activities are important to ensuring a successful analysis outcome? Select all that apply.

3. Which of the following storage modes will copy data to Microsoft Power BI? Select all that apply.

4. Which of the following are the benefits of using a shared dataset? Select all that apply.

5. True or False: A shared dataset is more secure than a local dataset.

6. Which of the following categories are assessed by the Exam PL-300? Select all that apply.

7. Which of the following is considered a key responsibility of a data analyst? Select all that apply.

8. Which of the following storage modes will store data in Microsoft Power BI? Select all that apply.

SELF-REVIEW: WHAT DID YOU LEARN? 2

1. Which of the following data profiling tools allows you to inspect the percentage of valid, error, and empty data in a column?

2. You’re preparing a dataset for import into Microsoft Power BI and have accidentally changed a column to the wrong data type. What is the next action you can take to correct the mistake? Select all that apply.

3. True or False: Column profile displays the minimum and maximum values within the first 1000 rows for a specific column.

4. You are importing a dataset of 10 rows that contains a Date type column. One of the values in the Date column is Bicycle. Which of the following statements is correct? Select all that apply.

5. True or False: Distinct values refer to the number of values that only occur once in the dataset.

6. In which of the following scenarios can you use parameter values? Select all that apply.

7. Which of the following are limitations that must be considered when using dataflows?

8. You are importing a dataset containing 500 rows. Which of the following should be validated before importing the data? Select all that apply.

9. Why is it important to ensure that data is good quality? Select all that apply.

SELF-REVIEW: WHAT DID YOU LEARN? 3

1. The sales team at Adventure Works has two tables of data for tracking bicycle sales: Sales and Product. Each row in the Sales table is associated with one of the bicycles in the Product table. Which of the following cardinalities is most suitable between the Sales and the Product table?

3. True or False: When performing an append query, the columns of both tables must be the same.

4. You are importing a data source containing two columns: SalePrice and Cost. You need to create a calculated column to represent the Profit. Which of the following DAX queries will achieve the desired result?

5. True or False: Reducing columns and rows will reduce the required storage space for a table.

6. You need to create a calculated column for the tax amount per sale. The tax amount is 25% of the SalesAmount column. Which of the following DAX formulas will create the column?

7. You have created a duplicate query in Microsoft Power BI from a query that contained transformations. Which of the following statements is true? Select all that apply.

8. You have a Product table as a left table and a Category table as a right table. You want to merge these tables so that you have a table containing only products and each product row containing its category name or null. Which of the following joins is most suitable?

9. Adventure Works’ head office must keep track of employee keycards. For security reasons, each employee can only have one keycard. There are two tables: Employees and Keycards. What is the most suitable relationship for these two tables?

CONCLUSION – Preparing data

Quiztudy Top Courses

Popular in Coursera

Mood Zone for Studying & Relaxing