In a SQL query, which of the following is an example of a complex SQL function?

• A.CONCAT()
• B.UPPER()
• C.DATEPART()
• D.LEN()

Comment: *

Name: *

Email: *

Verification: *

Every day at 1 AM, all the ATM transactions at ABC Bank from the previous day are shared with the head office of the bank. All ATM machines perform this data sharing. ABC Bank uses this information to validate transactions and balance all the ledgers. If any discrepancy is identified, a dispute resolution flow initiates to investigate the root cause and resolve the dispute. ABC Bank has 1 million ATMs for which transactions need to be analyzed for discrepancies. Which one of the following is the optimal solution for gathering the transaction information from all the ATMs?

• A.The ATM machines generate an Excel file of all the transactions and place it in a NAS directory. Pega workflow processes the files using an Advanced agent.
• B.The ATM machines generate an Excel file of all the transactions and place it in a NAS directory. Pega workflow processes the files using a Queue Processor.
• C.The ATM machines generate an Excel file of all the transactions and place it in a NAS directory. Pega workflow processes the files using a Job Scheduler.
• D.The ATM machines generate an Excel file of all the transactions and place it in a NAS directory. Pega workflow processes the files using a Data Set of type File, and feeds the files into a Data Flow.

Comment: *

Name: *

Email: *

Verification: *

A Customer Service application requires customer data assembled from multiple external systems.
The customer data is captured by a parent case. Subcases of that parent case need to reference the same customer data. The customer data must be as current as possible.
Which two options are used as part of the solution? (Choose Two)

• A.Have each subcase load a portion of the customer data prior to updating the parent case.
• B.Use the Snapshot data access pattern to capture the customer data prior to subcase spin off.
• C.Load the customer data in parallel using the Load -Data Page and Connect-Wair methods.
• D.Use the System of Record (SOR) data access pattern when capturing the customer data.

Comment: *

Name: *

Email: *

Verification: *

Consider a scenario in which an insurance company publishes policies and regulations based on many different types of vehicles and has its workflow defined accordingly. The company plans to add more vehicle types in the future.
Which approach best suits this scenario?

• A.Application specialization
• B.Class specialization
• C.Ruleset specialization
• D.Circumstancing

Comment: *

Name: *

Email: *

Verification: *

What are two reasons why you tune some of the Pega out-of-the-box default agents in a production environment?

• A.The agent is preconfigured to run at an optimal time by default.
• B.The agent should not run in production.
• C.The agent runs more frequently than needed.
• D.The agent runs based on node classification.

Comment: *

Name: *

Email: *

Verification: *