Oracle CPQ 2025 Implementation Professional Sample Questions:

1. Which is allowed in a deployable data table when you create a BMQL query?

A) SELECT, INSERT, and DELETE
B) SELECT and UPDATE
C) SELECT, INSERT, and UPDATE
D) SELECT

2. What is the correct method to add new parts data to the CPQ Cloud database?

A) Export the part data from your current part system into a .csv file, put the .csv file into a compressed zip file, and use Bulk Upload to upload the part data to the CPQ Cloud site.
B) Use the "Import from Source" function in the Migration Center to connect to the remote part system and upload the part data directly to the CPQ Cloud database.
C) Use Bulk Upload to upload the data from the remote part system into a .csv file and import the file into the CPQ Cloud site.
D) Use the "Import from Source" function in the Migration Center to connect to the remote part system and upload the part data into a .csv file, put the .csv file in a compressed ZIP file, and use Bulk Upload to upload the part data to the CPQ Cloud site.
E) Perform a bulk-downloaded of at least one part to capture the part file format that the CPQ Cloud site uses, populate the new part data into the downloaded part file (.csv file), enter "add" in the Update column for each new part, save the spreadsheet as a .csv file, put the .csv file in a compressed zip file, and use Bulk Upload to upload the part data to the CPQ Cloud site.

3. You need to update opportunity revenue lines in CX Sales as part of your Integration with CPQ.
Which integration can you use to cause the opportunity revenue lines to be updated?

A) OSC-REST Upsert Quote
B) OSC-REST Line Sync Update
C) OSC-REST Sync Lines
D) OSC-REST Line Sync Complete

4. There are two single-select attributes in an array set. The first single-select attribute shows a list of countries and the second attribute shows a list of states.
Which is the most efficient way to show relevant states based on chosen country?

A) Load all country and state combinations in a data table and write a Constraint rule to lookup the data table.
B) Create Hiding rules for each country with Simple Conditions, and then select valid states for the Action attribute. In this case, the number of Hiding rules will be equal to the number of countries.
C) Use the Hiding rule, which is the only possible option, because arrays do not do not support Constraint rules.
D) Create a Constraint rule for each country in the drop-down list by using Simple Conditions and select valid states for the Action attribute of the rule. In this case, number of rules will be equal to the number of countries in the list.

5. Which two scenarios are valid for looping by using XSL Snippets? (Choose two.)

A) The grid selector cannot handle the conditions that you need to implement.
B) You want to display a table of single-select, quote-level Commerce attributes.
C) The data needs to be manipulated before being used in loop conditions.
D) The data in the line item grid must be displayed as a table.

Solutions: