Question 1

You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a

large result set after executing the Joins.

The business is not expecting live data, and a 2-hour refresh is acceptable. Performance is a top priority.

What should you use? (Choose the best answer.)

Options :

A : Table

B : View

C : Stored procedure

D : Materialized view

Answer: C

Question 2

You are analyzing a poorly-performing process model. You find that the process model in question has a lot of nodes and is mainly used to do background updates. Which two things can be done to increase its performance? (Choose two.)

Options :

A : Define the correct alerts for the process model.

B : Remove all activity chaining.

C : Use swim lanes in the process model.

D : Refactor some nodes into subprocesses when possible.

Answer: B,D

Question 3

You need to insert the deleted row of a table into a history table for audit purposes.

What is the most efficient method to achieve this?

Options :

A : Materialized view

B : Process mode

C : View

D : Trigger

Answer: D

Question 4

You are creating an expression rule that will be reused throughout your environment.

What are two benefits of including meaningful test cases when creating a new expression rule? (Choose two.)

Options :

A :

Speed up unit, regression, and exploratory testing.

B : Improve the appearance of the code.

C : Improve performance.

D : Increase code quality.

Answer: A,D

Question 5

Application users are seeing long wait times between two forms they need to complete for a case.

While reviewing the process model, you identify that activity chaining has been used throughout the process

model, including unattended nodes.

Which three actions can you take to make the process model more efficient? (Choose three.)

Options :

A :

Use MNI for unattended nodes and chain where possible.

B : Shorten long process chains by combining transactions into the smallest number of nodes.

C : Avoid chaining system nodes like Integrations.

D : Move transactions that can be done asynchronously outside of the chain.

E : Reduce the number of swim lanes.

Answer: B,C,D