🌍 All Study Guides 📊 Dashboard 📰 Blog 💡 About

Coursera Microsoft Power BI Data Analyst • STUDY MODE

Practice Quiz

QUESTION 1 OF 91

What is the number of columns remaining after you remove the unnecessary ones from the OrderDetails query?

4Correct Answer

QUESTION 2 OF 91

True or False: In the Order Details query, when you remove the anomaly values there are 27distinct, and 6unique values for the UnitPrice column. 

True

FalseCorrect Answer

QUESTION 3 OF 91

In the OrderDetails query, how many rows are there after you remove anomalies?

997 rowsCorrect Answer

999 rows

 996 rows

QUESTION 4 OF 91

What is the reason for using an Inner Join for the merge operation of OrderDetails and Order?

To keep all the rows from the right table.

To keep only matching rows between the two table.Correct Answer

To keep all the rows from the left table.

QUESTION 5 OF 91

By removing data anomalies in the sales data, what impact does this have on the business? 

It improves decision making.Correct Answer

It improves integrity of the data source.

It improves data accuracy.Correct Answer

QUESTION 6 OF 91

True or False: The total number of columns that can be used in all the tables within a dataset is restricted to 16,000 columns. This limitation applies to the Power BI service and the datasets used in Power BI Desktop.  

True Correct Answer

False 

QUESTION 7 OF 91

True or False: Any data source marked as Beta or Preview has limited support and functionality. So don’t make use of it in production environments. 

True Correct Answer

False 

QUESTION 8 OF 91

Which of the following item can be considered as an advantage of a local data set?

Governance 

Promotion

Scalability

Data ControlCorrect Answer

QUESTION 9 OF 91

In which of the following mode(s) does Power BI send a request to the data source and get the result back? Select all that apply:

DualCorrect Answer

Direct QueryCorrect Answer

Import

QUESTION 10 OF 91

As a Data Analyst at Adventure Works, you have been assigned to design an inventory operations system. The data within this system needs to be quantitative, easily searchable, sortable, and suitable for analysis. Which of the following data structures would be the most suitable for fulfilling these requirements?

Unstructured data

Semi structured data

Structured dataCorrect Answer

QUESTION 11 OF 91

You can modify the schedule to fit your needs by choosing the frequency you want the dataset to refresh, such as daily and selecting the time zone you want to use, for example, UTC London.

True Correct Answer

False 

QUESTION 12 OF 91

________ is a Unicode character data string. This can be strings, numbers, or dates represented in a text format.

Binary

TextCorrect Answer

True/False

QUESTION 13 OF 91

Which of the following menu items can be used to delete a specific step in Power Query transformations?

Edit Settings

Delete Until End

DeleteCorrect Answer

QUESTION 14 OF 91

________ rows are instances in a dataset when two or more rows have identical values across all columns.

Empty

Missing

DuplicateCorrect Answer

QUESTION 15 OF 91

By leveraging Power BI’s ________ functionality, you transform the rows containing individual product categories into separate columns

PivotCorrect Answer

Unpivot

Transform

QUESTION 16 OF 91

Which of the following menu items let you add rows from one or more tables to another query or table?

Append QueriesCorrect Answer

Merge Queries

Combine Files

QUESTION 17 OF 91

You import two Microsoft Excel tables named Product and ProductCategory into Power Query. 

ProductID

ProductName

Price

ProductCategoryID

ProductCategory contains following columns:

ProductCategoryName

You want to show the name, price and the name of the category of the products. What should you do?

Choose ProductName, Price and ProductCategoryID from Product table.

MergeProduct and ProductCategory tables by using ProductCategoryID and choose ProductName and Price from Product table and ProductCategoryName field from ProductCategory table.Correct Answer

Append Product and ProductCategory tables.

QUESTION 18 OF 91

In ________, all the records from the left table are included in the result set, along with the matching records from the right table. 

Left Outer JoinCorrect Answer

Full Outer Join

Inner join

QUESTION 19 OF 91

You import two Microsoft Excel tables named Customer and City into Power Query. Two tables have a common column named CityID, and City table contains CityName to show the name of the cities. Your manager asked you to create a query that focuses on customers by cities, so in this case you are going to show only the customers who have City data. What should you do in this case?

Use Full Outer Join in the Join Kind dropdown.

Use Left Outer Join in the Join Kind dropdown. 

Use Inner Join in the Join Kind dropdown.Correct Answer

QUESTION 20 OF 91

Full Outer Join operations can potentially return very large result-sets! 

TrueCorrect Answer

False 

QUESTION 21 OF 91

Which of the following statements can be considered as true?

Numeric joins are more efficient than joins of character strings.Correct Answer

Numbers are more likely to be incorrect entries

Numbers require more storage space than character strings.  

QUESTION 22 OF 91

Which of the following statements about “using short letter codes like state codes for join keys” can be considered as true? Select all that apply:

Costs more storage space when compared to whole numbers.  

Almost the same performance when compared to whole number joins.Correct Answer

Easy to remember and enterCorrect Answer

QUESTION 23 OF 91

Which one is the final stage that brings all the data into the reporting interface, allowing you to filter and visualize the data based on specific criteria?

Transform 

Extract

LoadCorrect Answer

QUESTION 24 OF 91

Which of the following issue can be considered an advantage of using staging in Power BI?

Filtering data

Managing data effectivelyCorrect Answer

Using advanced transformations   

QUESTION 25 OF 91

Which of the following count gives you the total number of different values for a column in a dataset?

Unique

Count

DistinctCorrect Answer

QUESTION 26 OF 91

Which of the following count gives you the total number of values that only appear once?

UniqueCorrect Answer

Count

Distinct  

QUESTION 27 OF 91

________ refers to an individual data point or a group of data points that deviates significantly from the remaining data set.

Mode 

OutlierCorrect Answer

Standard deviation

QUESTION 28 OF 91

Which of the following techniques lets you make updates in the master query, and those changes will be automatically applied to the other queries, instead of modifying transformations individually in each query?

Dataflows

Query referencingCorrect Answer

Query duplicating

QUESTION 29 OF 91

________ is designed specifically for data integration and transformation tasks, providing a self-service environment for business users to create and manage ETL (Extract, Transform, Load) processes.

Query reference 

DataflowsCorrect Answer

Query duplication

QUESTION 30 OF 91

True or False: You can use dataflows in Microsoft Power BI Desktop and Microsoft Power BI Service.

True Correct Answer

False 

QUESTION 31 OF 91

Which of the following techniques can be used when you want your report users to concentrate on a particular product category?

Dynamic Data Retrieval

Data Transformation

FiltersCorrect Answer

QUESTION 32 OF 91

Which of the following features allows you to focus on a specific category of data in your dataset?

FiltersCorrect Answer

Data transformation

Dynamic data retrieval

QUESTION 33 OF 91

Which of the following privacy levels allows data to be shared within a group, granting access to authorized users and maintaining data security within the boundaries?

Private

OrganizationalCorrect Answer

Public

QUESTION 34 OF 91

As a Data Analyst at Adventure Works, you are given 3 Excel files to import. After you imported the files you need to set the data types correctly in Power Query. What should you do?

Use the automatically set data types per each column.

Check automatically set data types per each column and adjust manually if you notice an inconsistent data type.Correct Answer

Set each data type manually in Power Query.

QUESTION 35 OF 91

True or False: Direct Query establishes a live connection to the data source, allowing real-time data analysis, while import options load the data into Power BI for offline analysis. 

TrueCorrect Answer

False 

QUESTION 36 OF 91

Which of the following statements about data sources in Power BI is true?

Power BI only supports data sources that are stored in Excel spreadsheets. 

Power BI can only connect to data sources that have a specific file format.

Power BI supports both cloud-based and on-premises data sources.Correct Answer

QUESTION 37 OF 91

Which of the following best describes a connector in the context of data integration?

A tool which is used to establish a physical connection between two or more data sources.Correct Answer

A connector is a virtual assistant that helps users navigate through data analysis tasks and provides recommendations based on the input.

A connector is a programming language used to write complex algorithms for data transformation and manipulation.

QUESTION 38 OF 91

In  ________, data is stored in memory but can also be retrieved from the original data source. This is useful when you are working with dimension tables, which can be queried with fact tables from the same source.

Import mode

Direct Query mode

Dual ModeCorrect Answer

QUESTION 39 OF 91

________ does not have a predefined structure or format. It is best used for qualitative analysis and usually resides in non-relational databases or unprocessed file formats. 

Unstructured dataCorrect Answer

Semi-structured data 

Structured data

QUESTION 40 OF 91

Which of the following purposes are relevant to the Applied Steps section in the Power Query Editor? Select all that apply:

To undo a step when you make a mistake or change your mind.Correct Answer

To show the sequence of transformations applied to the selected queryCorrect Answer

To preview the data after the applied transformations

To display a list of all the queries in your Power BI project

QUESTION 41 OF 91

Which of the following data errors may cause an inflation in your dataset?

Missing or null values

Inconsistent data types

Duplicate valuesCorrect Answer

QUESTION 42 OF 91

You import two Microsoft Excel tables named SalesCompany and SalesOther into Power Query. 

SalesID

SalesDate

TotalAmount

SalesPersonID

SalesKey

SalesPersonKey

StoreName

Change the column name SalesKey to SalesID and change the column name SalesPersonKey to SalesPersonID in SalesOther table.

Remove StoreName from SalesOther table.

Remove StoreName from SalesOther, change the column name SalesKey to SalesID and change the column name SalesPersonKey to SalesPersonID in SalesOther table.Correct Answer

QUESTION 43 OF 91

You can select ________ to create a new query or table from the merged tables to grow the output horizontally. 

Merge Queries as NewCorrect Answer

Append Queries

Merge Queries

QUESTION 44 OF 91

In which of the join type, only the matching rows from both tables are listed?

Inner JoinCorrect Answer

Full Outer Join

Left Outer Join

QUESTION 45 OF 91

If you want to retrieve a result set that includes all records from the matching tables, even if some rows have not matched to the rows in the other tables yet, you can use a ________ between the tables.

Left Outer Join

Full Outer JoinCorrect Answer

Inner join

QUESTION 46 OF 91

As the data ________  process may involve large volumes of data, you carefully monitor the progress to ensure its successful completion

Extraction

Transformation

LoadingCorrect Answer

QUESTION 47 OF 91

bIn Adventure Works, you receive data from various channels and they cannot be used in their raw form, as they have different formats. You must transform the data and then consolidate it in a unified list. You will only use this data in the ETL process and not show it directly. What should you do?

Use a reference query.

Use a query parameter

Use a staging areaCorrect Answer

QUESTION 48 OF 91

What does Column distribution provide in Power Query?  

Column distribution adds distinct and unique amounts below validity information. Correct Answer

Column distribution provides a comprehensive view of the value distribution within the selected column

Column distribution shows the error and empty row counts and percentages.

QUESTION 49 OF 91

Which of the following definitions best describes the term “anomaly”?

Anomaly is the measure of the variability or spread of the data in relation to the mean.

Anomaly is individual data point or a group of data points that deviates significantly from the remaining data set.

An anomaly represents a single point or a group of points that significantly deviate from other points in the broader context or pattern.Correct Answer

QUESTION 50 OF 91

By establishing a ________, you can establish a connection between an existing query and a new query. Any modifications made to the original query will automatically propagate to the other queries, ensuring consistency and up-to-date information.  

duplicate query 

dataflow

query referenceCorrect Answer

QUESTION 51 OF 91

In ________, you use cloud-based processing capabilities, enabling efficient handling of large datasets and complex transformations.

query references 

dataflowsCorrect Answer

Advanced Editor

QUESTION 52 OF 91

Query parameters in Power BI enable _____ retrieval of specific information from a database, allowing you to define _ or conditions to retrieve only the required data. By utilizing query parameters, Power BI generates and executes _____ queries that fetch a smaller, filtered dataset, saving system resources and processing time.

static, predefined, static

dynamic, criteria, dynamicCorrect Answer

manual, filters, manual

QUESTION 53 OF 91

By ________ expensive operations in your data transformation pipeline, you can optimize the performance and efficiency of your Power BI queries and calculations.

deferring Correct Answer

prioritizing

cancelling

QUESTION 54 OF 91

Data sources for the Power BI service are limited to ________ data sources per user. 

100

1000 Correct Answer

10000 

QUESTION 55 OF 91

Which of the following connectors are supported in Power BI? Select all that apply:

Google AnalyticsCorrect Answer

Salesforce Correct Answer

Excel Online

SQL ServerCorrect Answer

QUESTION 56 OF 91

There are two ways to endorse datasets. makes a dataset available to a broader audience, while is a more selective process that requires special access before other users can view it. 

Certification – promotion

Promotion – certificationCorrect Answer

Accessibility – promotion

QUESTION 57 OF 91

Due to the many features in Import mode that are not supported in the DirectQuery mode, it’s not possible to switch from Import Mode to Direct Query Mode. 

True Correct Answer

False 

QUESTION 58 OF 91

Which of the following is required to initiate a workflow and prompt it to run?

Action

Task

TriggerCorrect Answer

QUESTION 59 OF 91

In Power Query, removing a step in the applied steps list may also remove all subsequent steps in the list, as they are dependent on the previous transformations. 

True  Correct Answer

False 

QUESTION 60 OF 91

You have an Excel file that consists of 3 columns, Month, 2022, and 2023. What do you need to do to convert 2022 and 2023 column values to the row values and create extra rows with this way by combinating month-year and values?

Pivot Columns

Group By

Unpivot ColumnsCorrect Answer

QUESTION 61 OF 91

Which of the following menu items lets you retrieve all records from both tables, regardless of whether they have matching values in the join condition?

Left Outer Join

Inner Join

Full Outer JoinCorrect Answer

QUESTION 62 OF 91

True or False: If items do not have appropriate codes, such as product lot or batch numbers or have short life cycles such as order numbers; then choose identification numbers for the join keys.

True Correct Answer

False 

QUESTION 63 OF 91

________ provides column statistics such as Minimum, Maximum, Average (Mean), Frequently Occurring Values (Mode), and Standard Deviation and in addition value distribution on the selected column.

Column distribution 

Column quality

Column profileCorrect Answer

QUESTION 64 OF 91

________ enable(s) efficient data retrieval and transformation by allowing for dynamic changes, helping you cater to evolving business needs without having to rewrite entire queries.

Parameters Correct Answer

Dynamic data retrieval

Data transformation

QUESTION 65 OF 91

What is the primary benefit of dynamic data retrieval in Power BI?

To enable real-time or near real-time data analysis by fetching the latest data from the source.Correct Answer

To provide historical data snapshots for reporting purposes.

To store and import large volumes of static data for long-term analysis.

QUESTION 66 OF 91

________ in Power BI determine the level of data isolation between different data sources and establish secure boundaries for data interaction within your Power BI environment.

Global options for files

Privacy levelsCorrect Answer

Data load options

QUESTION 67 OF 91

Which of the connection types will you use when trying to connect to an on-premise SQL Server?

Azure SQL database

SQL Server database Correct Answer

SQL Server Analysis Services database

QUESTION 68 OF 91

Which of the following options best represents the following data?

01st January 2001

Date/Time/Timezone

DateCorrect Answer

Date/Time

QUESTION 69 OF 91

True or False: The common field between the tables to be merged and used as the key field in the reference table must be unique.

True Correct Answer

False

QUESTION 70 OF 91

True or False: Reference query will create a new query which is a copy of the original query and contains all the applied steps of the query.

True 

False Correct Answer

QUESTION 71 OF 91

Which of the following items can be considered as a limitation of a dataflow?

Scalability

Data refreshCorrect Answer

Reusability

QUESTION 72 OF 91

Which of the following menu items let you combine columns from one or more tables to another query or table?

Merge QueriesCorrect Answer

Combine Files

Append Queries

QUESTION 73 OF 91

Which of the following operations convert any data, which is organized in a wide format with separate columns for each information (region, country etc.), into a long format where the information-specific data is stacked vertically in a single column?

Pivot

Transform

UnpivotCorrect Answer

QUESTION 74 OF 91

You can select ________ to create a new query or table from the appended output

Append Queries as NewCorrect Answer

Append Queries

Merge Queries

QUESTION 75 OF 91

You import two Microsoft Excel tables named Product and ProductCategory into Power Query. Two tables have a common column named ProductCategoryID, and ProductCategory table contains ProductCategoryName to show the name of the categories. You want to show join the tables; but you noticed that some of the products have NULL values for the ProductCategoryID column and you want to show those products also. What should you do in this case?

Use Full Outer Join in the Join Kind dropdown

Use Inner Join in the Join Kind dropdown

Use Left Outer Join in the Join Kind dropdown Correct Answer

QUESTION 76 OF 91

A join is used to combine information from different sources and integrate data by matching columns, which are considered as ________.

Join types

Join keysCorrect Answer

Join tables

QUESTION 77 OF 91

________ serves as an intermediate storage location for raw or unprocessed data, allowing it to be temporarily stored and prepared for further processing .

Staging areaCorrect Answer

Applied steps list

Merged queries

QUESTION 78 OF 91

By examining various aspects such as completeness, accuracy, uniqueness, and consistency, ________  enables the identification of potential issues and anomalies within the dataset. 

transforming data 

extracting data

profiling dataCorrect Answer

QUESTION 79 OF 91

True or False: Reference queries can contribute to slow data refreshes due to their nature of referencing. When a reference query is refreshed, it needs to ensure that all the referenced queries are also refreshed to maintain data consistency.

True Correct Answer

False 

QUESTION 80 OF 91

Which of the following techniques allows you to connect to data sources, perform data transformations, and also let you publish to the Power BI Service?

DataflowsCorrect Answer

Reference Queries

Duplicate Queries

QUESTION 81 OF 91

True or false: You can use filters when connecting to a database to retrieve specific information, rather than importing the entire dataset and by this way Power BI will only fetch data for that period, saving resources and time.

True 

False Correct Answer

QUESTION 82 OF 91

You are working in Adventure Works as a data analyst and creating a Power BI project to visualize data. You need to set privacy, data load, and file storage options for all files, and these options may change during your design and development. What should you do?

You can set the options for the current file and repeat it for the other files respectively.

You can set global options for the files when you first configure the environment and you can update the settings later if you need to change anything.Correct Answer

You can set global options for the files when you first configure the environment and you can not change it after.

QUESTION 83 OF 91

Which of the best practices can increase performance in Power BI?

Maximize the amount of data that needs to be loaded and processed.

Filter and reduce data early in the transformation process.Correct Answer

Prioritize expensive operations early in the transformation process.

QUESTION 84 OF 91

You must consider the volume and complexity of your data. Some ________ may perform better with large datasets or have optimizations for specific scenarios.

Authentication mechanisms

ConnectorsCorrect Answer

Data sources

QUESTION 85 OF 91

Power BI uses scheduled ________ to automate tasks at specified time intervals.

ActionsCorrect Answer

Triggers

Tasks

QUESTION 86 OF 91

True or False: Data types are defined at the row level and the determined by values of each specific row and may differ by rows.

True Correct Answer

False 

QUESTION 87 OF 91

Using join keys prevent difficulties that may arise from typing detailed information such as category, city or gender incorrectly or using a value that could convey the same meaning. In this way, join keys provide a crucial solution for and .

performance, scalability

efficiency, scalability

classification, categorizationCorrect Answer

QUESTION 88 OF 91

As a Data Analyst at Adventure Works, you have been assigned to integrate an external resource to your existing relational database. Before the operation, you need to assess valid, error and empty rows on each column, which allows you to validate your row values for all tables. Which of the following options do you need to use? 

Column distribution 

Column qualityCorrect Answer

Column profile 

QUESTION 89 OF 91

True or False: Local datasets in Power BI allow you to collaborate and create reports based on the same set of data. You can access and use datasets created by others within their organization, without having to create your own datasets from scratch. This ensures consistency in data analysis and reporting and saves time and effort for everyone involved. 

True 

False  Correct Answer

QUESTION 90 OF 91

As a Data Analyst at Adventure Works, you have taken over a database from one of your suppliers to integrate it into the Adventure Works relational database. However, you have noticed that the data in the source is not well organized, and some columns contain different types of data within a single column. What are the potential issues that may arise in this situation?

Missing values 

Inconsistent data types Correct Answer

Duplicate values 

QUESTION 91 OF 91

Which of the following menu items lets you retrieve the results from the left table, along with the matching records from the right table?

Left Outer Join Correct Answer

Inner Join

Full Outer Join

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?

What is the number of columns remaining after you remove the unnecessary ones from the OrderDetails query?

How confident are you in this answer?

Practice Quiz

What is the number of columns remaining after you remove the unnecessary ones from the OrderDetails query?

True or False: In the Order Details query, when you remove the anomaly values there are 27distinct, and 6unique values for the UnitPrice column.&nbsp;

In the OrderDetails query, how many rows are there after you remove anomalies?

What is the reason for using an Inner Join for the merge operation of OrderDetails and Order?

By removing data anomalies in the sales data, what impact does this have on the business?&nbsp;

True or False: The total number of columns that can be used in all the tables within a dataset is restricted to 16,000 columns. This limitation applies to the Power BI service and the datasets used in Power BI Desktop.&nbsp;&nbsp;

True or False: Any data source marked as Beta or Preview has limited support and functionality. So don’t make use of it in production environments.&nbsp;

Which of the following item can be considered as an advantage of a local data set?

In which of the following mode(s) does Power BI send a request to the data source and get the result back? Select all that apply:

You can modify the schedule to fit your needs by choosing the frequency you want the dataset to refresh, such as daily and selecting the time zone you want to use, for example, UTC London.

________ is a Unicode character data string. This can be strings, numbers, or dates represented in a text format.

Which of the following menu items can be used to delete a specific step in Power Query transformations?

________ rows are instances in a dataset when two or more rows have identical values across all columns.

By leveraging Power BI&#8217;s ________ functionality, you transform the rows containing individual product categories into separate columns

Which of the following menu items let you add rows from one or more tables to another query or table?

You import two Microsoft Excel tables named Product and ProductCategory into Power Query.&nbsp;

In ________, all the records from the left table are included in the result set, along with the matching records from the right table.&nbsp;

Full Outer Join operations can potentially return very large result-sets!&nbsp;

Which of the following statements can be considered as true?

Which of the following statements about “using short letter codes like state codes for join keys” can be considered as true? Select all that apply:

Which one is the final stage that brings all the data into the reporting interface, allowing you to filter and visualize the data based on specific criteria?

Which of the following issue can be considered an advantage of using staging in Power BI?

Which of the following count gives you the total number of different values for a column in a dataset?

Which of the following count gives you the total number of values that only appear once?

________ refers to an individual data point or a group of data points that deviates significantly from the remaining data set.

Which of the following techniques lets you make updates in the master query, and those changes will be automatically applied to the other queries, instead of modifying transformations individually in each query?

________ is designed specifically for data integration and transformation tasks, providing a self-service environment for business users to create and manage ETL (Extract, Transform, Load) processes.

True or False: You can use dataflows in Microsoft Power BI Desktop and Microsoft Power BI Service.

Which of the following techniques can be used when you want your report users to concentrate on a particular product category?

Which of the following features allows you to focus on a specific category of data in your dataset?

Which of the following privacy levels allows data to be shared within a group, granting access to authorized users and maintaining data security within the boundaries?

As a Data Analyst at Adventure Works, you are given 3 Excel files to import. After you imported the files you need to set the data types correctly in Power Query. What should you do?

True or False: Direct Query establishes a live connection to the data source, allowing real-time data analysis, while import options load the data into Power BI for offline analysis.&nbsp;

Which of the following statements about data sources in Power BI is true?

Which of the following best describes a connector in the context of data integration?

In&nbsp; ________, data is stored in memory but can also be retrieved from the original data source. This is useful when you are working with dimension tables, which can be queried with fact tables from the same source.

________ does not have a predefined structure or format. It is best used for qualitative analysis and usually resides in non-relational databases or unprocessed file formats.&nbsp;

Which of the following purposes are relevant to the Applied Steps section in the Power Query Editor? Select all that apply:

Which of the following data errors may cause an inflation in your dataset?

You import two Microsoft Excel tables named SalesCompany and SalesOther into Power Query.&nbsp;

You can select ________ to create a new query or table from the merged tables to grow the output horizontally.&nbsp;

In which of the join type, only the matching rows from both tables are listed?

If you want to retrieve a result set that includes all records from the matching tables, even if some rows have not matched to the rows in the other tables yet, you can use a ________ between the tables.

As the data ________&nbsp; process may involve large volumes of data, you carefully monitor the progress to ensure its successful completion

bIn Adventure Works, you receive data from various channels and they cannot be used in their raw form, as they have different formats. You must transform the data and then consolidate it in a unified list. You will only use this data in the ETL process and not show it directly. What should you do?

What does Column distribution provide in Power Query?&nbsp;&nbsp;

Which of the following definitions best describes the term “anomaly”?

By establishing a ________, you can establish a connection between an existing query and a new query. Any modifications made to the original query will automatically propagate to the other queries, ensuring consistency and up-to-date information.&nbsp;&nbsp;

In ________, you use cloud-based processing capabilities, enabling efficient handling of large datasets and complex transformations.

By ________ expensive operations in your data transformation pipeline, you can optimize the performance and efficiency of your Power BI queries and calculations.

Data sources for the Power BI service are limited to ________ data sources per user.&nbsp;

Which of the following connectors are supported in Power BI? Select all that apply:

There are two ways to endorse datasets. ________ makes a dataset available to a broader audience, while ________ is a more selective process that requires special access before other users can view it.&nbsp;

Due to the many features in Import mode that are not supported in the DirectQuery mode, it’s not possible to switch from Import Mode to Direct Query Mode.&nbsp;

Which of the following is required to initiate a workflow and prompt it to run?

In Power Query, removing a step in the applied steps list may also remove all subsequent steps in the list, as they are dependent on the previous transformations.&nbsp;

You have an Excel file that consists of 3 columns, Month, 2022, and 2023. What do you need to do to convert 2022 and 2023 column values to the row values and create extra rows with this way by combinating month-year and values?

Which of the following menu items lets you retrieve all records from both tables, regardless of whether they have matching values in the join condition?

True or False: If items do not have appropriate codes, such as product lot or batch numbers or have short life cycles such as order numbers; then choose identification numbers for the join keys.

________ provides column statistics such as Minimum, Maximum, Average (Mean), Frequently Occurring Values (Mode), and Standard Deviation and in addition value distribution on the selected column.

________ enable(s) efficient data retrieval and transformation by allowing for dynamic changes, helping you cater to evolving business needs without having to rewrite entire queries.

What is the primary benefit of dynamic data retrieval in Power BI?

________ in Power BI determine the level of data isolation between different data sources and establish secure boundaries for data interaction within your Power BI environment.

Which of the connection types will you use when trying to connect to an on-premise SQL Server?

Which of the following options best represents the following data?

True or False: The common field between the tables to be merged and used as the key field in the reference table must be unique.

True or False: Reference query will create a new query which is a copy of the original query and contains all the applied steps of the query.

Which of the following items can be considered as a limitation of a dataflow?

Which of the following menu items let you combine columns from one or more tables to another query or table?

Which of the following operations convert any data, which is organized in a wide format with separate columns for each information (region, country etc.), into a long format where the information-specific data is stacked vertically in a single column?

You can select ________ to create a new query or table from the appended output

A join is used to combine information from different sources and integrate data by matching columns, which are considered as ________.

________ serves as an intermediate storage location for raw or unprocessed data, allowing it to be temporarily stored and prepared for further processing .

By examining various aspects such as completeness, accuracy, uniqueness, and consistency, ________&nbsp; enables the identification of potential issues and anomalies within the dataset.&nbsp;

True or False: Reference queries can contribute to slow data refreshes due to their nature of referencing. When a reference query is refreshed, it needs to ensure that all the referenced queries are also refreshed to maintain data consistency.

Which of the following techniques allows you to connect to data sources, perform data transformations, and also let you publish to the Power BI Service?

True or false: You can use filters when connecting to a database to retrieve specific information, rather than importing the entire dataset and by this way Power BI will only fetch data for that period, saving resources and time.

You are working in Adventure Works as a data analyst and creating a Power BI project to visualize data. You need to set privacy, data load, and file storage options for all files, and these options may change during your design and development. What should you do?

Which of the best practices can increase performance in Power BI?

True or False: In the Order Details query, when you remove the anomaly values there are 27distinct, and 6unique values for the UnitPrice column.

By removing data anomalies in the sales data, what impact does this have on the business?

True or False: The total number of columns that can be used in all the tables within a dataset is restricted to 16,000 columns. This limitation applies to the Power BI service and the datasets used in Power BI Desktop.

True or False: Any data source marked as Beta or Preview has limited support and functionality. So don’t make use of it in production environments.

By leveraging Power BI’s ________ functionality, you transform the rows containing individual product categories into separate columns

You import two Microsoft Excel tables named Product and ProductCategory into Power Query.

In ________, all the records from the left table are included in the result set, along with the matching records from the right table.

Full Outer Join operations can potentially return very large result-sets!

True or False: Direct Query establishes a live connection to the data source, allowing real-time data analysis, while import options load the data into Power BI for offline analysis.

In ________, data is stored in memory but can also be retrieved from the original data source. This is useful when you are working with dimension tables, which can be queried with fact tables from the same source.

________ does not have a predefined structure or format. It is best used for qualitative analysis and usually resides in non-relational databases or unprocessed file formats.

You import two Microsoft Excel tables named SalesCompany and SalesOther into Power Query.

You can select ________ to create a new query or table from the merged tables to grow the output horizontally.

As the data ________ process may involve large volumes of data, you carefully monitor the progress to ensure its successful completion

What does Column distribution provide in Power Query?

By establishing a ________, you can establish a connection between an existing query and a new query. Any modifications made to the original query will automatically propagate to the other queries, ensuring consistency and up-to-date information.

Data sources for the Power BI service are limited to ________ data sources per user.

There are two ways to endorse datasets. makes a dataset available to a broader audience, while is a more selective process that requires special access before other users can view it.

Due to the many features in Import mode that are not supported in the DirectQuery mode, it’s not possible to switch from Import Mode to Direct Query Mode.

In Power Query, removing a step in the applied steps list may also remove all subsequent steps in the list, as they are dependent on the previous transformations.

By examining various aspects such as completeness, accuracy, uniqueness, and consistency, ________ enables the identification of potential issues and anomalies within the dataset.

Using join keys prevent difficulties that may arise from typing detailed information such as category, city or gender incorrectly or using a value that could convey the same meaning. In this way, join keys provide a crucial solution for and .