Preview Questions Data Modeling Concepts | Role Specific Skill

Question 1: How do you find departments where the total salary expense is above the company average?

Which action should you take?

Choose only one option

Use a nested query with SUM() and AVG()

Use a window function with PARTITION BY and SUM()

Use a CTE with aggregate functions

Use a subquery with SUM() and AVG()

Question 2: When defining the primary key for an entity, what?s your priority?

Which action should you take?

Choose only one option

Ensure it is unique and not null.

Use an attribute that changes frequently.

Choose an attribute with the smallest data size.

Select an attribute that is a foreign key in another entity.

Question 3: How do you depict the architecture of a system in UML?

Which action should you take?

Choose only one option

Use a component diagram

Use a class diagram

Use a sequence diagram

Use a state diagram

Question 4: How do you handle large volumes of data in your database design?

Which action should you take?

Choose only one option

Use partitioning

Implement archiving policies

Use compression techniques

Regularly monitor data growth

Question 5: 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 6: You need to track data lineage in your data warehouse. 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