IBM Unica Campaign V8.5 - 000-470 Exam Questions [2026]

QUESTION NO: 1
A user needs to use a list of clients in a flowchart that does not exist in the database, but only as a Microsoft Excel .csv file. This flat file must be mapped into the Unica Campaign flowchart as a:

A. base table. B. general table. C. dimension table. D. fact table.

Correct Answer: A

QUESTION NO: 2
A customer has accidentally retired an offer in Unica Campaign. What is the fastest and simplest way a specialist can resolve this problem?

A. Reactivate the offer from the offer list within Campaign. It will maintain the same offer code. B. Identify the offer that was retired, go into the system tables and reverse its status using SQL queries. C. Make a duplicate copy of the retired offer and a new offer code will be assigned. D. Create a new offer by using the same offer template and attributes.

Correct Answer: C

QUESTION NO: 3
Which of the following is NOT a recommended Unica Campaign V8.5 environment?

A. WebLogic V10, Redhat V5, Oracle V11 (system tables) B. WebSphere V7, IBM z/OS V1, DB2 V9 (system tables) C. WebSphere V7, Redhat V5, Oracle V11 (system tables) D. WebLogic V11, Windows Server 2003, DB2 V9 (system tables)

Correct Answer: B

QUESTION NO: 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. System policy and Customer policy B. Administrative permissions and Global policy C. Local policy D. Global policy and System policy

Correct Answer: B

QUESTION NO: 5
When creating an offer template, a Unica Campaign specialist needs to ensure that the offers created subsequently using this offer template can be grouped together and rolled-up for reporting purposes. This can be achieved by?

A. Grouping by offer codes assigned to offers created using the same template. B. Creating a custom attribute to group the offers together and roll-up based on that attribute. C. Grouping all relevant offers in the designated folder and its sub folders so that they can be rolled up during reporting. D. Following a naming convention so that similar offer names are assigned to related offers and hence offers are grouped by name

Correct Answer: B

QUESTION NO: 6
A user has added a new Unica Campaign Attribute and would like to make that attribute available to the Cognos reports. To do this, the user needs to:

A. use the Reports SQL generator to create new views which include the new attribute. B. use the Reports SQL generator to update the existing reporting views. C. use the Cognos application administrator to create a new data framework which includes the new attribute. D. do nothing, once the new column is added the reports model is automatically updated.

Correct Answer: A

QUESTION NO: 7
Whether or not the In-Database Optimization is enabled can affect flowchart performance. The specialist can verify whether it is enabled by looking in:

A. the Advanced settings for the flowchart in question. If it's enabled there, then it will override any other setting. B. partitions-partition[n]-datasources for any data source used in the flowchart in question. If it's enabled there, then it will override any othersettings. C. partitions-partition[n]-server-optimization. If it's enabled there, then it will override any other settings. D. each Select process for the flowchart in question. If it's enabled there, then it will override any other setting.

Correct Answer: A

QUESTION NO: 8
An administrator must install Unica Marketing products multiple times when setting up a clustered environment. Which installation mode would BEST serve this purpose?

A. Supervised Mode B. Console (Command Line) Mode C. Unattended (Silent Mode) D. Windows GUI or UNIX X-windows mode

Correct Answer: C

QUESTION NO: 9
A user does not want the dashboard to display when Unica Campaign is first opened. Instead, the user simply wants to use the currently displayed All Campaigns page as the home page. How can this be done?

A. A user cannot change the dashboard home page. Only the administrator can. B. In the Campaign application, go to "Settings" and select "Configuration". Under the "Campaign" category, click "navigation". C. In the Campaign application, go to "Settings" and select "Set current page as home". The user does not need any special permission to set anypage selected as home. D. In the Campaign application, go to "Settings" and select "Set current page as home". The user must have permissions to set the page selectedas home.

Correct Answer: D

QUESTION NO: 10
The custom macro has been configured to select on "audience id" and a return value. When this custom macro is executed an error is received. What could cause this problem?

A. The custom macro is the same as one of the Campaign built-in macros. B. There are user variables used in the custom macro. C. The custom macro is too large for the fields in the temp table (<TempTable>). D. The Expression Type is configured incorrectly for the custom macro.

Correct Answer: D