Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 59
In the scenario presented in this exercise, what is the purpose of adjusting the Cross-filter direction to Single in Power BI?
A
To enable the addition of more data fields to the model.
B
To manage the storage space required for the data model.
C
To allow for the implementation of many-to-many relationships in the model.
D
To reduce the complexity of the model and limit the direction in which filters are applied.Correct Answer
QUESTION 2 OF 59
Based on your observation of the first ten records, which order has the highest Order Total value?
A
Order with Order ID 2003.Correct Answer
B
Order with Order ID 2007.
C
Order with Order ID 2001.
D
Order with Order ID 2005.
QUESTION 3 OF 59
In the scenario presented in the exercise, why is it beneficial to modify the Customers and Orders relationship from a many-to-many relationship to a one-to-many relationship in Power BI?
A
To improve the visual readability of the data model.
B
To enhance the performance of the data model.Correct Answer
C
To ensure that each customer has only one order.
QUESTION 4 OF 59
What is the primary aim of optimization in the context of Power BI?
A
To collect more data for future analysis to assist with models and reports.
B
To reduce the complexity of data visualization techniques when working with models.
C
To achieve the best performance of data models, reports, and dashboards.Correct Answer
QUESTION 5 OF 59
What is the primary function of the filtering optimization technique in Power BI?
A
To visualize data more effectively to ensure that it is clear and relevant.
B
To standardize the format of the data to enhance its clarity and relevance.
C
To enhance the clarity and relevance of data by removing unnecessary noise.Correct Answer
QUESTION 6 OF 59
Which of the following factors contribute to performance issues when working with many-to-many relationships in Power BI? Select all that apply.
A
The presence of large volumes of data.Correct Answer
B
The number of calculated columns.
C
The complexity of the data model.Correct Answer
D
The use of bi-directional filters.Correct Answer
QUESTION 7 OF 59
How does high cardinality impact the performance of your Power BI reports?
A
It slows down the processing of queries.Correct Answer
B
It simplifies the structure of the data.
C
It enhances the report’s responsiveness.
QUESTION 8 OF 59
How does performance optimization primarily improve decision-making?
A
By enabling faster analysis of trends through swiftly loading reports.Correct Answer
B
By simplifying complex DAX calculations, making it easier to interpret data.
C
By making Microsoft Power BI reports more visually appealing.
D
By enhancing user experience.
QUESTION 9 OF 59
How does indexing optimize the data analysis process in Microsoft Power BI?
A
By organizing data alphabetically
B
By standardizing the data format
C
By providing faster access to specific data pointsCorrect Answer
D
By narrowing down the dataset to only relevant information
QUESTION 10 OF 59
What does the term “metadata” refer to in the context of Power BI?
A
It refers to the data that describes and gives information about other data.Correct Answer
B
It refers to the customized labels and annotations added to enhance data reports.
C
It refers to the highest level of data security.
D
It refers to the summarized version of the data used for visualization.
QUESTION 11 OF 59
What effect does a bi-directional filter have in a many-to-many relationship in Power BI?
A
It automatically reduces the size of the data model.
B
It allows the filter context to flow in either direction.Correct Answer
C
It prevents any filtering of data.
D
It reduces the complexity of the data model.
QUESTION 12 OF 59
What is the purpose of the Column Quality feature in Power Query Editor in Power BI?
A
It visualizes the frequency and distribution of values within your columns.
B
It provides statistical measures such as count, unique count, average, etc. of your columns.
C
It helps to categorize your data.
D
It allows you to assess the quality of data in your columns by quantifying the percentage of valid, erroneous, or empty entries.Correct Answer
QUESTION 13 OF 59
Which of the following statements accurately describes table storage in DirectQuery?
A
Optimizing table storage allows you to import all data in Microsoft Power BI for fast performance.
B
Optimizing table storage allows you to store detailed data for all queries.
C
Optimizing table storage allows you to import selected tables to the memory of Power BI for faster query performance.Correct Answer
QUESTION 14 OF 59
Your DirectQuery report is slow in loading and processing data. What technique can you use to enhance report performance?
A
Import entire data into Power BI.
B
Table storage optimization.Correct Answer
C
Data transformation in the query editor.
QUESTION 15 OF 59
True or False: DirectQuery mode automatically optimizes the data model and minimizes the queries sent to the underlying data source.
A
True
B
FalseCorrect Answer
QUESTION 16 OF 59
You are working in a multi-national retail company who need to build a real-time sales dashboard. The sales transactions are recorded in a centralized SQL database which could contain hundreds of millions of rows. DirectQuery is the best option for the current analysis rather than importing the data. Because you are using DirectQuery, which of the following options should you select in order to optimize the query performance and user experience? Select all that apply.
A
You can create aggregations and aggregated tables.Correct Answer
B
You can create complex DAX logic within your data model to build user defined measures.
C
You can avoid using too many visuals while creating a report.Correct Answer
D
You can eliminate unnecessary columns from the data tables.Correct Answer
QUESTION 17 OF 59
______________ and __________________ are the two limitations of using DirectQuery in Power BI desktop.
A
Modeling, import
B
Visualization, DAXCorrect Answer
C
Date dimension, network speed
QUESTION 18 OF 59
Which of the following statements is true regarding data transformation in DirectQuery?
A
Data transformation can be applied to the data in Power BI before sending queries to the data source.
B
Data transformation can only be applied to import mode.
C
Data transformation is not fully supported in DirectQuery mode.Correct Answer
QUESTION 19 OF 59
Why is it important to optimize queries when connecting to the data source via DirectQuery in Power BI?
A
To improve query performance, response time, and visual refreshCorrect Answer
B
To reduce the number of data sources used in DirectQuery mode.
C
To ensure real-time connectivity is established
QUESTION 20 OF 59
In DirectQuery sourced data, when is it suitable to use dual storage mode in Power BI?
A
When performing performance optimization via query reduction option.
B
When creating aggregated tables and import to Power BI memory.Correct Answer
C
When importing the entire dataset to the memory engine of Power BI
QUESTION 21 OF 59
What is the primary benefit of creating aggregations when working with large datasets in Microsoft Power BI?
A
Faster query execution.Correct Answer
B
Enhanced visualizations.
C
Real-time data streaming.
QUESTION 22 OF 59
What is the total number of rows in the original Sales table and the SalesAgg aggregated table respectively?
A
990 and 999.
B
57851 and 999.
C
57851 and 990.Correct Answer
QUESTION 23 OF 59
Why is it important to duplicate the source table before creating aggregated tables in DirectQuery connectivity?
A
Duplicating the source table preserves the original table for other analytical needs.
B
Duplicating the source table allows for faster data import.
C
Duplicating the source table improves the quality of the aggregated data.Correct Answer
QUESTION 24 OF 59
True or False: You can create aggregations by defining SQL statement in the source data and then import the table to Power BI.
A
TrueCorrect Answer
B
False
QUESTION 25 OF 59
True or False: When creating an aggregation, you must reference the data model’s fact table to keep the original table intact.
A
TrueCorrect Answer
B
False
QUESTION 26 OF 59
Which feature stores pre-aggregated data for improved query performance when Microsoft Power BI is connected to DirectQuery?
A
Aggregated table.Correct Answer
B
DAX measure.
C
Calculated column.
QUESTION 27 OF 59
When connecting to DirectQuery in Microsoft Power BI, which of the following can be used to create aggregated tables? Select all that apply.
A
Data Analysis Expressions
B
SQL queriesCorrect Answer
C
Using the Model view of Power BI.
D
Power query editorCorrect Answer
QUESTION 28 OF 59
You have created an aggregation from a fact table connected to Microsoft Power BI via DirectQuery. With the aggregated table created, you then configured the storage mode of the table and established relationships with the other tables of data model. Which of the following steps must be completed before utilizing the aggregation in your reports?
A
Managing aggregation in Power BI.Correct Answer
B
Performing transformation operations on the aggregation.
C
Creating calculations on the aggregation.
QUESTION 29 OF 59
Which of the following is the recommended approach while selecting the columns for aggregated tables?
A
Include all columns from the source fact table.
B
Include only primary key columns.
C
Include columns that fulfill the level of granularity needed for analysis.Correct Answer
QUESTION 30 OF 59
You have a Microsoft Power BI report with a DirectQuery connection to a large Sales dataset. Business users frequently query total sales and quantities by various categories and months. Which option offers the best approach for optimizing performance while addressing user needs?
A
Import the entire sales table to Power BI memory.
B
Create an aggregated table for total sales and quantities grouped by category and date.Correct Answer
C
Create an aggregated table for total sales and categories grouped by quantity and date.
QUESTION 31 OF 59
How does performance optimization in Power BI influence decision-making?
A
It introduces new ways to present data.
B
It facilitates more timely and informed decisions due to faster data analysis.Correct Answer
C
It ensures that reports are visually appealing while maintaining data integrity.
D
It reduces the number of decisions to be made.
QUESTION 32 OF 59
Sales teams at Adventure Works have been entering date information into the system using various formats. This inconsistency has caused issues in past reports, leading to incorrect analyses. The management wants to ensure all dates are standardized for a comprehensive year-end review, and they’ve turned to you, the data analyst for a solution. Which optimization technique should you use?
A
Data transformation.Correct Answer
B
Indexing by date.
C
Filtering out older dates.
D
Sorting by date.
QUESTION 33 OF 59
Which of the following descriptions best describes cardinality in the context of Power BI?
A
The relationship between two tables in a data model.
B
The method used to transform data in Power BI.
C
The sequence in which data is loaded into Power BI.
D
The number of distinct values in a column.Correct Answer
QUESTION 34 OF 59
What is the potential downside of using bi-directional filters when managing large data volumes in Power BI?
A
They might lead to ambiguous relationships in complex models.
B
They can be resource-intensive, impacting performance.Correct Answer
C
They limit the number of tables that can be imported.
QUESTION 35 OF 59
Your organization has data stored on-premises SQL Server and in cloud-based Azure SQL databases. You want to implement aggregations in Power BI to improve query performance in DirectQuery mode. What do you need to consider in terms of data sources?
A
You can only use cloud-based Azure SQL database as data source for aggregations.
B
You can use both on-premises and cloud databases as data sources for aggregations.Correct Answer
C
You can only use the on-premises SQL Server database as data source for aggregations.
QUESTION 36 OF 59
True or False: For real-time data analysis and connectivity to an on-premises SQL Server, DirectQuery mode without aggregation is more suitable for improved query performance.
A
True
B
FalseCorrect Answer
QUESTION 37 OF 59
True or False: When working on a Power BI report connected to a DirectQuery sourced Fact table, you cannot create complex logic in DAX.
A
True Correct Answer
B
False
QUESTION 38 OF 59
True or False: In DirectQuery sourced Power BI report, the data is stored in the source server. You can import selected or entire data to Power BI memory.
A
TrueCorrect Answer
B
False
QUESTION 39 OF 59
In the context of DirectQuery performance optimization, which of the following are the characteristics of the optimized data model?
A
A model with only the columns and fields required for analysis.Correct Answer
B
A model with a list of custom measures to answer analytical questions.
C
A model that contains fewer relationships.
QUESTION 40 OF 59
Which techniques might you employ to optimize data performance in Power BI? Select all that apply.
A
Adding borders around data points to distinguish them for faster decision-making.
B
Applying sorting to data to group it alphabetically and make it easier to read and interpret.Correct Answer
C
Filtering data to focus on specific regions or details, removing unnecessary information.Correct Answer
D
Changing the font style of data points for a faster performance rendering.
QUESTION 41 OF 59
Which of the following is a recommended strategy for managing high cardinality?
A
Expanding data columns to include more details.
B
Frequently changing the data type of columns.
C
Summarization of data during transformation.Correct Answer
QUESTION 42 OF 59
Which of the following components of Power BI is responsible for managing aggregations? Select all that apply.
A
Power Query
B
The Model viewCorrect Answer
C
The Data PaneCorrect Answer
D
Underlying data sources.
QUESTION 43 OF 59
The performance of DirectQuery connection in Power BI depends on which of the following? Select all that apply.
A
Power BI’s memory limit.
B
The size of the dataset.Correct Answer
C
The server configuration.Correct Answer
D
The data model relationships.
QUESTION 44 OF 59
In DirectQuery connectivity, where is the data stored?
A
In the data source storageCorrect Answer
B
In Power BI cloud storage.
C
In Power BI memory engine.
QUESTION 45 OF 59
Which of the following options can you configure in the Power BI desktop interface to reduce the number of queries sent to the database in DirectQuery mode? Select all that apply.
A
Configure table storageCorrect Answer
B
Configure query reduction optionCorrect Answer
C
Configure Server specification
D
Configure SQL queries
QUESTION 46 OF 59
Which of the following are benefits provided by performance optimization in Power BI? Select all that apply.
A
Improved user experience with smooth and swift report loading.Correct Answer
B
Enhanced speed and efficiency in executing queries.Correct Answer
C
Reduces the need to clean and pre-process data before importing to Power BI.
D
More informed and timely decision-making.Correct Answer
QUESTION 47 OF 59
You need a solution to pinpoint the required information rapidly in your datasets. In Power BI, which optimization technique should you use to accomplish this?
A
IndexingCorrect Answer
B
Filtering
C
Sorting
D
Data visualization
QUESTION 48 OF 59
Why is cross-filter direction important in Power BI relationships?
A
It influences the sort order of data in a table.
B
It impacts the data refresh intervals.
C
It defines how filters are applied across related tables.Correct Answer
QUESTION 49 OF 59
In DirectQuery connectivity which type of data source is typically used to create aggregations?
A
Only databases like SQL, Azure SQL.
B
All types of flat files (CSV).
C
Any data source supported by DirectQuery.Correct Answer
QUESTION 50 OF 59
You are designing a Power BI solution for clients needing real-time access to their on-premises SQL Server database. Which connection mode should you choose?
A
Mix mode
B
Import mode
C
DirectQuery modeCorrect Answer
QUESTION 51 OF 59
You’ve identified a need for performance optimization in Power BI. Why is this optimization crucial when dealing with vast data sets?
A
It streamlines data storage without impacting performance.
B
It ensures that reports and dashboards run as smoothly and quickly as possible even as data grows.Correct Answer
C
It allows more customization options in the Power BI dashboard.
D
It enhances Power BI’s ability to work alongside other tools.
QUESTION 52 OF 59
Why might using bi-directional filters in Power BI become resource-intensive in certain situations?
A
They occasionally trigger unnecessary calculations in DAX formulas.
B
They make simultaneous connections to all related tables.
C
They allow the filter context to flow in both directions, complicating the data model.Correct Answer
QUESTION 53 OF 59
You are addressing a client’s requirement for real-time access to an on-premises SQL Server and optimizing query efficiency. Which of the following actions must you perform to achieve this task? Select all that apply.
A
Query the original data source for all analytical needs.
B
Connect Power BI via DirectQuery mode.Correct Answer
C
Import the data to Power BI memory.
D
Create aggregations based on DirectQuery sourced table.Correct Answer
QUESTION 54 OF 59
Which of the following best describes the limitation of DirectQuery connectivity in Power BI?
A
High memory consumption.
B
Limited data transformation in Power Query editor.Correct Answer
C
Inability to create relationships between the data tables.
QUESTION 55 OF 59
True or False: Limiting the number of visuals and filters in Power BI report helps you optimize the report performance when connected to DirectQuery sourced datasets.
A
TrueCorrect Answer
B
False
QUESTION 56 OF 59
You have created an aggregation from a DirectQuery-sourced sales table, but you cannot use the aggregation in Power BI. Which of the following steps are missing before utilizing aggregations in your reports? Select all that apply.
A
Configure the storage mode of the aggregated table.Correct Answer
B
Manage your aggregations in Power BI desktop.Correct Answer
C
Data transformation in the query editor.
D
Build the required relationships in the Model view.Correct Answer
QUESTION 57 OF 59
Why is high cardinality a possible concern for data analysts?
A
It presents data in the finest granularity.
B
It can slow down the performance of Power BI reports.Correct Answer
C
It reduces the size of the data model.
D
It creates more direct relationships between tables in the data model.
QUESTION 58 OF 59
You are developing a Power BI solution for a client who requires real-time analysis based on a cloud-based database. While designing the solution you need to connect Power BI to the database via DirectQuery. Which of the following could be a constraint in developing this solution? Select all that apply.
A
Slower query performance compared to import mode.Correct Answer
B
An inability to perform complex custom measures using DAX expressions.Correct Answer
C
A limited ability to establish relationships between the data tables.
D
A reduced ability to perform complex data transformation within Power BI.Correct Answer
QUESTION 59 OF 59
On creating an aggregated table from a DirectQuery sourced table, you need to configure the storage mode of aggregated table. What are the remaining two steps that you need to accomplish before using the aggregation in your reports?
A
Manage relationships and create DAX measures.
B
Perform transformations on aggregated table and build relationships.
C
Build relationships and manage aggregations.Correct Answer
D
Google Advanced Data Analytics
E
Google Cybersecurity Professional Certificate
F
Meta Marketing Analytics Professional Certificate
G
Google Digital Marketing & E-commerce Professional Certificate
H
Google UX Design Professional Certificate
I
Meta Social Media Marketing Professional Certificate
J
Google Project Management Professional Certificate
K
Meta Front-End Developer Professional Certificate
Ready to test your recall?
In the scenario presented in this exercise, what is the purpose of adjusting the Cross-filter direction to Single in Power BI?
A
To enable the addition of more data fields to the model.
B
To manage the storage space required for the data model.
C
To allow for the implementation of many-to-many relationships in the model.
D
To reduce the complexity of the model and limit the direction in which filters are applied.