Question 1 of 30
A retail company is designing a data schema to manage its inventory and sales data. They need to ensure that the schema can efficiently handle relationships between products, categories, and sales transactions. The company has multiple product categories, each containing various products, and each product can be sold in multiple transactions. Which of the following approaches best describes how to structure the data schema to optimize for these relationships and ensure data integrity?
Use a star schema with a central fact table for sales transactions linked to dimension tables for products and categories.
Implement a snowflake schema with normalized tables for products and categories, leading to complex joins during queries.
Create a flat file structure that combines all data into a single table to simplify data retrieval.
Design a hierarchical schema that nests products within categories without establishing relationships to sales transactions.

Preparing for SalesForce Certified Data Cloud Accredited Professional Certified Data Cloud Accredited Professional? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free