Preview Questions Data Modeling Concepts | Role Specific Skill

Question 1: You need to visualize the dynamic behavior of a system. Which UML diagram do you use?

Which action should you take?

Choose only one option

Use a sequence diagram

Use a class diagram

Use a state diagram

Use an activity diagram

Question 2: 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 3: How do you show the change of states in an object over time in UML?

Which action should you take?

Choose only one option

Use a state diagram

Use a class diagram

Use a sequence diagram

Use an activity diagram

Question 4: How do you model a scenario where an entity can exist independently but can also have optional relationships with other entities?

Which action should you take?

Choose only one option

Use optional foreign keys

Create a separate join table

Define the optional relationships in a different entity

Use subtypes and supertypes to handle the relationships

Question 5: How do you find the difference in total sales between the current month and the previous month for each product?

Which action should you take?

Choose only one option

Use a window function with LAG()

Use a nested query with self-join

Use a CTE with date functions

Use a subquery with date conditions

Question 6: How do you ensure compliance with data regulations?

Which action should you take?

Choose only one option

Implement data governance policies

Regularly audit compliance

Use compliance management tools

Provide training on data regulations