Preview Questions Data Modeling Concepts | Role Specific Skill

Question 1: You need to ensure that an attribute in an entity is unique across all instances. How do you enforce this?

Which action should you take?

Choose only one option

Define the attribute as a primary key.

Use a composite attribute.

Use a multivalued attribute.

Define the attribute as nullable.

Question 2: You need to ensure data integrity and reduce redundancy in your database. What do you apply?

Which action should you take?

Choose only one option

Apply normalization up to Third Normal Form (3NF)

Apply normalization up to Second Normal Form (2NF)

Apply normalization up to Fourth Normal Form (4NF)

Use Boyce-Codd Normal Form (BCNF)

Question 3: You need to manage data lineage in your dimensional model. What do you do?

Which action should you take?

Choose only one option

Implement data lineage tools

Use ETL process documentation

Implement a data catalog

Track data transformations and movements

Question 4: You need to design a data warehouse schema for reporting purposes. What do you use?

Which action should you take?

Choose only one option

Implement a star schema

Use a snowflake schema

Create a hybrid schema

Use a normalized schema

Question 5: You need to find employees who have been with the company for more than 5 years and have never been promoted. What do you do?

Which action should you take?

Choose only one option

Use a nested query with date functions and NOT EXISTS

Use a LEFT JOIN with promotion table

Use a CTE with conditional aggregation

Use a subquery with date conditions

Question 6: What is your approach to designing a database for a distributed system?

Which action should you take?

Choose only one option

Use distributed databases

Implement data replication

Use data sharding

Regularly monitor data distribution