I85PREP
⌘ K
Adobe Campaign Classic Developer Expert study materials
Adobe Campaign Classic Developer Expert study resources

Adobe Campaign Classic Developer Expert practice questions

One question at a time. Build your Adobe Campaign Classic Developer Expert understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Campaign Data Model and Schemas

Where are Adobe Campaign Classic schema definitions stored when they are loaded into the application?

  1. In xtk:srcSchema Correct answer.
  2. In the cus:dataModel schema
  3. In the nms:delivery schema
  4. In the xtk:option schema

Explanation

Schema source definitions are persisted in the xtk:srcSchema system schema, which the application reads to build the data model. This system schema belongs to the xtk namespace and is not a business data schema.

Question 2Campaign Data Model and Schemas

Which built-in schema represents the recipient (profile) table in a standard Adobe Campaign Classic instance?

  1. nms:recipient Correct answer.
  2. cus:recipient
  3. xtk:recipientSchema
  4. nms:profile

Explanation

Recipients are defined by nms:recipient in the nms namespace. It is the standard targeting dimension for profile data.

Question 3Campaign Data Model and Schemas

In a schema definition, which statement describes the relationship between the `<srcSchema>` name and its root `<element>` name?

  1. The root element name must match the schema name. Correct answer.
  2. The root element name must use the xtk prefix.
  3. The root element name is always `record`.
  4. The root element name must be the namespace name.

Explanation

The root element carries the table's technical name and must be identical to the schema's `@name` value. This convention lets the application map the XML definition to the physical table.

Question 4Campaign Data Model and Schemas

Which Adobe Campaign Classic data type is intended for a long text field that can exceed the default string length?

  1. memo Correct answer.
  2. boolean
  3. uuid
  4. datetime

Explanation

The memo type maps to a large text column and is used for long free-form content. The string type is limited by its declared length, while memo is intended for longer text.

Question 5Campaign Data Model and Schemas

Which schema attribute supplies the human-readable name displayed for a schema or field in the Adobe Campaign interface?

  1. label Correct answer.
  2. namespace
  3. sqltable
  4. name

Explanation

`label` is the display name shown in the interface, while `name` is the technical identifier. Namespace and sqltable affect technical storage rather than UI labels.

Question 6Campaign Data Model and Schemas

Which schema element is used to declare a fixed list of allowed values for a field?

  1. enumeration Correct answer.
  2. dbindex
  3. compute-string
  4. key

Explanation

The enumeration element defines named values that a field can take. A field references it through its enum attribute.

Question 7Campaign Data Model and Schemas

Which attribute on the root element overrides the default physical table name generated for a schema?

  1. mappingType
  2. autopk
  3. revLink
  4. sqltable Correct answer.

Explanation

`sqltable` sets the database table name explicitly. Without it, Campaign derives the table name from the namespace and schema name.

Question 8Campaign Data Model and Schemas

After adding a new field to a custom schema, which action makes the corresponding column available in the database?

  1. Restarting the web server only
  2. Running the delivery audit
  3. Recompiling JavaScript libraries
  4. Updating the database structure Correct answer.

Explanation

Schema changes affect the physical data model, so the Update database structure wizard must be run to create or alter tables and columns. Restarting services or auditing deliveries does not apply the required DDL changes.

Question 9Campaign Data Model and Schemas

A developer needs to add a custom field to the standard recipient schema without modifying the built-in definition. Which approach is correct?

  1. Add the field to xtk:srcSchema as a new system attribute.
  2. Create a new cus schema that extends the nms:delivery schema.
  3. Edit the built-in nms:recipient XML file directly in the package.
  4. Create a same-name extension schema in the nms namespace. Correct answer.

Explanation

Extension schemas reuse the target schema's name and namespace and are merged into the original definition. This adds fields without editing the built-in schema.

Question 10Campaign Data Model and Schemas

Which schema attribute declares that a custom schema inherits the fields of another schema?

  1. extends Correct answer.
  2. linkedSchema
  3. target
  4. inheritsFrom

Explanation

`@extends` specifies the parent schema in a schema inheritance relationship. The child schema then includes the parent's fields in addition to its own fields.

Question 11Campaign Data Model and Schemas

What is the effect of setting `autopk="true"` on a schema's root element?

  1. It enables automatic numbering of enumeration values.
  2. It automatically publishes the schema to all namespaces.
  3. It generates the automatic primary key column. Correct answer.
  4. It creates an automatic reverse link to the folder schema.

Explanation

`autopk` tells Campaign to add and manage the technical primary key for the schema's table. This is the standard identifier column used by links and queries.

Question 12Campaign Data Model and Schemas

Which attribute on a link element identifies the schema to which the link points?

  1. revLink
  2. target Correct answer.
  3. link
  4. integrity

Explanation

`target` names the destination schema, such as nms:recipient. The reverse link name is set with `revLink`, while cardinality is described separately.

Question 13Campaign Data Model and Schemas

What is the purpose of the `revLink` attribute on a link element?

  1. It sets the foreign key column name in the source table.
  2. It defines the SQL join type used by the link.
  3. It names the reverse link added to the target schema. Correct answer.
  4. It marks the link as mandatory for the target schema.

Explanation

`revLink` declares the name of the link that appears on the target schema in the opposite direction. This lets developers navigate the relationship from both sides.

Question 14Campaign Data Model and Schemas

How is a unique database key declared over one or more fields in a schema?

  1. With a `dbindex` element containing `unique="false"`.
  2. With an `enumeration` element containing `value` children.
  3. With a `key` element whose `unique` attribute is `true`. Correct answer.
  4. With a `sysFilter` element containing `condition` children.

Explanation

The `key` element groups one or more `keyfield` entries, and `unique="true"` enforces uniqueness. A `dbindex` creates an index but is not the unique-key declaration.

Question 15Campaign Data Model and Schemas

Which schema element is used to define an additional database index on a field?

  1. compute-string
  2. dbindex Correct answer.
  3. methods
  4. attribute

Explanation

The `dbindex` element declares an index and references fields through its child elements. It improves query performance but does not define the field itself.

Question 16Campaign Data Model and Schemas

What does the `compute-string` element define in a schema?

  1. The default filter applied when the schema is queried.
  2. The SQL expression used to create a computed column.
  3. The list of methods exposed by the schema.
  4. The expression that builds a record's display label. Correct answer.

Explanation

`compute-string` combines field values into a readable label, often shown in lists and drop-downs. It is not a computed SQL column or a query filter.

Question 17Campaign Data Model and Schemas

Before using a new custom namespace such as `cus`, what must be done in Adobe Campaign Classic?

  1. Create a matching table manually in the database.
  2. Register the namespace as a delivery template.
  3. Declare it in the namespace configuration. Correct answer.
  4. Add the namespace to the xtk:option schema.

Explanation

Namespaces must be declared in the namespace configuration before schemas can use them. Campaign uses the namespace to group schemas and generate table names.

Question 18Campaign Data Model and Schemas

Which attribute sets a literal default value for a field when a new record is created?

  1. default Correct answer.
  2. expr
  3. sqlDefault
  4. initValue

Explanation

The `default` attribute on an attribute element supplies the initial value for new records. It is distinct from a display label or SQL type.

Question 19Campaign Data Model and Schemas

Which attribute allows a developer to override the default SQL column type for a schema field?

  1. sqlType
  2. dbType
  3. dataType
  4. columnType Correct answer.

Explanation

`sqlType` explicitly sets the database column type when the standard mapping is not sufficient. The field's Campaign type is still declared with `type`.

Question 20Campaign Data Model and Schemas

What is the role of a `sysFilter` element in a schema?

  1. It declares the schema's inheritance parent.
  2. It creates a reverse link on the target schema.
  3. It defines a system-generated primary key.
  4. It sets a default record filter. Correct answer.

Explanation

`sysFilter` specifies filter conditions that Campaign applies by default when accessing the schema. It is not related to keys, links, or inheritance.

Question 21Campaign Data Model and Schemas

A schema must read data from an external database through a Federated Data Access (FDA) external account. Which schema attribute identifies this federated mapping?

  1. type="Federated"
  2. externalJoin="true"
  3. mappingType="Federated" Correct answer.
  4. dataSourceMapping="Federated"

Explanation

FDA schemas use the `mappingType` attribute with the Federated value to indicate that the table is not stored in the Campaign main database. The external account is associated through the schema's data source configuration.

Question 22Campaign Data Model and Schemas

In a schema, a link element is declared with `link="1-N"`. What does this cardinality indicate?

  1. One source record can relate to many target records. Correct answer.
  2. Many source records can relate to one target record.
  3. Many source records relate to many target records.
  4. One source record relates to exactly one target record.

Explanation

In `link="1-N"`, the first value is the source side and N means multiple target records per source record. A reverse N-1 link is created on the target side.

Question 23Campaign Data Model and Schemas

How does schema inheritance with `@extends` differ from a schema extension that reuses the same name and namespace?

  1. Inheritance creates a child table; extension alters the original table. Correct answer.
  2. Inheritance adds fields to the original table, while extension creates a separate table.
  3. Extension requires FDA, while inheritance requires a custom namespace.
  4. Both approaches always modify the same physical table.

Explanation

`@extends` defines a new child schema and table that include the parent fields. An extension schema with the same name and namespace is merged into the existing schema and alters the original table.

Question 24Campaign Data Model and Schemas

A schema defines a `key` with `unique="true"` over `@email` and also a `dbindex` over `@lastName`. Which statement is accurate?

  1. Both elements create identical unique constraints on the same field.
  2. The `key` element creates a non-unique index on the `@email` field.
  3. The `dbindex` element enforces uniqueness on the `@lastName` field.
  4. The key is unique on email; the dbindex is not unique. Correct answer.

Explanation

A key with `unique="true"` creates a unique constraint over the referenced field or fields. A `dbindex` without a uniqueness setting creates a regular index.

Question 25Campaign Data Model and Schemas

Which statement about the physical table name generated for a custom schema `cus:orderLine` is correct?

  1. The physical table name is copied from the schema's `label` attribute.
  2. The table name must match the namespace, so it is always named `cus`.
  3. It comes from namespace and schema name unless `sqltable` is set. Correct answer.
  4. The physical table is always named exactly `orderLine` in the database.

Explanation

By default, Campaign generates a physical table name from the schema namespace and name. The `sqltable` attribute can override that generated name.

Question 26Campaign Data Model and Schemas

A developer declares a string field in a schema and wants the physical column to hold no more than 40 characters. Which attribute of the `<attribute>` element controls this?

  1. maxLength="40"
  2. size="40"
  3. length="40" Correct answer.
  4. width="40"

Explanation

The `length` attribute defines the maximum number of characters allowed for a string field and drives the size of the physical varchar column created for it. When it is omitted the platform applies its own default capacity, so longer values may be truncated or rejected by the database.

Question 27Campaign Data Model and Schemas

A `<filter>` element is declared in a schema. What does it define?

  1. It stores the default sort order applied when the schema's records are listed.
  2. It declares the access-control rule applied to the schema's records.
  3. It declares the join condition applied whenever the schema is queried together with another table.
  4. It declares a named query condition that users can pick in the filtering interface of that schema. Correct answer.

Explanation

A `<filter>` element declares a named, reusable condition whose SQL or XPath expression is given in its `filter` attribute, and it is offered to users in the query and filtering interfaces of that schema. It does not affect joins, sorting or access rights, which are handled by other elements.

Question 28Campaign Data Model and Schemas

Which attribute of the `<attribute>` element declares the logical data type used by the application, such as string, long, datetime or boolean?

  1. format
  2. sqltype
  3. datatype
  4. type Correct answer.

Explanation

`type` carries the logical type that the application layer uses for validation, display and conversion. The physical column type is normally derived from it, and only overridden with `sqltype` when the default mapping is unsuitable.

Question 29Campaign Data Model and Schemas

A link reaches a target table whose relationship cannot be derived from a foreign-key column matching the link name. Which element lets the developer state the SQL join condition explicitly?

  1. `<key>`
  2. `<where>`
  3. `<join>` Correct answer.
  4. `<condition>`

Explanation

By default a link joins the target table's primary key to a foreign-key column of the source table. A `<join>` element nested in the link declares the conditions explicitly through `xpath` attributes evaluated on the source and target, which is required when the default inference does not fit the data model.

Question 30Campaign Data Model and Schemas

Which attribute on a `<link>` element makes the database enforce a foreign key constraint on the relationship?

  1. externalJoin="true"
  2. revIntegrity="true"
  3. mandatory="true"
  4. integrity="true" Correct answer.

Explanation

`integrity="true"` tells the platform to create a real foreign key constraint so that a referenced record must exist. `revIntegrity` acts on the reverse link generated in the target schema, which is a different relationship side.

Question 31Campaign Data Model and Schemas

An attribute is declared with `attribute="true"` in a schema. What is the effect of this setting?

  1. The field is written to the database only when the record is saved from a form.
  2. The field is stored in a separate extension table keyed by the record identifier.
  3. The field is exported to XML files but deliberately kept out of the SQL schema.
  4. The field is not persisted: no column is created and the value lives only in memory during processing. Correct answer.

Explanation

Marking a field with `attribute="true"` makes it non-persistent: the platform keeps the value in memory at runtime and never maps it to a table column. Such a field therefore cannot be used to filter or sort on stored data.

Question 32Campaign Data Model and Schemas

A `<parameter>` element is declared at schema level. What is it used for?

  1. It declares a typed variable that filters, forms and query definitions of the schema can use. Correct answer.
  2. It sets the default value applied to every new record of the schema.
  3. It reserves a primary-key seed value for the physical table.
  4. It declares a technical constant column stored in the table.

Explanation

Schema-level parameters declare typed variables, with an optional default, that can be referenced by filters, forms and query definitions of that schema, which lets a condition be reused with different runtime values. They are declarative and never produce a column.

Question 33Campaign Data Model and Schemas

A schema declares a link named `order` whose target table has a numeric primary key. Which column is added to the source table to hold the foreign key?

  1. iOrderId Correct answer.
  2. idOrder
  3. sOrderId
  4. orderId

Explanation

The foreign-key column is built from the link name, an `Id` suffix and the type prefix of the key, which is `i` for a numeric key, giving `iOrderId`. Renaming the link therefore changes the physical column name.

Question 34Campaign Data Model and Schemas

A custom schema declares `view="true"` on its root element. Which statement describes the consequence?

  1. The schema's columns are rebuilt from the view target at every database update.
  2. The schema is mapped to an existing SQL view, so the update wizard creates no table for it. Correct answer.
  3. The schema is mapped to a table whose physical name receives a V suffix at creation time.
  4. The schema becomes read-only in the interface while still writing to a normal table.

Explanation

`view="true"` tells the platform that the schema describes a SQL view rather than a table: data can be read and queried, but the database update wizard does not create a table for it. The view itself must be defined in the database for the mapping to work.

Question 35Campaign Data Model and Schemas

A schema declares a `<method>` inside its `<methods>` element. Which statement about this method is correct?

  1. It is JavaScript executed in the browser when the schema's input form is opened.
  2. It is converted into a stored procedure during the database update.
  3. It is exposed as a static SOAP API call whose JavaScript body runs on the server. Correct answer.
  4. It is callable only from the JavaScript activity of a workflow.

Explanation

Methods declared in a schema are static SOAP entry points: the JavaScript body executes server-side and can be invoked through the API, which is why they are used to expose business logic on a schema. They are not bound to a form, a workflow activity or a stored procedure.

Question 36Campaign Data Model and Schemas

A field is removed from a schema and the database update wizard is run. What happens to the column that already exists in the table?

  1. The column remains in the table because the update wizard does not remove existing columns. Correct answer.
  2. The column is dropped only when it is not part of an index.
  3. The column is renamed with a suffix so that it can be reused later.
  4. The column is dropped together with its data on the next update.

Explanation

The update wizard only adds structures that are missing; columns that no longer appear in any schema are left untouched so that existing data is not destroyed. Removing a column is therefore a manual database operation.

Question 37Workflows and Data Processing

Which workflow activity selects records from the Adobe Campaign database by applying filtering criteria and produces a target population?

  1. Split
  2. Query Correct answer.
  3. Enrichment
  4. Deduplication

Explanation

The Query activity defines a target by applying filters to a schema and is the standard starting point for population selection. It can also configure sorting and target options for downstream activities.

Question 38Workflows and Data Processing

Which activity divides an incoming population into several subsets according to conditions defined for each output transition?

  1. Union
  2. Intersection
  3. Split Correct answer.
  4. Reconciliation

Explanation

The Split activity evaluates subset conditions and routes each record to the matching output transition. It is used to create multiple populations from one incoming target.

Question 39Workflows and Data Processing

Which activity starts a workflow at specified times and can be configured for recurring execution?

  1. Wait
  2. Signal
  3. Scheduler Correct answer.
  4. Approval

Explanation

The Scheduler activity triggers workflow execution according to a configured date, time, and recurrence pattern. It is commonly used for periodic batch processing.

Question 40Workflows and Data Processing

Which activity pauses a workflow branch for a fixed duration or until a specified date before continuing?

  1. Scheduler
  2. Approval
  3. Signal
  4. Wait Correct answer.

Explanation

The Wait activity introduces a time delay in a branch, either for a defined duration or until a specified date. Downstream activities do not run until the wait condition is satisfied.

Question 41Workflows and Data Processing

Which activity merges several incoming targeting results into a single population?

  1. Exclusion
  2. Intersection
  3. Split
  4. Union Correct answer.

Explanation

The Union activity combines records from multiple incoming transitions into one outgoing target. It is used when the workflow must continue with a merged population.

Question 42Workflows and Data Processing

Which activity is used to export the incoming target data to a file on the server or a remote location?

  1. Extract file Correct answer.
  2. Web download
  3. Transfer file
  4. Load file

Explanation

Extract file generates an output file from the incoming target and lets you define the exported columns and file format. It is the counterpart of Load file, which imports data.

Question 43Workflows and Data Processing

In a workflow diagram, what does a transition between two activities represent?

  1. A database index used to speed the query
  2. A scheduled backup of the workflow definition
  3. The flow of the target population from one activity to the next Correct answer.
  4. A user permission required to run the activity

Explanation

A transition is the arrow that carries the target population from one activity to the next. An activity becomes eligible to run when data arrives on its incoming transitions.

Question 44Workflows and Data Processing

Which activity suspends execution until an operator explicitly approves or rejects the continuation?

  1. Approval Correct answer.
  2. Signal
  3. Wait
  4. Scheduler

Explanation

The Approval activity pauses the workflow and sends a notification so an operator can approve or reject the next step. Execution resumes only after a decision is recorded.

Question 45Workflows and Data Processing

In a Query activity, which setting defines the schema of the population returned by the activity?

  1. Transition label
  2. Targeting dimension Correct answer.
  3. Filtering dimension
  4. Sorting

Explanation

The targeting dimension determines the schema of the records produced by the Query activity. The filtering dimension defines the schema on which filter criteria are applied, which can differ when filtering through a link.

Question 46Workflows and Data Processing

Which activity selects only records that were created or modified since the previous execution of the same workflow?

  1. Incremental query Correct answer.
  2. Reconciliation
  3. Change data source
  4. Query

Explanation

Incremental query compares records against the previous workflow execution and selects only new or changed data. A standard Query activity does not automatically apply this delta logic.

Question 47Workflows and Data Processing

In an Update data activity, which operation mode updates existing records and also inserts records that do not yet exist?

  1. Update only
  2. Delete
  3. Merge and purge
  4. Insert or update Correct answer.

Explanation

The Insert or update mode writes values to matching records and creates new records when no match exists. Update only affects records that already match the specified key.

Question 48Workflows and Data Processing

Which activity adds extra fields to the workflow target by linking to another schema or by using a formula?

  1. Split
  2. Deduplication
  3. Union
  4. Enrichment Correct answer.

Explanation

Enrichment adds columns to the target from a linked table or from an expression without replacing the original population. It is commonly used to enrich recipient data before a delivery.

Question 49Workflows and Data Processing

Which parameter of the Deduplication activity identifies the records that are considered duplicates?

  1. The transition label
  2. The duplicate identification criteria Correct answer.
  3. The delivery priority
  4. The scheduler frequency

Explanation

Deduplication compares records using the fields selected in its duplicate identification criteria. Records with matching values on those fields are treated as duplicates.

Question 50Workflows and Data Processing

Which activity links records from an incoming work table to existing records in the database by using a common key?

  1. Split
  2. Union
  3. Incremental query
  4. Reconciliation Correct answer.

Explanation

Reconciliation compares incoming rows with database records using a shared key and identifies linked, unlinked, or duplicate rows. It is commonly used after loading an external file into a work table.