What is a characteristic of a star schema?

It is designed for OLTP systems to ensure fast writes.

It uses a single table for both facts and dimensions.

Dimension tables are normalized into multiple related tables.

A central fact table is surrounded by denormalized dimension tables.

A manufacturing company wants to analyze production efficiency by shift, machine, and product type. They need to measure output quantity and downtime hours. Which set of dimensions and measures should be included in the data model?

Dimensions: Machine, Product Type; Measures: Shift, Output Quantity, Downtime Hours

Dimensions: Shift, Machine; Measures: Output Quantity, Downtime Hours, Product Type

Dimensions: Shift, Product Type; Measures: Output Quantity, Downtime Hours, Machine

Dimensions: Shift, Machine, Product Type; Measures: Output Quantity, Downtime Hours

Which of the following best describes a 'relationship' in a data model for a data warehouse?

An association between two entities, such as a fact table and a dimension table, that is implemented with keys.

A calculation performed on measures, such as sum or average, during query execution.

A property that describes a characteristic of an entity, such as color or size.

A rule that defines how data is partitioned across storage nodes.

What is the role of dimensions in a data warehouse data model?

They store the raw transactional data that is loaded from source systems.

They store aggregated measures to speed up common queries.

They provide context and descriptive attributes for analyzing measures in fact tables.

They define the storage format and compression for fact tables.

In a data warehouse, what is the primary purpose of partitioning a large fact table?

To reduce the amount of data scanned for queries that filter on the partition key.

To normalize the fact table into multiple smaller tables.

To enforce foreign key constraints between fact and dimension tables.

To increase the number of joins required for queries.

Google CloudProfessional Data Engineer

Domain 3Objective 2

3.2 Planning for Using a Data Warehouse PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 2)

Part of the Storing the data domain, which accounts for ~20% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~10–16 in this domain), expect 3–4 from this objective — we provide 17 practice questions to prepare you well beyond it. (estimate)

17questions here

4free pages

7concepts

~20%of the exam

Questions 6–10

6foundation · easy
What is a characteristic of a star schema?
Select an answer first
7application · medium
A manufacturing company wants to analyze production efficiency by shift, machine, and product type. They need to measure output quantity and downtime hours. Which set of dimensions and measures should be included in the data model?
Select an answer first
8foundation · easy
Which of the following best describes a 'relationship' in a data model for a data warehouse?
Select an answer first
9foundation · easy
What is the role of dimensions in a data warehouse data model?
Select an answer first
10foundation · easy
In a data warehouse, what is the primary purpose of partitioning a large fact table?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-DATA-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-DATA-ENGINEER” is a trademark of its owner, used for identification only.