Preview Questions Data Modeling Concepts | Role Specific Skill

Question 1: You need to retrieve the top 3 salespeople based on their total sales. What SQL statement do you use?

Which action should you take?

Choose only one option

Use a window function with RANK()

Use a nested query with ORDER BY and LIMIT

Use a CTE with ROW_NUMBER()

Use a subquery with GROUP BY

Question 2: You need to ensure that your database design supports future scalability. What normalization approach do you use?

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 support multi-dimensional analysis in your data warehouse. What do you implement?

Which action should you take?

Choose only one option

Use OLAP cubes

Implement a star schema

Use advanced SQL queries

Implement a data mart

Question 4: You need to ensure data consistency in your data warehouse. What is your approach?

Which action should you take?

Choose only one option

Implement ACID transactions

Use data validation rules

Implement data synchronization processes

Regularly reconcile data

Question 5: When should you use a weak entity in an ER model?

Which action should you take?

Choose only one option

When the entity cannot be uniquely identified without another entity.

When the entity has a composite attribute.

When the entity is optional.

When the entity has a multivalued attribute.

Question 6: You need to list all products that have not been sold in the last 6 months. What is your approach?

Which action should you take?

Choose only one option

Use a nested query with NOT EXISTS and date condition

Use a LEFT JOIN with sales table and date condition

Use a CTE with date functions

Use a subquery with date conditions