wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Exam 1Z0-1033-23 Reviewer

Total questions: 92

Worksheet time: 46mins

Name
Class
Date
1.

Consider following requirements for integration with salesforce:

-  Quote information needs to be pushed back to salesforce and  
   synchronized

-  You must be able to synchronize a Quote up to 1,000 lines back
   to the Opportunity Product object in Salesforce

 

Based on this requirement, which three XSLs would you use to provide the integration?

a)

SFDC Opportunity - Import

b)

SFDC Quote – Upsert

c)

SFDC Products - Upsert All (200, 400, 600, 800, 1000)

d)

SFDC Quote - Process Updates

e)

SFDC Opportunity – Upload

2.

Given the following code:

xmlPayload = ""<?xml version=""1.0"" encoding=""UTF-8""?><library><book lang=\""en\"">Spring in Action</book><book lang=\""fr\"">J2EE Blueprint</book></library>"";

xpaths = string[1];

xpaths[0] = ""/library/book/@lang"";

output = readxmlmultiple(xmlPayload, xpaths);

 

for xpath in xpaths {

print(""(key) = ("" + xpath + "")"");

 

values = string[1];

values = get(output, xpath);

 

for value in values

{ print("" (value) = ("" + value + "")""); }

}

return “”;

What will be returned? Choose one.

a)

 (key) = (/library/book/@lang)

    (value) = (en)

    (value) = (fr)

b)

(key) = (/library/book/@lang)

    (value) = (Spring in Action)

    (value) = (J2EE Blueprint)

c)

(key) = (/lang/book/library)

    (value) = (en)

    (value) = (fr)

d)

(key) = (/library/book/@lang)

    (value) = (English)

    (value) = (French)

3.

Identify two reasons why some or all transactions in a particular step are hidden for a user in Transaction Manager.

a)

All participant profiles of this step have group access defined and the "Performer Step" set, and the user did not perform an action on the hidden transactions in other steps.

b)

The step has an auto-forwarding rule, which did not return the user or one of his groups and all participant profiles do not have other permission methods selected.

c)

The participant profile that is valid for this user has the Document Views tab, the Document Views panel, and the "Entire Document" = "hide" setting.

d)

A hiding rule was defined in commerce rules.

e)

There is no valid participant profile for this user with hidden transactions.

4.

Identify three values that you can find in the Usage Metrics Report for the last month

a)

A list of active partner organization users with the most recent login date and time and the number of logins.

b)

The number of transactions for different Commerce processes created by internal users and partner organization users.

c)

The total number of partner organizations and the number of active partner organizations.

d)

The total data size of the CPQ site occupied on the server.

e)

The number of logins by internal users in the last 30 days and the percentage of active users logged in.

5.

The data table "Related Parts" is present in QA environment and in production environment. The table has 3000 records in QA environment and 4000 records in production.

How many records will be present in the data table in Production if this table is migrated over from QA?

Choose one:

a)

1000

b)

 3000

c)

4000

d)

7000

6.

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

Choose one:

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)

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.

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)

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.

7.

What would you do if a partner organization is no longer needed, and the access of all users need to be removed?

a)

Open the list of partner organizations and set the value of Maximum Users to “0”.

b)

Go to the list of partner organizations, perform a proxy log in as the superuser of the partner organization, go to the list of users, select all active users, and click Inactivate.     

c)

Proxy log in as superuser, go to the list of partner organizations, and select the partner organization and delete it.

d)

Proxy log in as superuser, go to the list of partner organizations, and select Denied in the Access drop-down list.

8.

Which three-page types have predefined page templates?

(Choose three.)      

a)

Process Document List Page

b)

Product Line List Page

c)

User Administration List Page

d)

Parts Search Page

e)

Model List Page

9.

Which two items are necessary to migrate between environments?

(Choose two.)

a)

Environments must be on the same minor release (for example, 2016R2 update 2).

b)

Administrators must have FullAccess logins for both environments.

c)

Entities to be migrated must be deployed within 24 hours of the migration.

d)

Environments must be on the same major release (for example, 2016R2).

e)

Environments must have similar urls (for example, test customer and dev customer

10.

Your customer wants to create a user that has complete access to the site and has the ability to add and edit new users. Which procedure should you follow to accomplish this?

Choose one:

a)

Click the Add button on the User Administration List page, set the Type field to Admin, click the Add button to add the user to the system, click the new user's name on the User Administration List page to edit the user, select the Create/Modify Users check box, and click the Update button to save the changes.    

b)

Click the Add button on the User Administration List page; enter values for the required fields (Login, Email, and First Name); click the Add button to add the user to the system; click the new user's name on the User Administration List page to edit the user; select the Create/Modify Users check box; and click the Update button to save the changes.      

c)

Click the Add button on the User Administration List page; enter values for the required fields (Login, Email, and First Name); set the Type field to FullAccess; click the Add button to add the user to the system; click the new user's name on the User Administration List page to edit the user, select the Create/Modify Users check box; and click the Update button to save the changes.

d)

Click the Add button on the User Administration List page; enter values for the required fields (Login, Password, Email, First Name, Last Name, and Phone Number); set the Type field to Admin; click the Add button to add the user to the system; click the new user's name on the User Administration List page to edit the user; select the Add New Users check box; and click the Add button to save the changes.       

e)

Click the Add button on the User Administration List page; enter values for the required fields (Login, Email, and First Name); set the Type field to FullAccess; select the Create/Modify Users check box and click the Add button to add the user to the system.

11.

What are the types of Migration modes? (Choose 3)         

a)

Import from Source

b)

Import from Package

c)

Connect to Destination

d)

Bulk Upload

12.

. Given this code:

results = bmql("modify table1 set column1 = 'new_value1', column2 = 'new_value2' where column1 = 'old_value1'");

the results is:

a)

result is a record set with two integer entries, one with the number of rows modified and one with the number of rows added.

b)

result is a record set with one integer entry, one with the number of rows modified and one with the number of rows added.

c)

result is a record set with two integer entries, one with the number of columns modified and one with the number of columns added.

d)

result is a record set with one integer entry, one with the number of columns modified and one with the number of columns added.

13.

Which two fields are required when adding a new user to the CPQ Cloud site? (Choose 2)

a)

Last Name

b)

Type

c)

Email

d)

First Name

14.

Which of the following are Bulk Recommendation property? (Choose 4)

a)

Attribute to Populate

b)

Value to Populate

c)

Columns to Populate

d)

Set Type

e)

Message to User

15.

Which type of user can grant a user account access to create and modify users in CPQ?

a)

Root with Create/Modify Users selected

b)

FullAccess with Create/Modify Users selected

c)

Superuser with Create/Modify

d)

Administration with Create/Modify Users selected

16.

Which of the following Deal management feature requires to be added in a data column?

a)

Last Price Paid

b)

Win Probability

c)

Deal Comparison

d)

Price Score

17.

The following BML code encountered a HTTP 404 error from someurl.com. Which two statements are true?

urldatabypost("http://someurl.com", "a1=v1&a2=v2", "call failed")

a)

The HTTP error will be captured in the BigMachines Error Logs: bm.log.

b)

An HTTP error will display at the top of the configuration screen in red text stating “HTTP 404 Not Found”.

c)

The call will return value “HTTP 404 Not Found”

d)

An unhandled exception will be displayed in red text at the top of the configuration screen.

e)

The call will return “call failed”

18.

Which one of the following statements is true? Select two.

a)

BigMachines provides out of the box integration with Salesforce and Oracle Sales Cloud.    

b)

Web Services is used for CRM integration but not for ERP integration.

c)

ICS and OIC are two of the tools used to integrate ERP and CRM systems.

d)

BigMachines has its own middleware tool to integrate with external CRM and ERP applications.

19.

The pricing function invokes a Util library function applyDiscounts() which applies discounts on the distributor price, reseller price and the end-customer price and returns the discounted values back to the pricing function. Which three of the below approaches can be used to pass these values back to the pricing function?

a)

Return the values using multiple "return" statements.

b)

Construct return result string in the below format and return this string: documentNumber~variableName~value [ |documentNumber~variableName~value ]*

c)

Add all values to an array and return the array.

d)

Add these values to a dictionary along with appropriate keys and return this dictionary.

20.

How can you prevent users with the RestrictedAccess user type from creating a new transaction using Transaction Manager?

Choose one:

a)

Open the Commerce Process admin page, navigate to Process Manager, click Access Rights, and make sure that RestrictedAccesss user type is not selected.

b)

Go to the Commerce Process admin page and open the participant profiles of the start step. Remove all user access rights entries for RestrictedAccess

c)

Open the Commerce Process admin page, navigate to Process Actions, click Access Rights for the New Transaction action, and remove all company type and user type RestrictedAccess entries.

d)

Navigate to the Process Invocation admin page and remove the user access rights entries for RestrictedAccess for all pages.

21.

BigMachines provides integration guides and/or easy to install application packages for the following applications? Select three.

a)

Oracle Sales Cloud

b)

Microsoft Dynamics 365

d)

Oracle on Demand

22.

Select which of the following are Delete Behavior of Foreign Keys

a)

On Delete notify Admin

b)

On Delete Set Cascade

c)

On Delete No Action

d)

On Delete Set Error

e)

On Delete Set Null

23.

Which statement is a proper definition of a Punch-In?

a)

Punch-Ins are links that hook into a specific Commerce process in the system. They can be used to navigate directly to a given Commerce process in your application. They can also be used to jump into a specific Commerce process from an external website.

b)

Punch-Ins are links that hook into specific product families in the system. They can be used to navigate directly from a product family to another in your application. They can also be used to jump into a specific product family from an external website.

c)

Punch-Ins are links that relate into specific parts in the system. They can be used to search directly for a given part in your application. They can also be used to search for a specific part from an external website.

d)

Punch-Ins are links that hook into specific pages in the system. They can be used to navigate directly from one page to another in your application. They can also be used to jump to a specific page from an external website.

e)

Punch-Ins are buttons that take you to specific pages in the system. They can be used to navigate directly from one page to another in your application

24.

Which access can be restricted/Allowed under Admin Group access control? (Choose 2)

a)

Proxy in as other users

b)

Product Families

c)

Access the Document Designer

d)

Data Tables

e)

Access the Migration Center

25.

To add items (parts) to a configuration, Recommended Item rules are used. Which two statements are true when using Recommended Item rules?

a)

Recommended Item rules can return only the base price of an item (part) and cannot use dynamic prices based off data tables.

b)

If multiple Recommended Item rules recommend the same item (part), the item (part) price is picked from the rule that is last in the order.

c)

If multiple Recommended Item rules return the same item (part), the quantity of the item (part) is a total of all quantities returned by each rule.

d)

Recommended Item rules can show only the base prices defined in the customer specific module.

26.

Which Configuration Flow would you choose to design a Configurator where attributes very based on prior user selections and have a sequential relationship consisting of distinct steps?

a)

Multi Node Configuration Flow

b)

Search Flow

c)

Master Start and End Flow

d)

any Configuration Flow with a combination of Constraint and Hiding rules that meets requirements

27.

Your customer has sales organizations in two countries. The customer wants to make sure that users from one country have access only to quotes from that country, how do you achieve this?

a)

Define different steps (for example, Pending A and Pending B) for each country. The participant profile of each step allows access through user groups (either Group A or Group B depending on the step) Using transition rules, make sure that quotes for Country A are always moved to steps belonging to that country.

b)

Hide Transaction Manager in CPQ and make sure that all access to quotes is performed from the CRM system where you can easily define which quotes should be visible for different users.

c)

Define two groups: Country A and Country B. Define a participant profile, Sales, for each step. Define an auto-forwarding rule which returns either "Group A~company~Sales" or "Group B-company~Sales.

d)

Define two groups: Country A and Country B. For each step, define two different participant profiles Profile A and Profile B. For each profile, select one matching group.

28.

You want to perform a configuration migration from a development site to a QA site. What is the Oracle-recommended way to accomplished this?

a)

Using a DB Link, log in to the development site through the Migration Center section, select the components that need to be migrated, and start the migration.

b)

Open Migration Center in the development site, log in to the QA site through the Migration Center section, select the components that need to be migrated, and start the migration.

c)

Open Migration Center in the QA site, log in to the development site through the Migration Center section, select the components that need to be migrated, and start the migration.

d)

Download the components that need to be migrated from the development site and upload them to the QA site

30.

The Related Parts data table exists in the QA environment and in the production environment. The table has 3,000 records in the QA environment and 4,000 records in the production environment.

How many records will be present in the data table in the production environment if this table is migrated from the QA environment?

a)

7,000

b)

3,000

c)

4,000

d)

1,000

31.

Which statement is FALSE about Live Data Tables?

a)

Webservices is recommended to update Live Date Tables over BMQL functions

b)

Live Data Tables don’t need to be deployed after modification

c)

INSERT, MODIFY, DELETE, and UPDATE are supported BMQL functions on live data tables

d)

Live Data Tables can be modified using UI, Webservices, BMQL function, and Bulk Uploads

32.

Select two statements that are true about Test Script found in a function debugger. (Choose two.)         

a)

Test Script is template of how the BML function should be written.

b)

Test Script provides a way to test a BML Library function when array type attributes are input parameters.

c)

Test Script describes the various functions used in BML.

d)

Test Script can be used to compute multiple iterations of the library functions and print each.

33.

You have a menu attribute with 5 selections. Depending on the choices, you have 3 choices shown. What could be the reason for this?

a)

Recommendation Rule

b)

Constraint

c)

Hiding Rule

34.

How do you hide action buttons in Commerce?

a)

by using Commerce hiding rules

b)

by using Configuration hiding rules

c)

by using profiles and steps in Commerce

d)

by putting the action button bar on a hidden tab in Commerce

35.

Which three attribute types are available for mapping to price attributes in the CPQ Pricing/Rating Engine?

a)

Configuration Attribute

b)

Integration Attribute

c)

Parts Attribute

d)

Commerce Attribute

e)

Data Table Attribute

36.

Price Gauge values can be populated in which three ways?

a)

using Scatterplot analytics

b)

using Win Probability analytics

c)

using Price Guidance analytics

d)

current price or discount

37.

If BOM price is defined as <<BLANK>>, what is the default price definition?

a)

Parts DB price

b)

Configurable Price

c)

Unit Price

d)

List Price

38.

Which two items are not included in an environment refresh?

a)

Automated FTP upload to CPQ schedule

b)

Active sessions       

c)

Users

d)

Commerce transactions

e)

Configuration administration

39.

When creating a connection for a CPQ SOAP Endpoint in ICS, which format is expected?

a)

https://<siteURL>/v2_0/receiver/commerce/oraclecpqo?WSDL

b)

https://<siteURL>    

c)

https://<siteURL>/ics/catalog

d)

https://<siteURL>/vl/receiver?WSDL

40.

In which two locations are the keywords for mobile processing of quotes defined when setting up approvals?

(Choose two)

a)

Submit sub-action - Submit for Approval

b)

Submit sub-action-Approve

c)

Submit sub-action - Reject

d)

Mobile Approval Email Notification

41.

You want to control the information that can be viewed on the transaction page. What must you create to accomplish this?

a)

Constraint Rules

b)

Transition Rules

c)

Participant Profiles

d)

Internal User Definitions

e)

Library Functions

42.

Which of the following will return additional 1000 records?

a)

<url>?limit=1000

b)

<url>?totalResults=1000

c)

<url>?offset=1000

d)

<url>?set=1000

43.

Select which of the following are notification approval used in Mobile Approval

a)

Default Approval Notification

b)

Rich text Approval Notification

c)

Advance Approval Notification

d)

SMS Approval Response

e)

Custom Approval Notification

44.

Which three types of Quotes are available as a standard feature of the Salesforce Connector?

a)

Standard/Loose Quote

b)

Opportunity Quote

c)

Contact Quote

d)

Account Quote

45.

A multi-select attribute with five options is displayed as check boxes. Depending on the conditions, the Configurator should show a user three of these five options. How do you accomplish this?

a)

by writing a Constraint rule

b)

by writing a Hiding rule

c)

by writing a Recommendation rule

d)

by writing a Pricing rule

46.

What are three valid reasons for a Configuration rule failing to execute? (Choose three.)

a)

A runtime error occurs within the rule, which is firing before the current rule.

b)

The status of the rule is set to Inactive.

c)

The rule's Condition attributes are hidden in Configuration Layout.

d)

The attributes used in the rule are not added in Configuration Layout.

47.

Using standard functionality, how do you prevent a user from manually adding or removing rows in an array set?

a)

by using CSS to hide icons

b)

by hiding the control attribute

c)

by hiding the control attribute and marking it as a forced set

d)

by selecting the "Disable user override" property on the configurable array set editor page

48.

An administrator tries to change the document views on an attribute from a participant profile on a given step. But the attribute is not listed in the list of attributes that are available for editing.

What are two reasons for this behavior? (Choose two.)

a)

The attribute is being referenced in an active Hiding rule.

b)

The attribute is not added to the layout.

c)

The attribute is hidden on the Attribute Details page.

d)

The attribute is a system attribute.

49.

Which statement correctly applies to Foreign Keys in Data Tables?

a)

Foreign Keys can only be created on new Data Tables

b)

A maximum of 10 Foreign Keys can be created

c)

Foreign Keys can only be created from Integer columns

d)

Foreign Keys can be created using any Data Tables

e)

Foreign Keys can only be created between 2 Data Tables

50.

An external application like a custom e-commerce portal or Oracle CX Commerce needs to send the configuration attributes information in a secured manner through both a Model Punch-in URL and inside a REST API. Which three steps are required to set up the signed punch-in attributes in CPQ?

a)

Assign passwords to the external sites and pass those to CPQ via the Model Punch-in and/or REST API

b)

Punch-in or REST API are executed

c)

Upload a public key in the CPQ integration center page

d)

Generate Access token

e)

Provide Access token data      

51.

What three types of email notifications can be sent to mobile approvers from Oracle CPQ Cloud?

a)

Default Approver Template Notifications

b)

Custom Approver Template Notifications

c)

SMS Notifications

d)

Rich-Text Notifications

e)

Advanced Notifications

52.

In which table are BOM pricing defined?

a)

BOM Item Mapping

b)

BOM Item Definition

c)

BOM Attribute Mapping

d)

BOM Attribute Definition

53.

Given the following code:
strl = ""   1483.30    ""; result = _____(strl);
return result;

Which function, when put in the blank space, will return the value as "1483.30"?

a)

trim

b)

cut

c)

substring

d)

removewhitespace

54.

Which three can Administrator Groups be used to do?

a)

Restrict access to individual Data Table Folders

b)

Restrict access to specific Actions and Attributes on a Transaction (Quote)

c)

Restrict access to specific Transactions (Quotes)

d)

Restrict access to the Document designer

e)

Restrict access to the Migration Center

55.

A full access user can see Administrator Groups but cannot create or make changes to them. What would cause this issue?

a)

The user is not a member of an Administrator Group that has access to the Groups admin pages.

b)

The user does not have the Access Administrator permission.

c)

The user is not a member of an Administrator Group that has access to the Users admin pages.

d)

The user does not have the Add/Modify Users permission

e)

The user is a Restricted Access user.

56.

What is supported for Foreign Key Definition?

a)

a defined Natural key column within a child Data Table

b)

a defined Natural key column within a parent Data Table

c)

the CPQ Parts table

d)

any Integer column in a Parent Data Table

57.

The Subscription Management Integration is designed to support which two types of business process?

a)

Quote to cash for all products and services

b)

Selling recurring-price based products and their billing management

c)

One-Time purchases of hard goods

d)

Lead to cash for all products and services

e)

Quote to cash for non-tangible products and services

58.

Which statement is true for Version Control System that can be used with Developer Toolkit Command Line-Interface (CLI)?

a)

Developer's Toolkit only supports the use of Subversion (SVN) and Microsoft Team Foundation

b)

Developer's Toolkit only supports the use of Github Version Control and Subversion (SVN)

c)

Developer's Toolkit can be used with any version control system of the user's choice

d)

Developer's Toolkit only supports the use of Github Version Control

59.

Which three Deal Management feature requires Data Columns for the CPQ attributes to be used as inputs?

a)

Deal Comparison scatterplots

b)

Price Optimization

c)

Last Price Paid

d)

Win Probability

e)

Price Scores

60.

How are target, start, and floor price used?

a)

Define whether a price or discount will be approved by management    

b)

Guide users on the desirability of a configuration

c)

Provide guidance on where to start and stop when negotiating pricing

d)

Communicate the historical pattern of pricing on similar quotes

e)

Indicate whether a price is profitable

61.

You want to create a Price Gauge to guide users in setting the optimal discount for a quote. What is the correct procedure in the relevant Commerce Process?

a)

View the main document attributes, create a new price gauge attribute type, select the gauge input attribute

b)

. View the main analytics, create a price guidance analytic, associate the analytic, associate the analytic to an HTML attribute

c)

View the main analytics, create a Scatterplot Analytic, associate the analytic to a Price Gauge attribute

d)

View main document attributes, create a new HTML attribute, associate a price gauge visualization, select the gauge input attributes

e)

View the Sub document attributes, create a new integer attribute, select the gauge input attributes

62.

In an implementation of CPQ, there is an existing setup for System Configuration with the initialization feature enabled in Configuration settings page. Under what three circumstances would the initialization cause partial configuration of models in the System Configuration?

a)

When the number models setting is lower than the number of models in the system

b)

When the depth of descendant models setting is higher than the number of descendant levels in the system

c)

When the number models setting is higher than the number of models in the system

d)

When the depth of descendant models setting is lower than the number of descendant levels in the system

e)

When a particular model has a multi-layout configuration flow

63.

The Production CPQ site is on the 19B release. Recently the Non-Production development site refreshed to the 19D Base Ref App  release. As an administrator, you need to migrate different entities between these sites. How do you accomplish this?

a)

Use the Import from Source mode to migrate items from the 19D non-Production site to the 19B Production site

b)

Export a package from the 19D non-production site and import into the 19B production site

c)

Connect both Production and Non-Production site to run the whole site migration

d)

Export a package from the 19B production site and import in into 19D non-production site

64.

When defining a Line-level Price Guidance Analytic, which four steps are required?

a)

Choose whether to use historical percentages or offsets from optimal discounts   

b)

Filter the input data by Part Number

c)

Define the Price Gauge that will use the Price Guidance values

d)

Set up Data Columns for attributes used as filter attributes

e)

Select the Actions on which the Analytic will be recalculated

65.

Which three editing modes are available on the Commerce Process?

a)

Single User

b)

Multiple User

c)

Concurrent Configurable Access

d)

Transaction Locking

e)

Collaborative Editing

66.

Given the following code:

 

strArr1 = [] {""1"",""2"",""3""};

strArr2 =______________;

return strArr2;

 

Which statement, when placed on the blank, will give strArr2 a value of "123"?

a)

combine{"" , strArr1}

b)

combine{strArr1, ""}

c)

join{strArr1, ""}

d)

join{strArr1, "  "}       

67.

Your non-production CPQ site upgraded to version 19D

Which three packages can be migrated to the non-production site in the Migration Center UI?

a)

19A

b)

19B

c)

19C

d)

18D

e)

20A

68.

Which three are valid setup choices for Commerce Hiding rules involving Transaction Array attributes?

a)

When the rule condition has array attributes, the Simple Components to Hide attributes can have array attributes from another array set

b)

When using Advanced Components to hide, the array expected to be returned from the BML needs to be declared explicitly in the Hiding Rule

c)

When the rule condition is any of the following (a)always true, (b)advanced condition, (c)simple condition without array attributes, the action attributes cannot have array attributes from multiple array sets.

d)

Hiding rule condition can contain array attributes from more than one array sets   

e)

When the rule condition is any of the following (a)always true, (b)advanced condition, (c)simple condition without array attributes, the action attributes can have array attributes from multiple array sets.

69.

An existing customer of CPQ likes to embed CPQ Configurator within Oracle CX Commerce. Which three steps should the administrator/implementer consider?

a)

Setup a BML function to generate and return Configuration Integration payload to the Oracle CPQ.

b)

Provide an endpoint URL to return/redirect to the Oracle CPQ Cart Page

c)

Setup a Server-side integration at the Product Family level

d)

Setup a BML function to generate and return Configuration Integration payload to the Oracle CX Commerce Chart

e)

Setup a client-side integration at the Product Family Level

70.

Which three are valid setup steps for implementing subscription pricing and/or discounting schemes?

a)

Define subscription changes and/or charge values that can be applied to all transactions or customers                 

b)

Define subscription changes and/or charge values that can be applied selectively to a subset of transactions

c)

Define predefined discounts that can be selectively applied to any charge or charge-type

d)

Define predefined discounts that can only be applied to all charge-types

e)

Foreign Keys can only be created between 2 Data Tables

71.

When implementing System Configuration, which statement is FALSE?

a)

The same model cannot exist more than once

b)

When implementing System configuration, the recommended first step is to convert Recommended Item Rules to BOM Mapping rules 

c)

One of the recommended use case for System Configuration is bundled product offerings

d)

System configuration is fully compatible with Subscription Ordering

72.

Given: You have a scenario where the Pricing Engine is enabled and there are multiple pricing profiles defined containing the same part/item numbers multiple times. Now if these profiles are linked to multiple pricing rules, in order to determine the price value, what will the pricing engine do?

a)

It derived the price from the first rule and an average price from all the linked profiles

b)

It calculated the average by aggregating the price points of all the rules and the first profile within each rule

c)

It derived the price from the first rule and the first profile within the rule

d)

It aggregates the price points from each rule and calculates the average

73.

Minimum # of transactions for Win Probability/Price optimization machine learning model

a)

200

b)

1000

c)

35

d)

0

e)

30

74.

3 BOM tables required to map BOM Items and Commerce Config Attribute

a)

BOM Attribute Mapping

b)

BOM Item Mapping

c)

BOM Attribute Translation

d)

BOM Attribute Definition

e)

BOM Item Definition

75.

If no identifier information is available in an excel file, previously being exported from Transaction Line-Item Grid, which of the following information can be imported into the Line-Item Grid?

a)

Sales BOM-mapped line items

b)

Information cannot be imported

c)

Only the model hierarchy - including the child line items

d)

Any sales and manufacturing BOM line items

e)

All line items in the Line-Item Grid - with the warning informing the user of the missing identifier information

76.

You want to control the information that can be viewed on the transaction page.

What must you create to accomplish this? (Choose 2)

a)

Constraint Rules

b)

Transition Rules

c)

Participant Profiles

d)

Internal User Definitions

e)

Library Functions

77.

If no identifier information is available in an excel file, previously being exported from Transaction Line-Item Grid, which of the following information can be imported into the Line-Item Grid?

a)

Sales BOM-mapped line items

b)

Information cannot be imported

c)

Only the model hierarchy - including the child line items

d)

Any sales and manufacturing BOM line items

e)

All line items in the Line-Item Grid - with the warning informing the user of the missing identifier information

78.

Which three statements are correct about configuring several child models within System Configuration?

a)

You are able to clone child models from one root model to another

b)

You are able to add the entire System Configuration to favorites from the root model

c)

Child model configurations can have different statuses such as Error, Warning, Completed or Invalid

d)

You are able to configure a single child model without the root model

e)

CSS customization is allowed for the status icons for the child model configurations

79.

Your customer wants to bulk-download information about Parts, Serial Numbers, and Data Tables and save it to his or her workstation. What is the correct procedure to accomplish this task?

a)

Click Download on the Admin Home Page, click the Parts radio button, and click the Download button. After the download is completed, you can click the Part Link on the Download Status page to save the downloaded data to your workstation. This process should then be repeated for both Serial Numbers and Data Tables.

b)

Click Download on the Admin Home Page; select Parts, Serial Number, and Data Tables options; click the Next button; choose the Download Format; choose any Search criteria and click the Download button. After the download is completed, you can click the file link on the Download Status Page to save the downloaded data to your workstation.

c)

Click Download on the Admin home page, click the Parts radio button , click the Next button, choose the Download format, choose any Search criteria, and click the Download button. This process should then be repeated for both Serial Numbers and Data Tables.

d)

Click on the Admin home page, click parts radio button, click the Next button, choose the Download Format, choose any Search Criteria, and click on the Download button. After the download is completed, you can click the Part Link on the Download Status page to save the downloaded data to your workstation. This process should then be repeated for both Serial Numbers and Data Tables.

e)

Click Migration on the admin home page, click parts radio button, click the Next button, choose the Download Format, choose any Search criteria, and click the Download button. After the download is completed, you can click the Part link on the Download Status page to save the downloaded data to your workstation. This process should then be repeated for both Serial Numbers and Data Tables.

80.

Which two commerce tools/functionality can an administrator use to allow and/or restrict the Transaction line item for end users?

a)

Constraint Rule

b)

Participant Profiles within Steps

c)

Validation Rule

d)

Recommendation Rule

e)

Filter-type Rule

81.

Which two options are true about Price Books?

a)

Are Preferred when there are price variations for the same product by the region

b)

Independently support very complex price calculations

c)

Enable association of one part with multiple prices

d)

Are recommended when there is only one list price per part

82.

Along with Part Number, Quantity and Price, you also want to send recommended item details from Configuration to Commerce by using a Recommended Item rule.

Which two options enable you to achieve this? (Choose two.)

a)

Use the Comment field to pass additional details.

b)

Pass the additional details by storing them in a Price Book.

c)

This is not feasible, only part number, quantity and price can be passed from Config to Commerce.

d)

Concatenate the additional details to Part Number

e)

Use BOM Mapping rules

83.

Your customer has both Salesforce and CPQ and would like to achieve the following:

 

• Select one parts master to hold all of the parts data.

• Provide the ability to upload and download parts data.

• Have a corresponding price book entry for each part.

• Ensure that the parts are available for currently integrated external systems.

• Ensure that the parts data is available for reporting to the entire product development team, without purchase of extra licenses of CPQ Cloud.

 

Based on these requirements, which two options should you choose to design and implement the parts master?

a)

Integrate each external system with CPO Cloud's Parts APIs and use CPQ Reporting Manager.

b)

Store all the parts data in Salesforce and use the Salesforce Data Loader tool to upload and download the parts data.

c)

Store the parts data in CPQ Cloud and use the Bulk Data service to upload and download the parts data. Use the price book associations for each part.

d)

Use the Salesforce price book and reporting and use the Salesforce Data APIs to make all the parts data available for use in other external systems that are integrated with Salesforce.

84.

Based on default values, which statement is FALSE about automatic FTP (File Transfer Protocol) processing in CPQ?

a)

You must list files in the order in which they should be processed in the upload_list.xml file.

b)

FTP uploads are processed every 90 minutes.

c)

You must upload files to the automated folder on the FTP server.

d)

You can use the Bulk Data service to extract the file format and upload it via FTP automation.

85.

Given the following JSON: jsonString="{\"asset101\":{\"lines":[{\"documentNumber":\"45\",\"quantity\":\"3\", "price":9.1},{\"documentNumber\":\"40\",\"quantity\":\"30\",\"price":62}], \"finalDate\":null, "finalAction\":\"UPDATE\",\"available ":true}}";

Which option gets the reference of a JSON object with a specific Document Number 40?

a)

jobjLine=jsongetsingle(jobjAsset,"$..lines[?
   
@.documentNumber=='40")]","json");

b)

jobjLine=jsonpathgetsingle("$..lines[?(@.document
   
Number=='40'))","json"jobjAsset);

c)

jobjLine=jsonpath.getsingle(jobsAsset,"$.lines[?
   
(@.documentNumber=='40'))","json");

d)

jobiLine=jsonpathgetsingle(jobjAsset,"$..lines[?
   
(@.documentNumber=='40"))","json");

86.

Which code statement will add a new record into a Live Data Table?

a)

bmql("insert into parts (part_number, part_price) values (A812DP', 'A845HQ').(14, 209)");

b)

bmql("insert into parts (part_number, part_price) values ('A812DP', 14),("A845HQ', 209)");

c)

bmql("insert into parts (part_number) values (A812DP', 14),("A845HQ', 209)");

d)

bmql("insert into parts (part_price) values ('A812DP', 14),( 'A845HQ', 209)");

87.

Which is the correct procedure for adding multiple files to File Manager in a single step?

a)

Click File Manager on the Admin home page, click the Browse button next to "Browse for ZIP File," identify the zip file to upload, and click the Add/Update Files button.

b)

Click File Manager on the Admin home page, select the folder where you want to store the new files, click the Browse button next to "Browse for ZIP File:", identify the zip file to upload, and click the Add File button.

c)

Click File Manager on the Admin home page, select the folder where you want to store the new files, click the Browse button next to "Browse for ZIP File:", identify the zip file to upload, and click the Add/Update Files button.

d)

Click File Manager on the Admin home page, select the folder where you want to store the new files, click the Browse button next to "Browse for ZIP File:", and click the Add/Update Files button.

88.

How do you modify a specific FullAccess user's access rights (grant access or remove access) to Product Families, Supported Product Families, and Data Table folders when the Enable Administrator Groups setting is set to NO?

a)

Use the Navigation Menus item on the Administration home page to grant or remove access to specific Product Families or Data Table folders for the user.

b)

Go to the Product Family definition or the Data Table folder properties for which you want to grant or remove access, click the Access Permissions tab, select or deselect the check boxes related to the users you want to grant access to, or remove access from for this Product Family or Data Table folder.

c)

Click the Group name on the Group Administration List page that has this user as a member, click the Access Permissions tab, select or deselect the check boxes related to the items you want to grant access to or remove access from for this user.

d)

Click the user's name on the User Administration List page to edit the user, click the Access Permissions tab, select or deselect the check boxes related to the items you want to grant access to or remove access from for this user.

e)

For each Product Family or Data table folder affected, click the Modify tab for that item and then select or deselect the check boxes related to the users you want to grant access to or remove access from for this Product Family or Data Table folder.

89.

The commerce step "Pending" has four participant profiles in the following order: SalesRep, Sales Manager, Owner, and Admin.

 

The Admin profile allows access with the FullAccess user type.

The Owner profile has at performer steps "start" step selected.

The step has an auto-forwarding rule.

A FullAccess user with the Sales GroupA and Sales Manager A groups creates a new quote and saves it, which moves the quote to "Pending."

 

The auto-forwarding rule returned the following two lines:

 

Sales ManagerA~Company~Sales Manager

Sales GroupA~Company~SalesRep

 

Which profile will be used to display the quote in the "Pending" step to this user?

a)

Admin profile

b)

Owner profile

c)

Sales Rep profile

d)

Sales Manager profile

90.

The marketing department of an organization wants all the sales users to include certain promotional material with the sales proposal documents originating from CPQ quotes. These collateral documents, though not product specific, should only be included once if a quote contains Product X and/or Product Y. The documents are hosted at a common accessible location, which regularly gets updated with new content from marketing.

 

What three steps can an administrator take to address this requirement?

a)

Reference the source URLs for the promotional material in a text area attribute at transaction level.

b)

Add a Section layout which loops over all line items filtered to select Product X and/or Product Y, with an Embed Document element mapped to the attribute containing the document source URLS.

c)

Add a global XSL variable of type Boolean, to check if the quote contains either of Product X or Product Y, and set it to true; otherwise, false.

d)

Drag and drop the Embed Document element in a Section layout. Add a loop on the element to iterate over all the line items filtered to select Product X and/or Product Y.

e)

Add a condition on the Embed Document element to show it on the output document only if the global variable's value is true. Reference the attribute containing the document source URLs in the Document Map Attribute option of element.

91.

Your customer requires a setup for a Product Family that consists of three products that are sold individually in three different markets (North America, Asia Pacific, and Europe). All three products are identical in configuration, except for a few properties, such as Power Cord, Power Input, and Voltage.

 

What is the optimal way to set up the configurator?

a)

Create three Product Families. Set up the Product Lines and a Model for each of the Product Families. Create the attributes and rules at the Model level.

b)

Create three Product Families. Set up the Product Lines and a Model for each of the Product Families. Create the attributes and rules at the Product Family level.

c)

Create one Product Family. Set up one Product Line and three Models under that Product Line. Create all common attributes and rules at the Product Line level and specific attributes and rules at the Model level.

d)

Create all attributes and rules at the Product Family level.

92.

A company wants to sell both products and services together as a bundle of models under one root model that is comprised of complex and hierarchical configurations. Since each model has its own configuration, sales users expressed their concerns about the overall time it will take to configure the entire bundle.

 

As an administrator, you need to setup the system configuration and address the concerns of Sales users.

 

Which three steps should be used in the configuration process in order to alleviate the Sales user's concerns?

a)

Setup the System configuration with root and child model hierarchy using BOM Tables and BOM Mapping Rule.

b)

Create constraint rules to limit the configuration options for models in the system.

c)

Use Hiding rules to hide non-essential configuration options from the Sales users.

d)

Setup default values on attributes for each model configuration through the attribute editor, layout editor, or recommendation rules.

e)

Enable System Initialization feature on the Configuration settings page with appropriate values for the number and depth of the descendant models.