Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DataAnalyticsModule4

Total questions: 250

Worksheet time: 2hrs 5mins

Name
Class
Date
1.

Which of the following is NOT a benefit of data modelling as mentioned in the material?

a)

Accuracy in results

b)

Faster queries and refresh

c)

Increased data redundancy

d)

Easier maintenance & scalability

2.

Why is raw data not ready for reporting, according to the material?

a)

Raw data is always accurate

b)

Raw data is already formatted for reports

c)

Raw data needs to be modelled to ensure accuracy and usability

d)

Raw data is only used for backups

3.

Which of the following tasks is simplified by data modelling?

a)

Report building

b)

Data deletion

c)

Hardware installation

d)

Software licensing

4.

What is the primary purpose of a schema in data modeling?

a)

To define the logical structure of how tables are related

b)

To store raw data only

c)

To create visualizations

d)

To manage user permissions

5.

How does a schema influence Power BI?

a)

It shapes how Power BI understands and processes data

b)

It determines the color scheme of reports

c)

It controls the export options

d)

It sets the default language

6.

What is the role of dimension tables in a schema?

a)

To provide descriptive attributes

b)

To store only numerical data

c)

To manage database security

d)

To generate random data

7.

Which of the following is a benefit of having a good schema in data management?

a)

Increases data redundancy

b)

Simplifies complex datasets

c)

Makes queries slower

d)

Limits analysis flexibility

8.

Which of the following is NOT listed as a benefit of good schemas?

a)

Reduces ambiguity in relationships

b)

Improves query performance

c)

Increases data duplication

d)

Provides flexibility for analysis

9.

A company wants to design a data warehouse that is simple and efficient for querying. Based on best practices, which schema should they choose and why?

a)

Star Schema, because it is simple and efficient

b)

Snowflake Schema, because it is more complex

c)

Star Schema, because it uses normalized dimensions

d)

Snowflake Schema, because it avoids central fact tables

10.

Which table in the diagram is most likely to be the fact table in a star schema?

a)

FactResellerSales

b)

DimProduct

c)

DimDate

d)

DimEmployee

11.

Which of the following is a dimension table in the provided star schema diagram?

a)

FactResellerSales

b)

DimProduct

c)

SalesAmount

d)

OrderQuantity

12.

Suppose you need to find the total sales amount for each reseller. Which keys would you use to join the relevant tables?

a)

ProductKey and EmployeeKey

b)

ResellerKey and SalesOrderNumber

c)

ResellerKey and ResellerAlternateKey

d)

DateKey and OrderDateKey

13.

What is a drawback of using the Snowflake Schema?

a)

A. Fewer joins, faster queries

b)

B. More joins, slower queries

c)

C. No relationship propagation issues

d)

D. Simplified data structure

14.

When is it most appropriate to use a Snowflake Schema?

a)

A. When report optimization is needed

b)

B. When data storage optimization is needed

c)

C. When minimizing joins is important

d)

D. When denormalization is required

15.

Which of the following is NOT a drawback of the Snowflake Schema?

a)

A. More joins lead to slower queries

b)

B. Relationship propagation issues

c)

C. Data storage optimization

d)

D. Increased query complexity

16.

Why might queries be slower in a Snowflake Schema compared to other schemas?

a)

A. Because there are fewer tables to join

b)

B. Because there are more joins required

c)

C. Because data is denormalized

d)

D. Because there are no relationships

17.

What is the primary purpose of creating relationships between tables in a data model, as shown in the image?

a)

To store more data

b)

To enable data analysis across multiple tables

c)

To increase the speed of data entry

d)

To create visualizations automatically

18.

Suppose you want to add a new calculated column to analyze profit margin in the data model. Which feature in the Power BI Desktop ribbon would you use?

a)

New table

b)

New measure

c)

New column

d)

Manage relationships

19.

Which type of table contains numeric, measurable data such as Sales, Revenue, and Quantity?

a)

Fact Table

b)

Dimension Table

c)

Reference Table

d)

Lookup Table

20.

Fact tables are best described as:

a)

Containing descriptive context with low volume

b)

Containing numeric, measurable, high-volume transactional data

c)

Storing only text-based information

d)

Used only for storing dates

21.

A company wants to analyze sales performance by product and date. Which tables would most likely be used for the descriptive context in this analysis?

a)

Fact tables

b)

Dimension tables

c)

Transaction tables

d)

Summary tables

22.

What is the primary purpose of a Dimension table in a database schema as illustrated in the diagram?

a)

To store transactional data

b)

To store descriptive attributes about entities

c)

To calculate averages

d)

To record claim types

23.

Based on the diagram, which of the following fields would most likely be used to analyze spending patterns across different hospitals?

a)

Facility ID

b)

Avg Spndg Per EP Hospital

c)

County Name

d)

Hospital Ownership

24.

If you wanted to find the average spending per episode at the national level, which field from the Fact table would you use?

a)

Avg Spndg Per EP Hospital

b)

Avg Spndg Per EP State

c)

Avg Spndg Per EP National

d)

Percent of Spndg State

25.

How does an optimized schema impact the performance of data visuals?

a)

It makes visuals slower

b)

It makes visuals faster

c)

It increases memory usage

d)

It causes incorrect results

26.

A company is experiencing slow report generation and incorrect results from their data model. Based on the information provided, what is the most likely cause?

a)

Poor schema design

b)

Optimized schema

c)

Scalable data model

d)

Smaller memory footprint

27.

Which schema is recommended to use where possible according to best practices for data modelling?

a)

Star Schema

b)

Snowflake Schema

c)

Galaxy Schema

d)

Network Schema

28.

What is the recommended approach for fact tables in data modelling best practices?

a)

Keep them lean

b)

Add as many columns as possible

c)

Use only text fields

d)

Avoid using them

29.

What is the suggested alternative to text joins in data modelling best practices?

a)

Use surrogate keys

b)

Use composite keys

c)

Use natural keys

d)

Use foreign keys only

30.

A data modeler is designing a new data warehouse. They are considering whether to use text joins or surrogate keys for linking tables. Based on best practices, what should they choose and why?

a)

Use surrogate keys because they are more efficient than text joins

b)

Use text joins because they are easier to understand

c)

Use composite keys because they are more secure

d)

Use natural keys because they are always unique

31.

Which of the following best describes the foundation of Power BI’s data model?

a)

Charts

b)

Tables

c)

Reports

d)

Dashboards

32.

What type of table in Power BI stores quantitative, transactional data such as Sales, Revenue, and Quantity?

a)

Dimension tables

b)

Reference tables

c)

Fact tables

d)

Lookup tables

33.

Which of the following is an example of a dimension table attribute in Power BI?

a)

Revenue

b)

Quantity

c)

Date

d)

Sales

34.

How do relationships in Power BI contribute to meaningful analysis?

a)

By connecting charts to dashboards

b)

By connecting facts to dimensions

c)

By connecting reports to data sources

d)

By connecting tables to queries

35.

What type of data do fact tables store?

a)

Numerical/measurable data

b)

Textual/descriptive data

c)

Image data

d)

Audio data

36.

Which of the following is an example of data that might be stored in a fact table?

a)

Customer names

b)

Sales

c)

Product descriptions

d)

Employee addresses

37.

Why are fact tables important in data analysis?

a)

They store numerical data that can be measured and analyzed, such as sales, hours, and orders.

b)

They store only text data for documentation.

c)

They are used to store images and videos.

d)

They are used to store website URLs.

38.

In a star schema, what is the primary purpose of the Dimension table as illustrated in the diagram?

a)

To store transactional data

b)

To provide descriptive attributes for analysis

c)

To calculate averages

d)

To record claim types

39.

What is the result of combining a fact table with dimension tables?

a)

Simple data storage

b)

Powerful analysis

c)

Data deletion

d)

Data encryption

40.

Which of the following is enabled by combining fact tables, dimension tables, and relationships?

a)

Data loss

b)

Insightful reports and dashboards

c)

Data corruption

d)

Data backup

41.

Why is the one-to-many (1:*) relationship considered important in data modeling?

a)

It is the most common relationship and is used to link dimension tables to fact tables.

b)

It is used only for linking two fact tables.

c)

It is rarely used in practice.

d)

It only applies to self-referencing tables.

42.

What does a One-to-One (1:1) relationship in a database imply?

a)

Both columns are unique, and this type of relationship is rare.

b)

One column is unique, the other is not.

c)

Both columns can have duplicate values.

d)

It is the most common type of relationship.

43.

Why is a One-to-One (1:1) relationship considered rare in databases?

a)

Because both columns must be unique.

b)

Because it allows for many-to-many relationships.

c)

Because it is used for large datasets.

d)

Because it is the default relationship type.

44.

What type of relationship requires careful DAX handling and is used in composite models?

a)

Many-to-Many

b)

One-to-One

c)

One-to-Many

d)

Self-Referencing

45.

Why does a many-to-many relationship in data models require special attention?

a)

Because it needs careful DAX handling

b)

Because it is always faster

c)

Because it is only used in simple models

d)

Because it does not support composite models

46.

What is the default and safe cross filter direction in data modeling?

a)

Single

b)

Both

c)

None

d)

Multiple

47.

Which cross filter direction treats tables as a single table?

a)

Both

b)

Single

c)

None

d)

Multiple

48.

If you want to ensure the safest and default behavior when setting cross filter direction, which option should you choose?

a)

Single

b)

Both

c)

None

d)

All

49.

Why might you choose the "Both" cross filter direction in a data model?

a)

To treat related tables as a single table

b)

To prevent any filtering

c)

To ensure only one-way filtering

d)

To disable all relationships

50.

Which of the following statements is true about active relationships in data modeling?

a)

Multiple relationships can be active at the same time

b)

Only one relationship can be active at a time

c)

No relationships can be active at any time

d)

All relationships are always inactive

51.

How can inactive relationships be used in DAX?

a)

By using the USERELATIONSHIP function

b)

By deleting the relationship

c)

By renaming the relationship

d)

By making it the default relationship

52.

Which of the following is identified as the fact in the example model?

a)

Orders

b)

Customer

c)

Date

d)

Region

53.

Which of the following is NOT listed as a dimension in the example model?

a)

Product

b)

Customer

c)

Date

d)

Region

54.

If you were to analyze sales data using the example model, which dimensions would you use to break down the orders?

a)

Customer, Date, Region

b)

Product, Supplier, Price

c)

Employee, Department, Salary

d)

Category, Quantity, Discount

55.

Which type of relationship is recommended to use wherever possible according to best practices?

a)

One-to-Many

b)

Many-to-Many

c)

One-to-One

d)

Self-Referencing

56.

Why is it important to keep relationships simple in database design?

a)

It makes the system easier to understand and maintain

b)

It increases the complexity of queries

c)

It allows for more data redundancy

d)

It requires more storage space

57.

What is a relationship in the context of databases?

a)

A logical link between two tables

b)

A type of data entry error

c)

A method for deleting tables

d)

A way to format text in a table

58.

Which sequence of steps is required for manual creation of relationships in Power BI?

a)

Home → Manage Relationships → New

b)

File → Open → Relationships

c)

Insert → Table → New

d)

View → Data → Relationships

59.

Suppose you want to create a relationship between two tables in Power BI without using autodetect. Which two alternative methods can you use?

a)

Manual creation and drag-and-drop

b)

Copy-paste and export

c)

Delete and refresh

d)

Import and export

60.

Which software is shown in the image?

a)

Power BI Desktop

b)

Microsoft Word

c)

Microsoft Excel

d)

Tableau

61.

When manually creating a relationship, which of the following must you select?

a)

Table A & column, Table B & column

b)

Only Table A

c)

Only Table B

d)

Only the cardinality

62.

What does setting the cardinality in a relationship setup define?

a)

The number of tables in the database

b)

The type of data stored in the columns

c)

The nature of the relationship (e.g., 1:1, 1:*)

d)

The color of the table headers

63.

Suppose you want to filter data for a specific report in Power BI Desktop. Which filter section should you use?

a)

Page level filters

b)

Drillthrough filters

c)

Report level filters

d)

Values

64.

Why is the drag-and-drop method in Model View considered quick and intuitive?

a)

It is especially suitable for smaller models

b)

It requires advanced programming skills

c)

It only works with large databases

d)

It needs manual relationship creation

65.

What does "cardinality" refer to when editing relationships?

a)

The number of tables in a database

b)

The direction of data flow

c)

The type of relationship (One-to-one, One-to-many, Many-to-many)

d)

The size of the columns

66.

Suppose you have a relationship set as inactive, but you need it to be used in a specific calculation. What should you do?

a)

Change the cardinality

b)

Make the relationship active

c)

Change the table name

d)

Set cross-filter direction to both

67.

What is the cardinality set for the relationship in the "Edit relationship" window?

a)

Many to one (*:1)

b)

One to many (1:*)

c)

One to one (1:1)

d)

Many to many (*:*)

68.

Which option is checked to ensure the relationship is active in the "Edit relationship" window?

a)

Make this relationship active

b)

Assume referential integrity

c)

Apply security filter in both directions

d)

Cross filter direction

69.

If you wanted to filter data from the Product table to the Sales table, which cross filter direction would you select for a single direction filter?

a)

Single

b)

Both

c)

None

d)

Reverse

70.

When does Power BI automatically detect relationships between tables?

a)

When you load new tables with matching column names

b)

When you delete tables from the model

c)

When you export data to Excel

d)

When you change the theme of the report

71.

What happens when the source data structure changes in Power BI?

a)

Power BI keeps relationships updated

b)

Power BI deletes all relationships

c)

Power BI ignores the changes

d)

Power BI exports the data automatically

72.

Which of the following is an example that can trigger relationship detection in Power BI?

a)

Adding new fields or updating column names

b)

Changing the report title

c)

Printing the report

d)

Logging out of Power BI

73.

Why is it important to review auto-created relationships in Power BI?

a)

They may be incorrect or not optimal

b)

They always delete your data

c)

They change the report layout

d)

They increase the file size

74.

What does the "Autodetect new relationships after data is loaded" option do in Power BI?

a)

Automatically creates new relationships between tables after data is loaded

b)

Deletes all existing relationships

c)

Prevents any relationships from being created

d)

Only updates relationships during data refresh

75.

Enabling "Enable parallel loading of tables" in Power BI can improve performance in which scenario?

a)

When loading multiple large tables simultaneously to reduce overall load time

b)

When only one small table is being loaded

c)

When you want to prevent any tables from loading

d)

When you want to disable all background processes

76.

Which type of cardinality relationship is typically used in advanced or composite models?

a)

One-to-Many (1:*)

b)

One-to-One (1:1)

c)

Many-to-Many (:)

d)

None of the above

77.

Given the data in the ProjectBudget and CompanyProjectPriority tables, which project would you recommend prioritizing if the company wants to focus on the project with the highest budget allocation and a priority of B or higher? Justify your answer.

a)

Blue

b)

Red

c)

Green

d)

None of the above

78.

What can happen if a cross filter is set up incorrectly?

a)

The filter will not work at all

b)

It may cause ambiguous results

c)

The filter will always flow both ways

d)

The filter will be deleted

79.

Why should you use caution when setting a cross filter to both directions?

a)

It is the default setting

b)

It can filter in both ways, which may lead to unexpected results

c)

It disables filtering

d)

It only works with certain data types

80.

How many active relationships can exist per table pair?

a)

Only one

b)

Two

c)

Unlimited

d)

None

81.

If you need to change which relationship is active between two tables, what should you do?

a)

Use the Manage Relationships feature

b)

Delete both tables

c)

Rename the tables

d)

Add a new column

82.

What does the Relationship View (Model View) provide a visual view of?

a)

Tables and relationships

b)

Charts and graphs

c)

Data and queries

d)

Reports and dashboards

83.

Suppose you are working with a data model that has many interconnected tables. How might the Relationship View (Model View) help you manage this model?

a)

By providing a visual representation and allowing drag-and-drop editing of tables and relationships

b)

By automatically generating all queries

c)

By encrypting all data

d)

By exporting the model to a PDF

84.

What type of data do Power BI Date Tables contain?

a)

Only date-related data

b)

Only numeric data

c)

Only text data

d)

Only financial data

85.

How do Power BI Date Tables support time intelligence calculations?

a)

By enabling calculations based on dates

b)

By storing images

c)

By encrypting data

d)

By managing user accounts

86.

A company wants to analyze its sales data by year, quarter, month, and day. Which feature of Power BI Date Tables makes this possible?

a)

Their ability to store product information

b)

Their use for analyzing data by different time periods

c)

Their support for financial transactions

d)

Their ability to manage user roles

87.

Which of the following is a primary reason for using date tables in data analysis?

a)

To store large amounts of text data

b)

To allow slicing & dicing data by date attributes

c)

To improve network security

d)

To reduce the size of the database

88.

How do date tables support time-series analysis?

a)

By providing random data points

b)

By supporting accurate and continuous time-series analysis

c)

By encrypting the data

d)

By removing duplicate records

89.

Which of the following is another name for Date Tables?

a)

Calendar Tables

b)

Time Series Tables

c)

Event Tables

d)

Data Fact Tables

90.

If you encounter a "Calendar Dimension Table" in a database, what is it most likely referring to?

a)

A type of Date Table

b)

A table for storing product information

c)

A table for user credentials

d)

A table for sales transactions

91.

What is the main characteristic of the Auto Date/Time method in Power BI?

a)

It uses M-query to generate tables

b)

It is hidden and auto-generated

c)

It requires manual import

d)

It uses CALENDAR() function

92.

Which DAX functions can be used to create date tables in Power BI?

a)

CALENDAR() and CALENDARAUTO()

b)

DATEADD() and DATEDIFF()

c)

NOW() and TODAY()

d)

TIME() and HOUR()

93.

Which method is best for creating a date table that updates automatically as new data is added?

a)

Source Data, because it is always up-to-date

b)

Auto Date/Time, because it is hidden and auto-generated

c)

DAX, because it allows for custom date ranges

d)

Power Query, because it can generate dynamic date tables using M-query

94.

What should you do if your data source already contains a date table?

a)

Recreate the date table from scratch

b)

Ignore the date table and use only raw data

c)

Just import the date table and build relationships

d)

Delete the date table before importing

95.

Why is it unnecessary to recreate a date table if one already exists in the source data?

a)

Because it is faster to recreate it

b)

Because you can simply build relationships with the existing table

c)

Because the existing table is always incorrect

d)

Because recreating is required for all sources

96.

Which menu path should you follow to enable the Auto Date/Time feature?

a)

File → Options → Data Load → Time Intelligence

b)

File → Save As → Data Load → Time Intelligence

c)

Edit → Preferences → Data Load → Time Intelligence

d)

View → Options → Data Load → Time Intelligence

97.

What does the Auto Date/Time method create for each date column?

a)

Visible date tables

b)

Hidden date tables

c)

Manual date tables

d)

Linked date tables

98.

Which of the following is included in the Date Hierarchy provided by the Auto Date/Time method?

a)

Year, Week, Hour, Minute

b)

Year, Quarter, Month, Day

c)

Year, Month, Week, Day

d)

Year, Quarter, Week, Day

99.

What is a limitation of the Auto Date/Time method?

a)

It is slow and complex

b)

It only works with multiple tables

c)

It is limited to a single table

d)

It does not provide a date hierarchy

100.

Which of the following elements are included in the Date Hierarchy when you expand the date column?

a)

Year, Quarter, Month, Day

b)

Week, Month, Year, Hour

c)

Customer ID, Order ID, Product Name, Price

d)

Year, Week, Day, Hour

101.

Which of the following columns can you add using DAX formulas as mentioned in the material?

a)

Year, Month, Weekday, Quarter

b)

Hour, Minute, Second, Millisecond

c)

Product, Sales, Region, Country

d)

Name, Address, Phone, Email

102.

Which DAX function is used to extract the year from a date column in Power BI?

a)

YEAR()

b)

MONTH()

c)

FORMAT()

d)

DATE()

103.

What is the purpose of the FORMAT function in the DAX formula: FORMAT('Date'[Date], "mmmm")?

a)

To extract the year from a date

b)

To extract the numeric month from a date

c)

To format the date as the full month name

d)

To create a new table

104.

What is the value of the "MonthNum" column for all the dates shown in the table?

a)

1

b)

2

c)

12

d)

0

105.

According to the table, which month is represented for all the dates listed?

a)

January

b)

February

c)

March

d)

December

106.

Based on the table, what year do all the dates belong to?

a)

2015

b)

2016

c)

2014

d)

2020

107.

How does the dynamic date table in Power Query respond to new data?

a)

It updates automatically

b)

It requires manual refresh

c)

It deletes old data

d)

It creates duplicate tables

108.

After right-clicking in the empty space of the Queries pane, which of the following is NOT an option available in the drop-down menu?

a)

New Query

b)

New Parameter

c)

Delete Query

d)

New Group

109.

What does #duration(1,0,0,0) mean in the context of the M-query?

a)

1 hour, 0 days, 0 minutes, 0 seconds

b)

1 day, 0 hours, 0 minutes, 0 seconds

c)

1 minute, 0 hours, 0 days, 0 seconds

d)

1 second, 0 days, 0 hours, 0 minutes

110.

What is an advantage of using the M-query to create a date table as described?

a)

The date table must be recreated manually

b)

The date table auto-updates when new data comes in

c)

The date table only works for one year

d)

The date table cannot be updated

111.

Which date corresponds to the 10th entry in the list?

a)

10/01/2015

b)

01/10/2015

c)

20/01/2015

d)

11/01/2015

112.

What is the first step you must take before including other date-related columns when creating date tables using the DAX equation approach?

a)

Change the date column's data type to Date

b)

Add a new column for each date-related value

c)

Delete all existing columns

d)

Rename the column to "Date"

113.

After successfully using Power Query as described, what have you created?

a)

A chart

b)

A date table

c)

A pivot table

d)

A data model

114.

How do calculated columns appear in the Fields pane?

a)

As hidden columns

b)

Like regular columns with a special icon

c)

As measures

d)

As tables

115.

If you want to add a custom column to a report visualization, what is the correct procedure based on the information provided?

a)

Use only the default columns provided.

b)

Rename the column as desired and add it to the report visualization.

c)

Only use columns with numeric values.

d)

Columns cannot be added to report visualizations.

116.

Which of the following best describes when a Custom Column (Power Query) is created?

a)

During data load, before data is in the model.

b)

After data is in the model, works with model relationships.

c)

After data is visualized in reports.

d)

Only when exporting data to Excel.

117.

What is a key difference between a Calculated Column (DAX) and a Custom Column (Power Query)?

a)

Calculated Columns are created before data load, Custom Columns after.

b)

Calculated Columns are created after data is in the model, Custom Columns before.

c)

Both are created at the same time.

d)

Custom Columns work with model relationships, Calculated Columns do not.

118.

What is the purpose of creating a "City + State" column in the given business case?

a)

To show City and State together

b)

To separate City and State

c)

To hide City and State

d)

To delete City and State

119.

Which DAX formula is used to combine City and State into a single field?

a)

CityState = [City] & ", " & [State]

b)

CityState = [City] + [State]

c)

CityState = [State] - [City]

d)

CityState = [City] * [State]

120.

After creating the CityState field, where can it be added for visualization?

a)

Maps

b)

Charts

c)

Tables only

d)

Dashboards only

121.

Why might a shipping manager want to create a new field combining City and State?

a)

To display both location details together for better visualization

b)

To reduce the number of columns in the table

c)

To hide sensitive information

d)

To increase data redundancy

122.

What is the result of the DAX formula: CityState = [City] & ", " & [State]?

a)

A new field combining City and State with a comma separator

b)

A new field showing only City

c)

A new field showing only State

d)

A new field with City and State separated by a dash

123.

Which columns are involved in creating the CityState field in the Geography table?

a)

City and State

b)

Product and State

c)

Geography and Product

d)

City and Product

124.

Suppose you have a row where the City is "Dallas" and the State is "Texas". What would be the value in the CityState field after applying the described process?

a)

Dallas Texas

b)

Texas, Dallas

c)

Dallas, Texas

d)

Texas Dallas

125.

What is the purpose of the CityState field mentioned in the material?

a)

To add location-based data to visualizations

b)

To calculate shipment costs

c)

To filter out irrelevant data

d)

To create text summaries

126.

Which of the following best describes a feature of the CityState field?

a)

It can only be used in bar charts

b)

It can be added to just about any type of visualization

c)

It is limited to text-based reports

d)

It is used only for filtering data

127.

Suppose you want to visualize shipment data by location. How would the CityState field help you achieve this?

a)

By allowing you to plot shipment data on a map

b)

By summarizing shipment data in a table

c)

By hiding shipment data from the visualization

d)

By converting shipment data into text format

128.

Which language is used to create an entirely new calculated table in data models?

a)

SQL

b)

DAX

c)

Python

d)

R

129.

Which of the following is NOT a typical use case for calculated tables?

a)

Filtering subsets of data

b)

Creating role-playing dimensions

c)

Aggregating data differently

d)

Storing raw source data

130.

A company wants to analyze sales data by different time periods using the same date information. Which feature of calculated tables would be most useful in this scenario?

a)

Filtering subsets of data

b)

Creating role-playing dimensions

c)

Loading data from the source

d)

Storing unprocessed data

131.

What is the purpose of the calculated table shown in the example?

a)

To create a table for 2024 Sales only

b)

To delete sales data from 2024

c)

To summarize all years' sales

d)

To filter out all sales except 2023

132.

Which DAX function is used in the example to filter sales data for the year 2024?

a)

SUM

b)

FILTER

c)

AVERAGE

d)

COUNT

133.

What happens when you create a calculated table as shown in the example?

a)

It replaces the original table

b)

It adds a new table in the Fields list

c)

It deletes all existing tables

d)

It merges all tables into one

134.

Which tool is used to work row-by-row when creating calculated columns?

a)

SQL

b)

DAX

c)

Python

d)

R

135.

What is a key benefit of using calculated tables in data modeling?

a)

They add new fields inside a table.

b)

They generate entire new tables.

c)

They visualize data.

d)

They encrypt data.

136.

How do calculated tables help in the data modeling process?

a)

By improving data security

b)

By restructuring data for modeling

c)

By visualizing data

d)

By cleaning data

137.

Both calculated columns and calculated tables contribute to which aspect of data modeling?

a)

Data encryption

b)

Data modeling flexibility

c)

Data storage

d)

Data deletion

138.

A data analyst wants to restructure data for better modeling. Which feature should they use?

a)

Calculated columns

b)

Calculated tables

c)

Data encryption

d)

Data visualization

139.

Why might 'Measures in DAX for Data Modeling' be important for youth development programmes?

a)

It helps in analyzing and interpreting data for better decision-making.

b)

It is used for cooking recipes.

c)

It is a type of physical exercise.

d)

It is a method for painting.

140.

Which of the following is NOT typically used as an aggregation or KPI in measures?

a)

SUM

b)

AVG

c)

TEXT

d)

COUNT

141.

How do the results of measures behave when filters and slicers are applied?

a)

They remain static

b)

They adapt dynamically

c)

They disappear

d)

They become read-only

142.

Which of the following fields is NOT listed under the "financials" table in the provided image?

a)

Net Sales

b)

Total Sales

c)

Discount Band

d)

Customer Name

143.

If you wanted to analyze the overall revenue generated, which field would you most likely use from the list?

a)

COGS

b)

Total Sales

c)

Discount Band

d)

Segment

144.

Which language is used to create calculated fields known as Measures?

a)

SQL

b)

DAX

c)

Python

d)

R

145.

A user wants to calculate the maximum value in a dataset using a Measure. Which aggregation function should they use?

a)

MIN

b)

MAX

c)

SUM

d)

COUNT

146.

Which of the following is a primary role of measures in data modeling?

a)

Enhance fact tables with business calculations

b)

Increase the number of columns in the data model

c)

Store raw data only

d)

Remove all calculated columns from reports

147.

Why is it beneficial to keep the data model lightweight in data modeling?

a)

To avoid storing calculated columns

b)

To increase the complexity of the model

c)

To duplicate data across tables

d)

To slow down report generation

148.

Which of the following is an example of time intelligence supported by measures in data modeling?

a)

Year-over-Year (YoY) growth

b)

Data encryption

c)

Data normalization

d)

Data backup

149.

Which two fields are selected in the Fields pane for the visualization shown in the image?

a)

Last Years Sales and Projected Sales

b)

Sales and Profit

c)

Gross Sales and Discounts

d)

Country and Segment

150.

What does the bar chart in the image compare?

a)

Last Years Sales and Projected Sales

b)

Sales and Profit

c)

Discounts and Gross Sales

d)

Country and Product

151.

What is the main characteristic of the Auto Date/Time method for creating date tables in Power BI?

a)

It uses M-query to generate tables

b)

It is hidden and auto-generated

c)

It requires manual import from a dataset

d)

It uses CALENDAR() or CALENDARAUTO()

152.

Which function(s) can be used in DAX to create a date table?

a)

CALENDAR() or CALENDARAUTO()

b)

M-query

c)

Import Table

d)

Auto Date/Time

153.

What is the name given to the measure being created in the image?

a)

Projected Sales

b)

Last Years Sales

c)

Channel Sales

d)

Units Sold

154.

Based on the formula shown in the image, which column is being summed to calculate "Last Years Sales"?

a)

Sales[Projected Sales]

b)

Sales[Units Sold]

c)

Channel[Units Sold]

d)

Sales[Channel]

155.

How many DAX functions are available for measures?

a)

Over 200

b)

Over 50

c)

Over 1000

d)

Over 20

156.

Which DAX function category would you use to calculate the year-to-date total?

a)

Time intelligence

b)

Text

c)

Logical

d)

Aggregation

157.

Which of the following pairs correctly matches a DAX function with its category?

a)

SWITCH - Logical

b)

AVERAGE - Text

c)

RIGHT - Aggregation

d)

TOTALYTD - Logical

158.

A business analyst wants to compare sales from the same period last year using DAX. Which function should they use?

a)

SAMEPERIODLASTYEAR

b)

LEFT

c)

IF

d)

SUM

159.

Where do you select the field you want to move in Power BI Desktop?

a)

Fields pane

b)

Properties pane

c)

Visualizations pane

d)

Filters pane

160.

After entering a folder name in the Display folder box, what happens to the field in Power BI Desktop?

a)

The field is deleted

b)

The field is hidden

c)

The field moves into the newly created folder

d)

The field is duplicated

161.

Which of the following is NOT a field listed under the "Sales" table in the provided image?

a)

Profit

b)

DiscountAmount

c)

SalesAmount

d)

ProductKey

162.

What is the purpose of the "Is hidden" toggle in the interface shown in the image?

a)

To delete a field

b)

To hide or show a field in reports

c)

To rename a field

d)

To export data

163.

If you wanted to organize fields into a specific group for easier navigation, which feature in the interface would you use?

a)

Description

b)

Display folder

c)

Is hidden

d)

PromotionKey

164.

Which statement best describes the impact of data modeling on dataset redundancy?

a)

Data modeling increases redundancy in datasets

b)

Data modeling has no effect on redundancy

c)

Data modeling reduces redundancy in datasets

d)

Data modeling ignores redundancy issues

165.

Which of the following best describes the role of measures in DAX within Power BI?

a)

They drive dynamic, reusable, and consistent calculations

b)

They are used only for data import

c)

They are for formatting reports

d)

They store raw data

166.

According to best practices, what should you do with measures in Power BI?

a)

Organize, optimize, and centralize them

b)

Hide them from all users

c)

Use them only once

d)

Delete them after use

167.

What is a standard use of a Power BI Date Table?

a)

Referencing dates as a dimension table

b)

Storing customer names

c)

Calculating sales tax

d)

Managing user permissions

168.

Suppose you want to compare sales performance across different quarters and years in Power BI. Which feature of the Date Table would you use, and why?

a)

Use the Date Table to enable time intelligence calculations, allowing comparison by Year and Quarter

b)

Use the Date Table to store customer addresses

c)

Use the Date Table to encrypt sensitive data

d)

Use the Date Table to manage user roles

169.

What function do date tables enable in DAX?

a)

DAX time intelligence functions

b)

DAX security functions

c)

DAX formatting functions

d)

DAX visualization functions

170.

How do date tables support time-series analysis?

a)

By providing random data points

b)

By supporting accurate and continuous time-series analysis

c)

By removing all date attributes

d)

By limiting data to a single year

171.

A company wants to analyze sales trends over several years and needs to ensure their analysis is both accurate and continuous. Which feature of date tables best supports this requirement?

a)

Storing customer addresses

b)

Accurate and continuous time-series analysis

c)

Encrypting sensitive data

d)

Generating random numbers

172.

What is the main reason for requiring unique values in a date table?

a)

Avoids duplicate calculations

b)

Reduces memory usage

c)

Increases processing speed

d)

Allows for multiple time zones

173.

A date table must have no missing dates. What does this requirement ensure?

a)

Ensures full timeline

b)

Reduces data redundancy

c)

Increases data privacy

d)

Allows for random sampling

174.

Which of the following is another name for Date Tables?

a)

Calendar Tables

b)

Time Series Tables

c)

Event Tables

d)

Transaction Tables

175.

Which term is NOT commonly used as another name for Date Tables?

a)

Date Dimension Tables

b)

Calendar Dimension Tables

c)

Product Tables

d)

Calendar Tables

176.

If you encounter a "Calendar Dimension Table" in a database, what is it most likely referring to?

a)

A table that stores product information

b)

A table that stores date-related information

c)

A table that stores customer addresses

d)

A table that stores sales transactions

177.

What should you do if your data source already contains a date table?

a)

Recreate the date table from scratch

b)

Ignore the date table and use your own

c)

Just import the date table and build relationships

d)

Delete the date table before importing

178.

Why is it unnecessary to recreate a date table if one already exists in the source data?

a)

Because it is faster to recreate it

b)

Because you can simply build relationships with the existing table

c)

Because the existing table is always incorrect

d)

Because recreating is required for compatibility

179.

What is a limitation of the Auto Date/Time method?

a)

It is slow and complex

b)

It only works with multiple tables

c)

It is quick, but limited to a single table

d)

It does not provide a date hierarchy

180.

Which of the following columns can you add using DAX after creating a calendar table?

a)

Year, Month, Weekday, Quarter

b)

Product, Price, Discount, Tax

c)

Customer, Region, Salesperson, Profit

d)

Color, Size, Weight, Material

181.

Which DAX function is used to extract the year from a date column in Power BI?

a)

YEAR()

b)

MONTH()

c)

FORMAT()

d)

DATE()

182.

Given the formula Month = FORMAT('Date'[Date], "mmmm"), what would be the output if the date is 2023-04-15?

a)

April

b)

4

c)

2023

d)

15

183.

A user wants to create a new column in Power BI that displays the year, month name, and month number from a date field. Which combination of DAX functions should they use?

a)

YEAR(), FORMAT(), MONTH()

b)

DAY(), FORMAT(), YEAR()

c)

MONTH(), DAY(), FORMAT()

d)

FORMAT(), YEAR(), DAY()

184.

If you were to extend the table to include February, what would you expect the "MonthNum" value to be for February?

a)

2

b)

1

c)

12

d)

2015

185.

What is the purpose of using the expression #date(2020,1,1) + #duration(1,0,0,0) in Power Query?

a)

To create a static date value

b)

To generate a dynamic date table

c)

To filter data by year

d)

To sort data by month

186.

When using Power Query to generate a date table, which columns are typically included?

a)

Name, Address, Phone

b)

Year, Month, Quarter, Day

c)

Product, Price, Quantity

d)

Week, Hour, Minute

187.

Which button should you click on the ribbon to navigate to Power Query?

a)

Refresh

b)

Transform Data

c)

Enter Data

d)

Format Painter

188.

After right-clicking in the empty space of the Queries pane, which of the following is NOT an option available in the drop-down menu?

a)

Excel Workbook

b)

SQL Server

c)

PowerPoint Presentation

d)

OData feed

189.

Why is there no need to recreate the date table manually in the M-query approach described?

a)

Because the date table auto-updates with new data.

b)

Because the table is static and never changes.

c)

Because the table is deleted after each use.

d)

Because the table only contains one date.

190.

Which date corresponds to the 10th item in the list?

a)

10/01/2015

b)

01/01/2015

c)

15/01/2015

d)

20/01/2015

191.

Based on the pattern in the table, what is the interval between each date in the list?

a)

1 day

b)

1 week

c)

2 days

d)

1 month

192.

Which tab on the ribbon should you navigate to in order to change the result of the M-equation from a list of dates to a table of dates?

a)

Home

b)

View

c)

Transform

d)

Tools

193.

What is the first step you must take before including other date-related columns when creating date tables using the DAX equation approach?

a)

Change the date column's data type to Date

b)

Add a new column for each date-related value

c)

Rename the column to 'Date'

d)

Delete all other columns except the date column

194.

Why must a column in a Date Table have unique values?

a)

To avoid duplicate records

b)

To ensure it is recognized as Date datatype with unique values

c)

To increase table size

d)

To allow text entries

195.

Which function requires a table to be marked as a Date Table?

a)

Mathematical functions

b)

String manipulation functions

c)

Time intelligence functions

d)

Sorting functions

196.

Why is it important to optimize schema and relationships during model profiling?

a)

To reduce the number of users

b)

To improve model performance and efficiency

c)

To increase dataset size

d)

To add more storage modes

197.

If a company wants to import data from both their ERP system and social media into the Import Model, what does this suggest about the flexibility of the Import Model?

a)

The Import Model can only handle one data source at a time.

b)

The Import Model is limited to on-premises data only.

c)

The Import Model can integrate data from multiple and diverse sources.

d)

The Import Model cannot import data from social media.

198.

What is the purpose of enabling refresh failure notifications?

a)

To be alerted when a data refresh fails

b)

To increase the refresh speed

c)

To reduce the number of refreshes

d)

To disable incremental refresh

199.

A business is experiencing slow report performance due to simultaneous Import and DirectQuery refreshes on the same gateway. What strategic change should they make?

a)

Use separate gateways for Import & DirectQuery

b)

Increase the refresh frequency

c)

Disable incremental refresh

d)

Ignore refresh failure notifications

200.

Which of the following best describes the main purpose of query caching?

a)

To store user passwords securely

b)

To reuse cached results and boost performance

c)

To increase the load on workspaces

d)

To delete frequently accessed data

201.

What is one benefit of query caching for workspaces?

a)

It increases the amount of data stored

b)

It reduces the load on workspaces

c)

It slows down data access

d)

It removes premium features

202.

Which of the following should you do to prevent unnecessary hidden tables when loading data?

a)

Enable Auto Date/Time

b)

Avoid Auto Date/Time

c)

Use GroupKind.Global

d)

Confuse with "Hide in report view"

203.

What happens when you create a calculated table as shown in the example?

a)

A new table is added in the Fields list.

b)

The original table is deleted.

c)

All tables are merged into one.

d)

A chart is automatically created.

204.

How can the calculated table created for 2024 Sales be used?

a)

Like any other table in relationships and visuals.

b)

Only for viewing, not for analysis.

c)

Only for exporting data.

d)

Only for deleting records.

205.

Suppose you want to analyze only the sales data for a specific year using the method shown. What would be your first step?

a)

Use the FILTER function to select the desired year.

b)

Delete all other years from the database.

c)

Export the data to Excel.

d)

Create a pie chart.

206.

Why might using Auto Date/Time with many date/time fields in a model be problematic?

a)

It generates multiple hidden tables, increasing memory usage.

b)

It deletes existing tables.

c)

It prevents data from being loaded.

d)

It automatically shares data with other users.

207.

How does the Auto Date/Time feature affect small models in Power BI Desktop?

a)

It increases memory footprint and can slow down performance.

b)

It reduces the size of the model.

c)

It speeds up data processing.

d)

It has no effect on performance.

208.

Which of the following best describes the purpose of the "Time intelligence" setting shown in the image?

a)

It automatically sets the date and time for new files.

b)

It deletes old files automatically.

c)

It changes the file format for new files.

d)

It encrypts new files.

209.

If you want to create a lean data model, what should you do with unwanted columns?

a)

Remove them

b)

Rename them

c)

Duplicate them

d)

Hide them

210.

In the star schema diagram, what do the blue rectangles labeled "Dim" represent?

a)

Fact tables

b)

Dimension tables

c)

Primary keys

d)

Data cubes

211.

Based on the diagram, what type of relationship exists between the "Fact" table and each "Dim" table in a star schema?

a)

One-to-one

b)

Many-to-many

c)

One-to-many

d)

Many-to-one

212.

What is a key benefit of using bi-directional cross-filtering in data models?

a)

It enables easier slicing and filtering across related tables.

b)

It prevents any performance issues in complex models.

c)

It eliminates the need for relationships between tables.

d)

It guarantees consistent results in all scenarios.

213.

A data analyst notices that their model is running slowly after enabling bi-directional cross-filtering. What is the most likely reason for this performance issue?

a)

Overuse of bi-directional relationships has created long relationship propagation chains.

b)

The tables are not related at all.

c)

The model is too simple for bi-directional filtering.

d)

Bi-directional filtering always increases performance.

214.

Which two tables are being related in the "Edit relationship" window shown in the image?

a)

Articles and Categories

b)

Authors and Sections

c)

Power BI Desktop and Power BI Service

d)

Visualizations and Get started

215.

What is the cardinality set for the relationship between the two tables in the image?

a)

One to One (1:1)

b)

Many to One (*:1)

c)

One to Many (1:*)

d)

Many to Many (*:*)

216.

Why might you want to apply a security filter in both directions when setting up a relationship between tables?

a)

To increase data redundancy

b)

To ensure security rules are enforced across both related tables

c)

To speed up data loading

d)

To disable filtering between tables

217.

Given the sample data, which category does the article dated 4/19/2016 belong to?

a)

Power BI Desktop

b)

Power BI Developer

c)

Power BI Service

d)

Power BI Mobile Apps

218.

What is the recommended mode for dimension tables in a composite model?

a)

Import mode

b)

DirectQuery

c)

Dual mode

d)

Aggregation mode

219.

According to best practices, how should the row count of an aggregation table compare to the fact table?

a)

The same size as the fact table

b)

2x smaller than the fact table

c)

10x smaller than the fact table

d)

100x larger than the fact table

220.

A data modeler is working with a very large fact table and several dimension tables. Based on best practices, which configuration should they use for optimal performance?

a)

Use Import mode for all tables

b)

Use DirectQuery for fact tables and Dual mode for dimension tables

c)

Use Dual mode for all tables

d)

Use aggregation tables only

221.

What should you avoid when dealing with large datasets?

a)

Use Import for speed

b)

Use Import for huge datasets

c)

Use Star Schema

d)

Use integers for keys

222.

Which schema should be used for best practices in data modeling?

a)

Star Schema

b)

Snowflake Schema

c)

Flat Table

d)

Mixed Schema

223.

What is a disadvantage of using strings for joins instead of integers?

a)

It slows down query performance

b)

It increases data security

c)

It reduces data redundancy

d)

It simplifies schema design

224.

When comparing report performance, what should you observe to determine which schema is easier to maintain and more efficient?

a)

A. The number of columns in each table.

b)

B. The speed and ease of building visuals and maintaining the schema.

c)

C. The color of the tables.

d)

D. The number of users accessing the tables.

225.

Suppose you have imported a Sales table and a Products table. Which schema would you use if you want to separate fact and dimension tables?

a)

A. Flat schema

b)

B. Star schema

c)

C. Snowflake schema

d)

D. Hierarchical schema

226.

You are tasked with creating both a flat schema and a star schema for a dataset. What is a strategic reason for comparing their report performance?

a)

A. To determine which schema is more visually appealing.

b)

B. To identify which schema is easier to maintain and more efficient for reporting.

c)

C. To see which schema has more tables.

d)

D. To find out which schema uses more storage space.

227.

Which tables need to be imported for the practice on table types and relationships?

a)

FactSales, DimCustomer, and DimDate

b)

FactSales, DimProduct, and DimDate

c)

Sales, Customer, and Date

d)

FactOrders, DimCustomer, and DimProduct

228.

When testing cross-filtering in Power BI, what should you do to check if related sales update correctly?

a)

Select a product and check inventory levels

b)

Select a customer and check if related sales update

c)

Select a date and check if all tables refresh

d)

Select a region and check if customer names change

229.

Suppose you delete a relationship in Power BI and use "AutoDetect" to rebuild it. What reasoning process are you using to ensure your data model is correct?

a)

Guessing without evidence

b)

Relying on default settings only

c)

Testing and verifying connections by observing if related data updates as expected

d)

Ignoring the results and moving on

230.

What is the formula for calculating Profit as shown in the learning material?

a)

Profit = FactSales[CostAmount] - FactSales[SalesAmount]

b)

Profit = FactSales[SalesAmount] + FactSales[CostAmount]

c)

Profit = FactSales[SalesAmount] - FactSales[CostAmount]

d)

Profit = FactSales[CostAmount] / FactSales[SalesAmount]

231.

Which tool is used to create a Date Table as mentioned in the practice section?

a)

Microsoft Excel

b)

Power BI

c)

Tableau

d)

Google Sheets

232.

Which DAX function is used to calculate the total sales amount in the provided example?

a)

SUM

b)

AVERAGE

c)

COUNT

d)

MIN

233.

What is the correct DAX formula to calculate the average sales per order?

a)

AVERAGE(FactSales[SalesAmount])

b)

SUM(FactSales[SalesAmount])

c)

COUNT(FactSales[SalesAmount])

d)

MAX(FactSales[SalesAmount])

234.

Which measure would you use to calculate the year-to-date sales in DAX?

a)

Sales YTD = TOTALYTD(SUM(FactSales[SalesAmount]), DimDate[Date])

b)

Total Sales = SUM(FactSales[SalesAmount])

c)

Average Sales per Order = AVERAGE(FactSales[SalesAmount])

d)

Sales YTD = SUM(FactSales[SalesAmount])

235.

If you are asked to add KPI cards for the measures created, what is the main purpose of a KPI card in a data model?

a)

To visually display key performance indicators for quick insights

b)

To store raw data

c)

To perform data cleaning

d)

To create relationships between tables

236.

Given the measures Total Sales, Average Sales per Order, and Sales YTD, which of the following best describes the type of analysis you can perform with these measures?

a)

You can analyze overall sales performance, average transaction value, and sales trends over time.

b)

You can only count the number of sales transactions.

c)

You can only display product names.

d)

You can only filter data by customer.

237.

Which of the following is a best practice for schema design and optimization?

a)

Remove unnecessary columns

b)

Add more surrogate keys to the report view

c)

Avoid creating hierarchies in DimDate

d)

Use as many columns as possible

238.

What is the purpose of hiding surrogate keys from the report view in schema design?

a)

To make the report view cleaner and easier to navigate

b)

To increase the number of columns in the report

c)

To display all technical details to end users

d)

To slow down report performance

239.

In the context of DimDate, which hierarchy is recommended to be created for better report navigation?

a)

Year > Month > Day

b)

Day > Month > Year

c)

Month > Day > Year

d)

Day > Year > Month

240.

Which tool in Power BI is used to track slow visuals?

a)

Data Profiler

b)

Performance Analyzer

c)

Query Editor

d)

Visual Inspector

241.

Why is it recommended to use measures instead of calculated columns in Power BI optimization?

a)

Measures are easier to create

b)

Measures can improve performance

c)

Calculated columns are always faster

d)

Measures are only for visuals

242.

Which of the following is NOT listed as a dimension for the Sales Model in the capstone activity?

a)

A) Date

b)

B) Customer

c)

C) Product

d)

D) Revenue

243.

Which of the following best describes the main purpose of creating a dashboard in the capstone activity?

a)

A) To display only sales data

b)

B) To visualize KPIs, trend charts, and slicers for analysis

c)

C) To store customer information

d)

D) To calculate profit margins only

244.

Suppose you are managing a large fact table and want to optimize its performance. Which two strategies from the material should you implement?

a)

Use incremental refresh and partition data by logical units

b)

Delete old data and compress the table

c)

Merge all data into one partition and disable refresh

d)

Increase the number of columns and reduce indexing

245.

Which of the following is a disadvantage of keeping unnecessary precision in your schema?

a)

A. It simplifies the schema

b)

B. It can increase storage and reduce performance

c)

C. It helps in normalization

d)

D. It enables better filtering

246.

Why is it important to have efficient relationships in schema design?

a)

To improve performance and scalability

b)

To increase data redundancy

c)

To make the schema more complex

d)

To reduce the number of tables

247.

Which of the following is a direct benefit of optimized models according to the material?

a)

Faster reports

b)

Slower processing

c)

Increased errors

d)

Lower accuracy

248.

What is performance tuning primarily about, as mentioned in the material?

a)

Efficient data model, smart refresh strategy, correct connection mode, and using best practices consistently

b)

Adding more users to the system

c)

Increasing the size of the database

d)

Reducing the number of reports generated

249.

Which of the following is NOT listed as a component of performance tuning in the material?

a)

Efficient data model

b)

Smart refresh strategy

c)

Correct connection mode

d)

Increasing hardware resources

250.

Why is using best practices consistently important in performance tuning?

a)

It ensures optimized models, leading to faster reports and better decisions.

b)

It increases the complexity of the data model.

c)

It reduces the need for a refresh strategy.

d)

It eliminates the need for a connection mode.