microsoft pl-300 exam preparation and practice coursera week 1 answers

Self-review: What did you learn?

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

  • The connector will default to Import mode.

  • All connectors support DirectQuery mode.
  • The connector will default to Dual mode.

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.

  • Connecting to the data sources
  • Identifying the required data for the analysis
  • Inspecting the data to ensure it meets requirements
  • Identifying which data sources can provide the required data

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

  • DirectQuery mode
  • Import mode
  • Dual mode

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

  • The dataset can scale as the organization grows.
  • The dataset is accessible from both office and remote locations.
  • The dataset acts as a single source of truth.
  • The dataset is accessible at high speeds.

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

  • True
  • False

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

  • Column quality

  • Column distribution
  • Column profile

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

  • Append a new step to the Applied Steps list to change the data type.
  • Remove the step from the Applied Steps list.
  • Edit the Changed Type step in the Applied Steps list.

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

  • True

  • False

9.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 profile will show 10% of values as Error.
  • You can replace the value using the Replace Errors feature.

  • You can replace the value using the Replace Values feature.
  • Column quality will show 10% of values as Error.

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

  • True
  • False

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

  • One-to-one
  • Many-to-many

12. 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 Join
  • Left Outer Join
  • Right OuterJoin
  • Full Outer Join

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

  • True
  • False

14. 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
  • Profit = SalePrice / Cost
  • SalePrice / Cost

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

  • True
  • False

Leave a Reply