Preview Questions Data Modeling Concepts | Role Specific Skill

Question 1: What is your approach to handling schema changes in a database?

Which action should you take?

Choose only one option

Use version control for schema changes

Implement rollback procedures

Regularly test schema changes

Communicate changes to all stakeholders

Question 2: How do you represent a derived attribute in an ER model?

Which action should you take?

Choose only one option

Use a dashed oval and connect it to the entity.

Include it as a regular attribute.

Create a separate entity for the derived attribute.

Use a multivalued attribute.

Question 3: How do you represent a weak entity in an ER model?

Which action should you take?

Choose only one option

Use a foreign key from the strong entity

Define a composite primary key

Create a unique identifier for the weak entity

Implement the relationship in the strong entity

Question 4: 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 5: How do you improve query performance in your dimensional model?

Which action should you take?

Choose only one option

Implement indexing

Use materialized views

Optimize ETL processes

Partition large tables

Question 6: How would you design a dimensional model to handle semi-structured data types?

Which action should you take?

Choose only one option

Use hybrid schema designs incorporating both structured and semi-structured data

Exclude semi-structured data types from the model

Opt for a flat file structure to ensure compatibility

Implement separate data warehouses for structured and semi-structured data types