IBM Unica Campaign V8.5 Sample Questions:

1. In a Unica Campaign Flowchart, a customer database table (see below) is mapped in a Select process box. There is a requirement to segment and organize customers based on their income, which would typically have the values "HIGH" for customers whose income is greater than 100000 and "LOW" for customers whose income is less than or equal to 100000. This value needs to be output with the final target list.

Ideally which step should be executed to get the task done?

A) Create a Persistent Derived field with the logic : IF(Customer_Demographic_Info.Income > 100000,'HIGH','LOW').
B) Create a User Variable HIGH and LOW with the logic: IF(Customer_Demographic_Info.Income > 100000,'HIGH','LOW').
C) Create a Strategic Segment with the logic : IF(Customer_Demographic_Info.Income > 100000,'HIGH','LOW').
D) Alter the table to add a new column with the required logic.

2. In a Unica Campaign flowchart Select process, how can a custom macro be profiled so that it appears in the Select process "Available Fields" menu?

A) Select "Options" from the main menu in a flowchart, choose "Custom Macros...". Click "New Macro" and add the macro name and fieldexpression. Go to the "Select" process and choose the macro from the "Available Fields" column.
B) In the "Select" process box, create a "Derived Field" with a field name Profile_Test and enter the macro name in the expression field. Go tothe "Select" process "Source" tab and select the macro from the "Available Fields" column.
C) Select "Options" from the main menu in a flowchart, choose "Custom Macros...". Click "New Item" and add the macro name and field expression.Go to the "Select" process and choose the macro from the "Available Fields" column.
D) In the "Select" process box "Source" tab, click the Input field and the drop-down list appears. Go to "Tables", select "UA_CUSTOMMACROS",and select the macro from the list. Select the macro when it appears in the "Available Fields" column.

3. A specialist is asked to review a flowchart and find areas that are candidates for performance optimization. Which two of the following choices are the BEST steps to take?

A) Review all Segment boxes, and ensure that segment by field configuration is used.
B) Review the AllowSegmentUsingSqlCase setting for the data source used by the flowchart. Consider setting to false if all segment boxes havemutually exclusive segments.
C) Review flowchart queries for cases where base-to-base table joins are performed so that they might be replaced with base-to-dimension tablejoins.
D) Review all the top level Select boxes for criteria that can be combined and also for derived fields that may be able to be moved further down abranch in the flowchart.
E) Review the max query threads setting in each Segment box. In some boxes it may make sense to increase the maximum (if set to lower than thetotal segments), and in some cases it may make sense to decrease the maximum.

4. An administrator has just installed Unica Platform and Unica Campaign. The user wants to change permissions for the out of the box delivered users. Which security policies and permissions are delivered on first install (or in other words, out of the box) with Unica Campaign?

A) Global policy and System policy
B) System policy and Customer policy
C) Local policy
D) Administrative permissions and Global policy

5. In a Unica Campaign Flowchart, a customer database table (see below) is mapped in a Select process box. There is a requirement to output the following fields: CustomerID, and an Age group which would have the values "YOUNG" for customers whose age is less than 40 and "OLD" for customers whose age is greater than 40. This column will be consumed by another downstream process in the flowchart.

Ideally, which steps should be executed to get the task done?

A) Create a custom macro with the required logic and use it in User variables for further processing in the flowchart.
B) Create a Derived field with the Persistent option processing the required logic and use it for further processing in the flowchart.
C) Create a derived field in the Select process using the required logic and use it for further processing in the flowchart.
D) Alter the table to add the required column and map the table again in the flowchart.

Solutions: