WorksheetsExam 1Z0-1033-23 Reviewer_v2
Total questions: 56
Worksheet time: 27mins
Name
Class
Date
1.
What two fields are required when adding a new user to the CPQ Cloud site?
a)
Password
b)
Email
c)
Last Name
d)
First Name
e)
Type
2.
Given the following code:
strArr1 = string[]{"1", "2", "3"};
strArr2 = ____________;
Which statement when placed in the space will give strArr2 a value of "123"?
a)
Combine("",strArr1)
b)
Combine(strArr1, "")
c)
join(strArr1, " ")
d)
join(strArr1, "")
e)
join("", strArr1)
3.
Given the following code:
var = "25";
if(isnumber(var)){
___________
}else{
results = 0.0;
}
return results;
Which Statement will return the value for results as 25.0 when it is put in place of the blank line shown above the "(else)" statement?
a)
float(var);
b)
integer(var);
c)
atoi(var);
d)
atof(var);
4.
What does the function getconfigattrvalue() return?
a)
Return all the Menu Attribute values only
b)
Returns the values of configuration attributes in Commerce
c)
Returns all the Text Area Attribute values only
d)
Returns the value of configuration attributes in Config
5.
What is the limitation when searching entries in administration logs?
a)
A simple search can retrieve only a time span of three months
b)
A total of five million entries are stored in the database
c)
There is no limitation, all records from the beginning are availble
d)
The data stored in administraction logs cannot exceed 50 MB
e)
The last six months can be searched
6.
What is allowed in a deployable data table when you create a BMQL query
a)
SELECT and UPDATE
b)
SELECT, INSERT and UPDATE
c)
SELECT, INSERT and DELETE
d)
SELECT
7.
Given the following code:
str1 = " 1483.30 ";
result = ___________(str1);
return result;
Which function, when you put in the blank space, will return the value as "1483.30"?
a)
cut
b)
trim
c)
substring
d)
removewhitespace
8.
You have Developer Toolkit Command-Line Interface(CLI) instaled on you local system. Which command will run a deployment for your commerce process testProcess?
a)
cpq-toolkit push /commerce/processDefinition/testProcess/
b)
cpq-toolkit push -d /commerce/processDefinition/testProcess/
c)
cpq-toolkit pull /commerce/processDefinition/testProcess/
d)
cpq-toolkit push --no-save --no-test /commerce/processDefinition/testProcess/
9.
Which statement is FALSE about live data tables?
a)
Live data tables do not need to be deployed after modification.
b)
Web services are recommended to update live data table over BMQL functions
c)
Insert, Modify, Delete and Update are supported BMQL functions for live data tables.
d)
Live data tables can be modified using UI, Web Services, BMQL and Bulk Uploads
10.
Which two statements about BML are FALSE?
a)
BML is a C++ based markup Language.
b)
BML follows the object oriented programming model
c)
BML does not need to be compiled as application compiles the BML
d)
BML has characteristics of compiled and interpretive programming
11.
A FullAccess User is attempting to update parts through SOAP API using Web Services 2.0. When attempting to update a specific part the user gets the following error "The security token could not be authenticated or authorized"
What should the user verify?
a)
That the password used in the header of the SOAP call is correct.
b)
That the part number is valid
c)
That the user is a Partner User
d)
The Username is in all capital letters
12.
When using Web Services 1.0, consider the following sequence of a client system calling CPQ Cloud WebServices.
1 Call Security Login WebServices with User ID and Password.
2 Create Commerce updateTransaction WebServices call using an existing transaction ID.
3 Make the following updates in the web service XML
i) Set Session ID
ii) Set “_shipTo_first_name” to “myName”.
4 Submit the WebService call.
5 Call Security Logout WebServices with the SessionID to close the session.
Based on the above sequence, which of the following two statements are true?
a)
Step 3 did not specify an action to execute, thus nothing is updated in the transaction.
b)
The Commerce transaction should be updated with the new ship to name.
c)
The Session is still open.
d)
Step 4 call results will be an error.
e)
Step 5 was unnecessary; the SessionID does not need to be logged out.
13.
An existing CPQ customer likes to embed CPQ Configurator within Oracle CX Commerce.
Which three steps should the administrator/implementer consider?
a)
Provide an endpoint URL to return/redirect to the Oracle CPQ Cart page
b)
Set up a server-side integration at the product family level.
c)
Provide an endpoint URL to return/redirect to the CX Commerce Cart page
d)
Set up a BML function to generate and return Configuration integration payload to the oracle CPQ cart
e)
Set up a client-side integration at the product family level. / Set up a BML function to generate and return Configuration integration payload to the oracle Commerce cart
14.
A user tries to upload the following Parts file from the ExampleParts_Testsite's.csv file by using FTP: ExampleParts_Testsite's.ZIP
What causes the Parts upload to fail based on the file name?
a)
CSV files are not valid extensions that can be uploaded by using FTP.
b)
The "_" used in the file name is invalid
c)
The apostrope used in the file name is invalid
d)
The file name exceeds the Character limit.
15.
The User would like to run 'SFDC Quote Upsert'. On a commerce action. Where would the user define this within CPQ?
a)
The user will select SFDC Quote Upsert from the integration list in the Integration tab on the Commerce action
b)
The user will select SFDC Quote Upsert from the Modify tab in the Commerce Action
c)
The user will define the relation in Integration Center under the integration platform within the Admin Home Page.
d)
The user will define the action to run in the SOAP Generator XSL.
16.
Consider the following requirements for integration with Salesforce:
• Transaction information need to be pushed back to Salesforce and synchronized.
• You must be able to synchronize up to a 1000 lines back to Opportunity Product object in Salesforce.
On the bais of these requirements, which three XSL set should you use to provide integration?
a)
SFDC Products – Upsert All (200, 400, 600, 800, 1000)
b)
SFDC Opportunity – Upload
c)
SFDC Quote – Process Updates
d)
SFDC Quote – Upsert
e)
SFDC Opportunity – Import
17.
The following BML code encountered a HTTP 404 error from someurl.com.
urldatabypost("http://someurl.com", "a1=v1&a2=v2", "call failed")
Which two statements are true?
a)
The call will return value “HTTP 404 Not Found”
b)
An unhandled exception will be displayed in red text at the top of the configuration screen.
c)
The HTTP error will be captured in the BigMachines Error Logs: bm.log.
d)
The call will return “call failed”
e)
An HTTP error will display at the top of the configuration screen in red text stating “HTTP 404 Not Found”.
18.
You need to filter out transactions with null values in the Price Guidance Analytic. What would be the only correct way to do this?
a)
On the Analytic's Data page enter a filter row using the operator "is not empty".
b)
Add a default value on the Default tab of the Output attribute in Commerce.
c)
Set the Required flag on the Output attribute in Commerce to "Yes" on the General tab.
d)
On the Analytics Data page, enter a filter row using the operator "<>" with a Transaction attribute of "[Use Specified Value]" and Specified Valure "Null"
e)
On the Commerce Settings page, set the "Filter Out Nulls in Analytics" option to "Yes".
19.
Transaction revenue by category/type in Oracle CPQ refres to the total revenue generated by the sales of different types of products or services.
Transaction revenue by category can be tracked and analyzed using various reporting and analytics tool.
If you want to track transaction revenue by category /type, how would you implement that capacity?
a)
Create a Commerce Transaction attribute using the attribute type of Revenue Category
b)
Create a Commerce Transaction attribute using the attribute type of Menu, listing your desired revenue categories types as menu choices
c)
Create a Commerce Transaction Line attribute using the attribute type of Revenue type.
20.
CPQ is a software solution that helps sales teams configure products, generate quotes and manage pricing. CPQ is often integrated with CX platforms to provide a seamless end-to-end sales experience for customers. There are different types of prices that can be used in CPQ-CX sales integration. Which three are valid price types available in the CPQ-CX Sales integration?
a)
Quantity
b)
BOM
c)
Tiered
d)
One Time
e)
Recurring
21.
An administrator tries to change the document views on an attribute from a participant profile on a given step. However, the attribute is not listed in the list of attribtues that are available for editing.
What are two reasons for this behavior?
a)
The attribute is being referenced in an active hiding rule.
b)
The attribute is not added to the layout
c)
The attribute is a system attribute
d)
The attribute is hidden on the attribute details page.
22.
You want to add an action to the transaction layout in the Commerce Layout Editor in a never-before used area.
Which five steps do you need to perform?
a)
Click Save
b)
Drag a panel out of the layout elements menu on the transaction layout where you want to place the new action
c)
Drag action from the actions menu and drop it on the toolbar object
d)
Deploy Commerce
e)
Drag a toolbar out of the layout elements menu on the panel window where you want to place the new toolbar
23.
You have implemented a Commerce rule, which has an advance action. While testing you find that the attribute values specified in the rule are not being constrained, even though the condition is always true.
What are two reasons for this behavior?
a)
Configuration was not deployed after the rule is not implemented
b)
Commerce was not deployed after the rule was implemented
c)
The attribute is used as a condition for a Commerce Hiding rule
d)
Commerce rule is set to inactive
24.
If no Identifier information is available in an Excel File previously being exported from Transaction Line Item Grid which existing information can be imported into the Line Item Grid?
a)
Information cannot be Imported
b)
Any sales and manufacturing BOM line items
c)
Only the model heirarchy, including the child line items
d)
Sales-BOM mapped items
e)
All line items in the Line Item Grid, with the warning informing the user of the missing identifier
25.
You want to create a Price Guage to guide users in setting the optimal discount for a quote.
What is the correct procedure in the relevant Commerce process?
a)
View Analytics, create a Price Guidance Analytic, and associate the analytic to an HTML attribute
b)
View Main document attributes, create a new HTML Attribute, associate a Price Gauge visualization and select the guage input attriutes
c)
View Main Document Attributes, create a new Price Guage Attribute Type, and select the guage input attributes
26.
What is the minimum number of transactions that must meet the filter criteria to train a Win Probability or Price Optimization machine learning model?
a)
0
b)
200
c)
1000
d)
35
27.
Your customer wants to have the Commerce pricing function invoke a Util Library function applydiscounts(), which applies discounts on the distributor price, and end-customer price, and then returns discounted values.
Which three approaches can you use to pass these values back to the Commerce pricing function?
a)
Construct a return string in the following format and return this string: documentNumber~variableName~value[|documentNumber~variableName~value|]*
b)
return values by using multiple return statements
c)
put all values to a dictionary along with appropriate keys, and return this dictionary
d)
put all values in an array and return this array
28.
You want to control the information that can be viewed on the transaction page.
What must you create to accomplish this?
a)
Transition Rules
b)
Participant Profiles
c)
Constraint Rules
d)
Internal User Definition
e)
Library Functions
29.
How can you prevent users with the RestrictedAccess user type from creating a new transaction using Transaction Manager
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)
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.
c)
Go to the Commerce Process admin page and open the participant profiles of the start step. Remove all user access rights entries for RestrictedAccess
d)
Navigate to the Process Invocation admin page and remove the user access rights entries for RestrictedAccess for all pages.
30.
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?
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.
31.
What is the total number of Custom Part fields that can be defined on CPQ site?
a)
30
b)
200
c)
500
d)
600
e)
700
32.
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 option.
How would you accomplish this?
a)
By writing a Hiding rule
b)
by writing the a constraint rule
c)
By writing a recommendation rule
d)
by writing a pricing rule
33.
A configuration has been created, including Product Family Product line, and Model definitions. You want to verify the configurator for the new set of products.
What is typically the last task that is performed to ensure that the configurator is accesible?
a)
Create a configuration flow
b)
Define the configuration rules
c)
Deply the home page
d)
Deploy the configuration via Configuration Quick links
34.
Which two are allowable methods of defining menu item for Single Selece Menu attributes or Single Select Pick List attributes in the BOM Mapping table?
a)
Placing al the menu item choices in a single BOM Item Mapping table entry seperating each item with "^|^" delimeter
b)
Placing al the menu item choices in a single BOM Item Mapping table entry seperating each item with "|" delimeter
c)
Create separate BOM Item Mapping entries for each menu choices
d)
Placingthe menu choices in a separate csv file and referencing the csv file in the BOM Item Mapping table
35.
Where would you define the table relationships when creating Bulk Table Lookup rules?
a)
New Rule type
b)
Rule action
c)
Data table admin
d)
Rule Condition
36.
Which Configuration flow would you choose to design a Configurator where attribute vary based on prior user selections and have a sequential relationship consisting of distict steps?
a)
Multi Node Configuration flow
b)
Any configuration flow with a Constraint and hiding rules that meet requirements
c)
Search flow
d)
Master Start and End flow
37.
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
38.
The production CPQ site is on the 22D release. Recently the non-production development site refreshed to 23A Base App release.
As an administrator you need to migrate different entities between these sites.
How would you accomplish this?
a)
Export a package from 23D production site and import into the 23A non-production site.
b)
Use the Import from Source mode to migrate items from the 22D non-Production site to the 23A Production site
c)
Export a package from the 23A production site and import in into 22D non-production site
d)
Connect both Production and Non-Production site to run the whole site migration
39.
A new user group has been created in the development environment.
What should you do to migrate this new user group to the production environment?
a)
Migrate the new user group to the production environment
b)
Create a new user group in the production environment manually
c)
Migrate the new users to the production environment
d)
Migrate Commerce to the production environment
40.
On a non-production 22D site you initiate a rollback for the previous migration, and the rollback is in progress. Another user tries to upload 22C package on the same site at the same time.
What would happen in this situation?
a)
The package upload completes successfully
b)
Both the rollback and the package upload will run parallel
c)
The package upload does not happen because the migration center allows only one migration task to run at any point in time
d)
Both rollback and the package upload will terminate
41.
The Related Parts Data table exist in the QA (Test) environment and in the production environment. The table has 3000 records in the QA and 4000 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 QA environment?
a)
1000
b)
7000
c)
4000
d)
3000
42.
A self service shopper likes to make a request for a quote from Oracle CX Commerce Cart.
To issue a quote to the self-service shopper, which three steps should the administrator/implementer consider?
a)
Associate Sync Quote Integration to a Sync quote Commerce Action in CPQ.
b)
Set up parts in CPQ with the same number as that of the SKU numbers from Oracle CX
c)
Ensure that CPQ is set up as the Parts Item Master and that CX parts are synced to CPQ
43.
A partner user approves a quote. However the status in the CRM does not get Updated.
Which two can be reasons for this?
a)
The partner user does not have access to the attribute "status" in the pending step within CPQ
b)
The partner user approved the quote through mobile approvals
c)
Integration are not associated with the approve action
d)
The parner user does not have correct partner info credentials
44.
You want to Change an object's (pane, attribute, toolbar, action, etc) settings in Commerce Layout Editor.
How can you access the object's setting?
a)
Click the gear icon and the object settings will be displayed.
b)
Right-click the object on the layout, select Settings and the object settings will be displayed.
c)
Highlight the object on the layout, select Settings menu and the object's settings will be displayed
45.
You need to add new attribute columns to the Line Item Grid in Commerce Layout Editor.
How would you accomplish this?
a)
Locate the transaction line attribute you wish to add to the line Item grid in the Attributes menu, drag it into the line item grid to the location where you want it to appear, and drop the attribute
b)
Drag a ne column object from the Layout Elements menu on the Line Item Grid, drop it in the location where you want the attribute column to appear, then locate the transaction Line attribute you want displayed in the new column in the attributes menu, drag it ti the new column and drop it.
46.
Your sales users want to print a proposal document from a transaction in there prefered languages.
What are the Oracle-recommended steps necessary to address this use case using Document designer where the template differs for each languange?
a)
Create a language-specific templates with a same name, provide translations and designs for each of those templates to a print action by using the printer-friendly XSL view.
b)
Create language specific templates with different names, provide translations and design for each of the templates and link these templates to a single print action by using printer-friendly XSL view
47.
You want to add multiple sections to your Document Designer Template, and you want the sections flow in the template without page breaks between each section.
How would you accomplish this?
a)
You do not have to do anything because this is the default behavior in Document Designer
b)
Select the Child section check box in the section Properties panel for each subsequent action following the first section in the series
c)
Add each section to the template and manually remove the page breaks at the end of each sections
48.
Along with Part Number Quantity and Price, you also want to send additional recommended item details particular to the configuration to Commerce. Which two options enable you to achieve this?
a)
Use BOM Mapping rules
b)
This is not feasible. Only Part Number, Quantity and Price can be passed from Config to Commerce by using Recommended Item Rule
c)
Pass an additional details by storing them in a Pricebook
d)
Use the Comment field to pass additional details.
e)
Concatenate the additional details to Part Number
49.
Which two are valid input payload psuedo code snippets (for <NAME: VALUE PAIR>) when performing a REST call to modify multiple assets?
RESR URL: https://sitename.oracle.com/rest/v8/assets/actions/modify
Method: POST
Input Payload:
{
"sourceIdentifier": "oraclecpqo",
"transactionId": "21275813",
"transactionDate": "2019-01-27 00:00:00",
"returnBom": false,
"flattenHierarchy": false,
<NAME: VALUE PAIR>
}
a)
"selections": ["21652013", "21652080"]
b)
"assetKeys": ["abo_05b05644-82de-4240-86eb-8feee4aa90d6", "abo_d60556a9-8639-403b-aea0-d0fbd3d73c29"]
50.
There are two single select menu attributes in an array set. The first single-select menu attribute shows a list of countries and the second single select menu attribute shows a list of states.
Which is the most efficient way to show relevant states based on the choosen countery?
a)
Create hiding rules for each country with a simple conditions and then select valid states for the action attribute in this case the number of the hiding rules will be equal to the number of countries
b)
Use hiding rule which is the only possible option because array do not support Constraint rules
51.
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)
52.
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.
53.
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.
54.
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.
55.
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.
56.
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
100 %
