🌍 All Study Guides 📊 Dashboard 📰 Blog 💡 About

Coursera Microsoft Power BI Data Analyst • STUDY MODE

Practice Quiz

QUESTION 1 OF 26

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

All connectors support DirectQuery mode.

The connector will default to Import mode.Correct Answer

The connector will default to Dual mode.

QUESTION 2 OF 26

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.

Identifying the required data for the analysisCorrect Answer

Inspecting the data to ensure it meets requirementsCorrect Answer

Connecting to the data sourcesCorrect Answer

Identifying which data sources can provide the required dataCorrect Answer

QUESTION 3 OF 26

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

Dual modeCorrect Answer

DirectQuery mode

Import modeCorrect Answer

QUESTION 4 OF 26

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

The dataset is accessible at high speeds.

The dataset acts as a single source of truth.Correct Answer

The dataset can scale as the organization grows.Correct Answer

The dataset is accessible from both office and remote locations.Correct Answer

QUESTION 5 OF 26

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

True

FalseCorrect Answer

QUESTION 6 OF 26

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

Prepare and model the dataCorrect Answer

Import and visualize the data using dataflows

Visualize and analyze the dataCorrect Answer

Deploy and maintain assetsCorrect Answer

QUESTION 7 OF 26

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

Identify which data is requiredCorrect Answer

Create the required data

Connect to the data sourcesCorrect Answer

Identify which data sources can provide the dataCorrect Answer

QUESTION 8 OF 26

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

DirectQuery mode

Import modeCorrect Answer

Dual modeCorrect Answer

QUESTION 9 OF 26

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

Column profile

Column qualityCorrect Answer

Column distribution

QUESTION 10 OF 26

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.

Edit the Changed Type step in the Applied Steps list.Correct Answer

Append a new step to the Applied Steps list to change the data type.

Remove the step from the Applied Steps list.Correct Answer

QUESTION 11 OF 26

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

TrueCorrect Answer

False

QUESTION 12 OF 26

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.

Column quality will show 10% of values as Error.Correct Answer

You can replace the value using the Replace Values feature.

You can replace the value using the Replace Errors feature.Correct Answer

Column profile will show 10% of values as Error.

QUESTION 13 OF 26

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

True

FalseCorrect Answer

QUESTION 14 OF 26

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

To filter data dynamically from a data sourceCorrect Answer

To dynamically add a new visualization to a report

To dynamically switch between a test and production data sourceCorrect Answer

To dynamically append a value to the dataset

QUESTION 15 OF 26

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

There is limited visibility of dependencies between dataflows.Correct Answer

To refresh more than 10 dataflows, a Premium subscription is required.Correct Answer

The maximum number of linked dataflows is 32.Correct Answer

Dataflows are limited to small volumes of data.

QUESTION 16 OF 26

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

Column Distribution shows all values are unique.

Column Profile shows that the total rows is equal to 500.Correct Answer

Column Quality shows data is 100% valid.Correct Answer

Column Data Types are correct.Correct Answer

QUESTION 17 OF 26

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

To optimize visualizations

To ensure effective decision-makingCorrect Answer

To ensure correct column data types

To help ensure accurate reportingCorrect Answer

QUESTION 18 OF 26

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?

Many-to-many

One-to-one

Many-to-oneCorrect Answer

QUESTION 19 OF 26

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.

Inner JoinCorrect Answer

Left Outer JoinCorrect Answer

Right OuterJoin

Full Outer Join

QUESTION 20 OF 26

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

True

FalseCorrect Answer

QUESTION 21 OF 26

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?

Profit = SalePrice / Cost

SalePrice / Cost

SalePrice – Cost

Profit = SalePrice – CostCorrect Answer

QUESTION 22 OF 26

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

TrueCorrect Answer

False

QUESTION 23 OF 26

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?

0.25 * SalesAmount

TaxAmount = 0.25 * SalesAmount

TaxAmount = 25 * SalesAmountCorrect Answer

25 * SalesAmount

QUESTION 24 OF 26

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.

Transformations copied from the original query will execute in both queries.Correct Answer

Changes to transformations in the original query will not impact the duplicate query.Correct Answer

Changes to transformations in the original query will automatically update the duplicate query.

Transformations copied from the original query will execute only in the original query.

QUESTION 25 OF 26

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?

Left Outer JoinCorrect Answer

Inner Join

Right Outer Join

Full Outer Join

QUESTION 26 OF 26

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?

Many-to-many

Many-to-one (Employees to Keycards)

One-to-oneCorrect Answer

One-to-many (Employees to Keycards)

Google Advanced Data Analytics

Google Cybersecurity Professional Certificate

Meta Marketing Analytics Professional Certificate

Google Digital Marketing & E-commerce Professional Certificate

Google UX Design Professional Certificate

Meta Social Media Marketing Professional Certificate

Google Project Management Professional Certificate

Meta Front-End Developer Professional Certificate

Ready to test your recall?

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

All connectors support DirectQuery mode.

The connector will default to Import mode.

The connector will default to Dual mode.

How confident are you in this answer?

Practice Quiz

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

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.

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

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

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

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

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

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

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

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.

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

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.

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

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

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

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

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

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?

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

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?

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

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?

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.

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?

Adventure Works&#8217; 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?

Ready to test your recall?

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?