Preview Questions Data Modeling Concepts | Role Specific Skill

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

Question 3: How do you represent the lifecycle of an object 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: You need to ensure that an attribute in an entity is unique across all instances. How do you enforce this?

Which action should you take?

Choose only one option

Define the attribute as a primary key.

Use a composite attribute.

Use a multivalued attribute.

Define the attribute as nullable.

Question 5: How do you ensure data quality in your dimensional model?

Which action should you take?

Choose only one option

Implement data validation rules

Use ETL processes to cleanse data

Regularly audit and reconcile data

Apply data profiling techniques

Question 6: You need to represent the flow of activities in a system. Which UML diagram do you use?

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