Preview Questions Data Modeling Concepts | Role Specific Skill

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

Question 2: You need to ensure referential integrity in your ER model. What is your approach?

Which action should you take?

Choose only one option

Use foreign keys to enforce relationships

Define unique constraints on primary keys

Regularly audit the database

Implement triggers to maintain integrity

Question 3: Your data warehouse needs to support complex analytical queries. What is your approach?

Which action should you take?

Choose only one option

Implement OLAP cubes

Use advanced indexing techniques

Optimize the schema design

Use in-memory processing

Question 4: You are designing an ER model for a hospital. How do you represent the relationship between Doctor and Patient if each patient can have multiple doctors and each doctor can have multiple patients?

Which action should you take?

Choose only one option

One-to-One relationship

One-to-Many relationship

Many-to-One relationship

Many-to-Many relationship with an associative entity

Question 5: You need to model the dependencies between software components. Which UML diagram is appropriate?

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 6: You need to model the workflow of a business process. Which UML diagram is appropriate?

Which action should you take?

Choose only one option

Use an activity diagram

Use a sequence diagram

Use a state diagram

Use a class diagram