When translating business requirements into a data model, what is the first step in identifying dimensions and measures?

Identify the key business processes that produce measurable events.

Determine the indexing strategy for the fact table.

Create the primary keys for all dimension tables.

Define the physical storage format for the fact tables.

A data warehouse designer is evaluating whether to use a snowflake schema or a star schema for a new analytics platform. The business requires frequent updates to product category names and supplier details. Which consideration is most important in this decision?

Star schemas are easier to maintain because they have fewer tables

Snowflake schemas are always more storage-efficient than star schemas

Star schemas are always faster for queries because they have fewer joins

Snowflake schemas reduce data redundancy, making updates to dimension attributes easier and more consistent

Google CloudProfessional Data Engineer

Domain 3Objective 2

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

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 16–17

16foundation · easy
When translating business requirements into a data model, what is the first step in identifying dimensions and measures?
Select an answer first
17application · medium
A data warehouse designer is evaluating whether to use a snowflake schema or a star schema for a new analytics platform. The business requires frequent updates to product category names and supplier details. Which consideration is most important in this decision?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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.

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

Questions 16–17

When translating business requirements into a data model, what is the first step in identifying dimensions and measures?

A data warehouse designer is evaluating whether to use a snowflake schema or a star schema for a new analytics platform. The business requires frequent updates to product category names and supplier details. Which consideration is most important in this decision?

Keep studying — Storing the data