IBM IBM Certifications C9010-260 Questions & Answers

• Question 91:

  A specialist creates a numeric user variable called MinBalance and assigns an initial value of 100 to it. The specialist wants the Select process to return all IDs where the mapped field AccountBalance is greater than MinBalance. What is the correct syntax to use?

  A. MinBalance < AccountBalance

  B. AccountBalance > MinBalance

  C. AccountBalance > UserVar.MinBalance

  D. AccountBalance is GT than UserVar.MinBalance

  Correct Answer: C

• Question 92:

  How does the Unica Campaign server access system tables residing in an Oracle database? It uses:

  A. SQL*Plus.

  B. a JDBC type 4 db connection.

  C. a ODBC type 4 db connection.

  D. Oracle's native client connection.

  Correct Answer: D

• Question 93:

  A Unica Campaign has been designed to personalize offers for individuals via dynamic parameterization of offer attributes. Which Campaign system table records the offer(s) received by the individuals?

  A. Flowchart Table

  B. Contact History Table

  C. Response History Table

  D. Detailed Contact History Table

  Correct Answer: D

• Question 94:

  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. There are user variables used in the custom macro.

  B. The Expression Type is configured incorrectly for the custom macro.

  C. The custom macro is the same as one of the Campaign built-in macros.

  D. The custom macro is too large for the fields in the temp table ().

  Correct Answer: B

• Question 95:

  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 Item" and add the macro name and field expression.Go to the "Select" process and choose the macro from the "Available Fields" column.

  B. 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.

  C. 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.

  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.

  Correct Answer: C

• Question 96:

  A table Customer_master contains 1000 customer_ids. A select box was created and all the customer_ids from the table were selected. However, when the select box was run, the output cell contained only a fraction of the total customers. When a test query was performed in the above mentioned select box, all 1000 customers were selected. What could be cause of this issue?

  A. Global suppression.

  B. The Select process was not configured properly.

  C. The table mapping of Customer_master are out-of-date.

  D. Incorrect audience level has been chosen for the Customer_master table.

  Correct Answer: A

• Question 97:

  A user is trying to create RAW SQL in a Select process. "Select IDs with" is selected but when the user clicks on the advanced button the "RAW SQL for Record Selection" check box is greyed out. What is the user doing wrong?

  A. The correct tables are not mapped in.

  B. A SQL Custom Macro has not been created.

  C. The Select process is in Point and Click mode.

  D. Unica Campaign is not connected to the database.

  Correct Answer: C

• Question 98:

  A user is mapping a flat file into Unica Campaign. The user needs to ensure that the file ends with a:

  A. tab.

  B. comma.

  C. closing bracket.

  D. carriage return, line feed.

  Correct Answer: D

• Question 99:

  Within a flowchart a user wants to switch audiences from the Household level to the Customer level. In order to do this, a table containing both columns is necessary. This can be accomplished by mapping a table:

  A. into the catalog twice, once at the Household level and once at the Customer Level.

  B. into the catalog and select the Household column and the Customer column when selecting the audience level.

  C. in as a base table at the Household level and then map the same table in as a dimension table joined to the base table on the Customercolumn.

  D. in at the Household level as a table is normally mapped and then use the "Specify Additional Audiences" screen to select the Customer columnwithin the table.

  Correct Answer: D

• Question 100:

  A user needs to output data from a Unica Campaign flowchart and does not need to utilize the data within the flowchart. This can be done by creating and outputting the data to a:

  A. fact table.

  B. general table.

  C. dimension table.

  D. base record table.

  Correct Answer: B