Preview Questions Data Modeling Concepts | Role Specific Skill

Question 1: A table in your database has multiple candidate keys. How do you ensure proper normalization?

Which action should you take?

Choose only one option

Apply Boyce-Codd Normal Form (BCNF)

Apply Third Normal Form (3NF)

Apply Second Normal Form (2NF)

Apply Fourth Normal Form (4NF)

Question 2: How do you represent the lifecycle of an object in UML?

Which action should you take?

Choose only one option

Use a state diagram

Use a class diagram

Use a sequence diagram

Use an activity diagram

Question 3: How do you represent the internal structure of a class in UML?

Which action should you take?

Choose only one option

Use a class diagram

Use a sequence diagram

Use a state diagram

Use an activity diagram

Question 4: 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

Question 5: How do you handle slowly changing dimensions in a dimensional model?

Which action should you take?

Choose only one option

Use Type 2 SCD

Use Type 1 SCD

Use Type 3 SCD

Implement a hybrid approach

Question 6: How do you calculate the running total of sales for each salesperson?

Which action should you take?

Choose only one option

Use a window function with SUM()

Use a nested query with GROUP BY

Use a CTE with a rolling sum

Use a subquery with aggregate functions