Preview Questions Data Modeling Concepts | Role Specific Skill

Question 1: How do you identify products with sales above the average sales for their category?

Which action should you take?

Choose only one option

Use a window function with AVG()

Use a nested query with GROUP BY and HAVING

Use a CTE with AVG()

Use a subquery with AVG() and GROUP BY

Question 2: What is your strategy for managing database migrations?

Which action should you take?

Choose only one option

Use version control for database changes

Implement rollback procedures

Regularly test migration processes

Use automated migration tools

Question 3: A team member suggests adding redundant attributes to an entity. What do you do?

Which action should you take?

Choose only one option

Explain the drawbacks of redundancy

Implement the suggestion and monitor the impact

Create a separate entity for the redundant attributes

Use derived attributes instead

Question 4: How do you ensure high availability of your data warehouse using a dimensional model?

Which action should you take?

Choose only one option

Implement data replication

Use load balancing

Use failover clustering

Implement backup and recovery processes

Question 5: You need to list all departments that have never had an employee with a salary above $100,000. What is your approach?

Which action should you take?

Choose only one option

Use a nested query with NOT EXISTS

Use a LEFT JOIN with a salary condition

Use a CTE with conditional aggregation

Use a subquery with MAX() and GROUP BY

Question 6: How do you manage database performance?

Which action should you take?

Choose only one option

Optimize queries

Use indexing

Implement caching

Regularly monitor performance