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

Adobe Campaign Standard Developer Expert practice questions

One question at a time. Build your Adobe Campaign Standard 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 1Data model and schema design

Which attribute on a custom schema XML definition indicates that the schema extends an existing built-in schema?

  1. revLink
  2. target
  3. extendedSchema Correct answer.
  4. extends

Explanation

An extension schema uses the extendedSchema attribute to identify the base schema it adds fields or links to. The attribute value must be written in namespace:name form. The extends attribute is used for schema inheritance, which creates a separate schema that inherits structure.

Question 2Data model and schema design

By default, which namespace should be used for custom schemas created for an ACS instance?

  1. crm
  2. nms
  3. cus Correct answer.
  4. xtk

Explanation

The cus namespace is reserved for customer-defined schemas in Adobe Campaign Standard. Built-in schemas use namespaces such as nms and xtk. The crm namespace is associated with CRM connector data rather than general custom development.

Question 3Data model and schema design

What does autopk="true" on the main element of a schema do?

  1. Enables automatic schema extension
  2. Generates a reverse link on the target schema
  3. Creates an automatic primary key for the table Correct answer.
  4. Adds a unique index to every string field

Explanation

Setting autopk="true" on the main element tells Adobe Campaign to generate the primary key field for the schema's table. This avoids having to declare the key manually. The generated key is normally an integer field used to identify each row.

Question 4Data model and schema design

Which data type is appropriate for a field that stores long free-form text, such as a multi-paragraph description?

  1. memo Correct answer.
  2. boolean
  3. string
  4. long

Explanation

The memo type maps to a large text column and is intended for long free-form content. The string type is meant for shorter text values. Numeric and logical values use types such as long and boolean.

Question 5Data model and schema design

When defining a one-to-many link from a parent schema to a child schema, which link attribute identifies the reverse link on the child schema?

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

Explanation

For a one-to-many link, the revLink attribute names the link on the child schema that points back to the parent. This makes the child collection available from the parent record. The target attribute only names the schema being linked to.

Question 6Data model and schema design

What is the purpose of the label attribute on a schema element or attribute?

  1. It specifies the namespace used by the schema
  2. It defines the physical SQL column name for the field
  3. It declares the primary key for the table
  4. It provides the display name in the interface Correct answer.

Explanation

The label attribute supplies the human-readable name shown for the element or field in the ACS interface. It does not change the underlying SQL column name or the schema's technical identity. Labels can be localized for different users.

Question 7Data model and schema design

An enumeration in a schema is used to do what?

  1. Declare the primary key of the schema
  2. Restrict a field to a fixed list of allowed values Correct answer.
  3. Create a database index on a field
  4. Define a one-to-many link between two schemas

Explanation

An enumeration defines a named list of values that a field can accept. It is useful for fields such as status or type where only a known set of values is valid. The list is defined once and can be reused by multiple fields.

Question 8Data model and schema design

What is the main purpose of defining a dbindex on a schema field?

  1. To create an enumeration of values
  2. To generate a label for the field
  3. To enforce a foreign key relationship
  4. To improve query performance on that field Correct answer.

Explanation

A dbindex creates a database index that can speed up queries filtering or sorting on the indexed field. It does not define relationships or allowed values. A unique dbindex additionally prevents duplicate values.

Question 9Data model and schema design

An extension adds a 1-N link named orders to nms:recipient, targeting cus:order. The cus:order schema already defines a link named recipient. What must the revLink attribute on the new link be set to?

  1. cus:order
  2. recipient Correct answer.
  3. orders
  4. nms:recipient

Explanation

The revLink attribute must match the internal name of the existing link on the target schema. Here the target schema cus:order already has a link named recipient, so revLink must be recipient. Using the schema name or the new link name would not identify the reverse link correctly.

Question 10Data model and schema design

For a 1-N link, what does integrity="owned" specify?

  1. The link is optional and may be null
  2. The link is read-only in the UI
  3. The child record can exist without a parent
  4. Deleting the parent deletes the linked child records Correct answer.

Explanation

The owned integrity setting means the parent record owns the linked child records. When the parent is deleted, the linked child records are also deleted. This is useful for dependent records that have no meaning without the parent.

Question 11Data model and schema design

Which value correctly identifies the built-in recipient schema when used in an extendedSchema attribute?

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

Explanation

Schema references use the namespace:name format. The built-in recipient schema belongs to the nms namespace, so the correct reference is nms:recipient. A bare name or the wrong namespace would not resolve to the built-in schema.

Question 12Data model and schema design

Which change can be made by an extension schema to a built-in schema?

  1. Change the built-in schema's primary key type
  2. Add a new custom field to the built-in schema Correct answer.
  3. Rename a built-in field's internal name
  4. Delete an existing built-in field

Explanation

Extensions are additive: they can add new fields, links, or indexes to a built-in schema. They cannot remove built-in fields or change their core definitions. This preserves the integrity of Adobe's built-in data model.

Question 13Data model and schema design

In a custom schema, where is autopk="true" normally placed to generate the primary key?

  1. On the main <element> that represents the table Correct answer.
  2. On each <attribute> that is a key
  3. On the <srcSchema> root element
  4. On the <dbindex> element

Explanation

The autopk attribute belongs on the main element that represents the schema's table. That element contains the fields and links of the schema. Placing it on the root srcSchema or on an index element does not generate the table's primary key.

Question 14Data model and schema design

Which attribute on a link element names the schema that the link points to?

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

Explanation

The target attribute specifies the schema referenced by a link, using the namespace:name form. The revLink attribute names the reverse link on that target schema. The integrity attribute controls deletion behavior for linked records.

Question 15Data model and schema design

When defining an N-1 link, such as many recipients belonging to one country, which statement about revLink is correct?

  1. revLink is optional because no reverse collection is needed Correct answer.
  2. revLink must equal the target schema name
  3. revLink is mandatory for every N-1 link regardless of the target
  4. revLink must be set to the primary key field

Explanation

For an N-1 link, the child record points to one parent record, and a reverse collection is not required to use the link. The revLink attribute is therefore optional. A 1-N link needs revLink when the parent must expose the child collection.

Question 16Data model and schema design

Which attribute limits the maximum number of characters stored in a string field?

  1. precision
  2. length Correct answer.
  3. max
  4. size

Explanation

The length attribute sets the maximum character length of a string field in the schema definition. Precision is used for numeric types such as decimal values. Using the wrong attribute will not enforce the intended string size.

Question 17Data model and schema design

Inside an enumeration definition, which element declares one allowed value?

  1. <key>
  2. <value> Correct answer.
  3. <element>
  4. <attribute>

Explanation

An enumeration contains value elements, each declaring one allowed entry with a name and usually a label. Fields can then reference the enumeration by name. The other elements serve different schema purposes, such as declaring fields, table structures, or keys.

Question 18Data model and schema design

In ACS schemas with autopk enabled, what is the usual data type of the generated primary key field?

  1. integer Correct answer.
  2. boolean
  3. memo
  4. string

Explanation

The automatic primary key generated by autopk is an integer identifier. It uniquely identifies each row in the table. Text, logical, and memo types are not used for this generated key.

Question 19Data model and schema design

Which attribute is used to create a new schema that inherits all fields and links from an existing schema?

  1. revLink
  2. extendedSchema
  3. extends Correct answer.
  4. target

Explanation

The extends attribute creates schema inheritance, producing a new schema that inherits the structure of the parent schema. This is different from an extension, which uses extendedSchema to add fields to an existing schema. Inherited schemas can add their own fields while retaining the parent's definition.

Question 20Data model and schema design

What does integrity="neutral" on a link indicate?

  1. The parent record owns the child record
  2. The link is always mandatory
  3. Deleting either side has no automatic cascade effect on the other Correct answer.
  4. The link cannot be used in queries

Explanation

Neutral integrity means the link does not impose cascade deletion in either direction. The linked records remain unless they are deleted explicitly. This differs from owned integrity, where deleting the parent also deletes dependent children.

Question 21Data model and schema design

To prevent two records from having the same value in an email field, what should be defined?

  1. An enumeration on email
  2. A 1-N link on email
  3. A unique dbindex on email Correct answer.
  4. A non-unique dbindex on email

Explanation

A unique dbindex enforces uniqueness at the database level for the indexed field. A non-unique index improves lookup performance but still allows duplicate values. Enumerations restrict allowed values and links define relationships, but neither enforces uniqueness.

Question 22Data model and schema design

When extending nms:recipient, what happens to the label of an existing built-in field if the extension does not redefine it?

  1. It remains unchanged from the base schema Correct answer.
  2. It is cleared and must be redefined
  3. It is automatically prefixed with cus:
  4. It becomes the internal field name

Explanation

An extension only overrides or adds what it explicitly defines. If the extension does not redefine a built-in field's label, the original label from the base schema remains in effect. Redefining labels is optional and does not affect the field's internal name.

Question 23Data model and schema design

Why must a custom schema define or inherit a primary key?

  1. To make the schema visible in the data model editor
  2. To allow labels to be translated
  3. To enable the schema to use enumerations
  4. To allow the table to be joined and identify each row uniquely Correct answer.

Explanation

A primary key uniquely identifies each row and is required for reliable table joins and record updates. Without a primary key, the database cannot guarantee row identity. Enumerations, visibility, and labels do not depend on the primary key.

Question 24Data model and schema design

A link with link="1-N" on the parent schema means what?

  1. Many parent records can be associated with one child
  2. Exactly one parent and one child
  3. No relationship is enforced
  4. One parent record can be associated with many child records Correct answer.

Explanation

A 1-N link means one parent record can be associated with multiple child records. The reverse direction is usually a collection on the parent. An N-1 link expresses the opposite direction, where many children point to one parent.

Question 25Data model and schema design

An extension schema is created for nms:recipient. Which combination of name and namespace should its srcSchema element use?

  1. name="recipientExt" namespace="cus"
  2. name="recipient" namespace="cus"
  3. name="extRecipient" namespace="nms"
  4. name="recipient" namespace="nms" Correct answer.

Explanation

An extension schema uses the same name and namespace as the schema it extends so that it is treated as an extension of that schema. The extendedSchema attribute then points to nms:recipient. Using a different name or namespace would create a separate schema instead of extending the built-in recipient schema.

Question 26Data model and schema design

A developer needs to store a long, variable-length internal note on a custom schema. The note may exceed several thousand characters and is never used in a filter. Which data type is most appropriate?

  1. memo Correct answer.
  2. string
  3. datetime
  4. decimal

Explanation

The memo type is designed for long free-text values that can exceed the limits of a normal string field. A string field is length-constrained and intended for shorter values, while decimal and datetime store numeric or date/time data.

Question 27Data model and schema design

Which schema attribute is intended to hold internal documentation about the purpose of a field and is not the end-user display label?

  1. sqlname
  2. default
  3. desc Correct answer.
  4. label

Explanation

The desc attribute stores a description for developers and administrators, while label controls the user-facing name. sqlname changes the physical column name, and default supplies an initial value.

Question 28Data model and schema design

What is the primary role of the namespace attribute on a srcSchema element?

  1. It defines the input form used to edit records.
  2. It sets the database table owner.
  3. It groups schemas and provides the prefix used to reference them. Correct answer.
  4. It determines the folder where records are stored.

Explanation

A namespace groups related schemas and supplies the prefix used in references such as cus:order. It is not a database ownership setting, folder assignment, or form definition.

Question 29Data model and schema design

Which attribute on a schema field specifies the value assigned when a new record is created without an explicit value for that field?

  1. enum
  2. default Correct answer.
  3. mandatory
  4. sqlname

Explanation

The default attribute provides the initial value used when no value is supplied for the field. enum binds allowed values, mandatory marks required entry, and sqlname controls the physical column name.

Question 30Data model and schema design

A custom schema cus:order contains an enumeration named cus:orderStatus. Which field declaration correctly binds the field status to that enumeration?

  1. <attribute name="status" type="string" enum="cus:orderStatus"/> Correct answer.
  2. <enumeration name="status" ref="cus:orderStatus"/>
  3. <attribute name="status" type="cus:orderStatus"/>
  4. <attribute name="status" enumeration="cus:orderStatus"/>

Explanation

A field is bound to an existing enumeration with the enum attribute, using the namespace:name reference. The type attribute must still be a valid base type such as string, and enumeration is not a valid binding attribute on a field.

Question 31Data model and schema design

A field named internalCode is defined as <attribute name="internalCode" type="string"/>. The DBA wants the physical column named code_int without changing the logical field name. Which attribute should be added?

  1. alias
  2. dbindex
  3. sqlname Correct answer.
  4. label

Explanation

The sqlname attribute overrides the physical SQL column name while preserving the schema field name used in expressions and forms. label affects display text, dbindex creates an index, and alias is not the column-name override.

Question 32Data model and schema design

For a decimal field that must store values up to 99999999.99, which combination of precision and scale is correct?

  1. precision="10" scale="0"
  2. precision="8" scale="2"
  3. precision="2" scale="10"
  4. precision="10" scale="2" Correct answer.

Explanation

Precision is the total number of stored digits, and scale is the number of digits after the decimal point. The value 99999999.99 needs eight integer digits plus two fractional digits, so precision must be 10 and scale must be 2.

Question 33Data model and schema design

In a schema where many cus:order records belong to one cus:customer, what does the N-1 link on cus:order cause in the database?

  1. No database column is created for the link.
  2. A foreign key column is stored in the customer table.
  3. A foreign key column is stored in the order table. Correct answer.
  4. A join table containing order and customer IDs.

Explanation

An N-1 link is declared on the source side that references one target record, so the foreign key is stored on the source table. Here the source is cus:order, so the order table holds the customer key.

Question 34Data model and schema design

In Adobe Campaign schema design, what does mandatory="true" on a field indicate?

  1. The field is read-only in the user interface.
  2. The field must be populated when a record is created or saved. Correct answer.
  3. The field is automatically indexed.
  4. The field is excluded from the SQL table.

Explanation

The mandatory attribute marks a field as required for data entry, so a record cannot be saved without a value. It does not create an index, make the field read-only, or exclude it from storage.

Question 35Data model and schema design

If a string attribute declares no length attribute, what default maximum length does Adobe Campaign apply?

  1. 64
  2. Unlimited
  3. 1024
  4. 255 Correct answer.

Explanation

When a string field omits the length attribute, Campaign applies a default maximum length of 255 characters. Larger content should use memo or an explicit larger length where appropriate.

Question 36Data model and schema design

Which root attribute on a srcSchema element declares the schema document type as an Adobe Campaign source schema?

  1. namespace
  2. mappingType
  3. name
  4. xtkschema Correct answer.

Explanation

The xtkschema attribute identifies the document as a Campaign source schema, typically with the value xtk:srcSchema. mappingType controls storage mapping, namespace provides the prefix, and name identifies the schema itself.

Question 37Data model and schema design

Which mappingType value indicates that the schema is mapped to a SQL table?

  1. file
  2. memory
  3. xml
  4. sql Correct answer.

Explanation

The mappingType value sql indicates that the schema data is stored in a SQL table. The other listed values are not the mapping type used for SQL-backed Campaign schemas.

Question 38Data model and schema design

Which schema construct defines a composite primary key on the fields orderId and lineId?

  1. An autopk="true" setting on each of the two fields.
  2. A dbindex element with unique="true" listing both fields.
  3. Two link elements with integrity="defining" pointing to each field.
  4. A key element with internal="true" containing two keyfield entries for @orderId and @lineId. Correct answer.

Explanation

A composite primary key is declared with an internal key element whose keyfield children list each participating field. autopk generates a single surrogate key, a unique index is not a primary key, and links do not define primary key columns.

Question 39Data model and schema design

A developer defines an N-1 link from cus:order to cus:customer with integrity="owned". Why is this generally a poor design choice?

  1. It forces each customer to have exactly one order.
  2. It prevents the foreign key from being created on the order table.
  3. Deleting one order could delete the shared customer record. Correct answer.
  4. It makes the link read-only in the order form.

Explanation

With owned integrity, the source record owns the target record, so deleting the source can cascade to the target. In an N-1 relationship many orders share one customer, so one order deletion must not remove the shared customer.

Question 40Data model and schema design

Which statement correctly distinguishes an element from an attribute in a Campaign schema?

  1. An attribute can contain child links, while an element defines only a scalar field.
  2. An element can contain child elements or links, while an attribute defines only a scalar field. Correct answer.
  3. An attribute always defines a primary key, while an element always defines a foreign key.
  4. An element always creates a separate table, while an attribute always creates a column.

Explanation

An element may be a simple field or a complex container for child elements and links. An attribute is used for a simple scalar field and cannot itself contain nested schema structure.

Question 41Workflow development and orchestration

Which statement describes the role of the Start activity in an Adobe Campaign Standard workflow?

  1. It writes the final targeting population to an external file.
  2. It serves as the workflow's starting point. Correct answer.
  3. It stores the execution history for every activity in the workflow.
  4. It defines the recurrence pattern used for scheduled workflow runs.

Explanation

The Start activity is the entry point of a workflow; when the workflow is executed, the flow begins there. Recurrence is handled by the Scheduler activity, execution history is viewed in the History tab, and file output is performed by an Extract file or Transfer file activity.

Question 42Workflow development and orchestration

Which Scheduler activity setting determines the local clock used to calculate recurring execution times?

  1. Targeting dimension
  2. Transition type
  3. Error handling mode
  4. Time zone Correct answer.

Explanation

The Scheduler activity has a time zone setting that sets the reference clock for its recurrence. If no time zone is chosen, the instance or server default is used, which can shift the actual run time.

Question 43Workflow development and orchestration

In a Query activity, what does the targeting dimension identify?

  1. The delivery template applied to the selected population
  2. The schema or population that the query selects and outputs Correct answer.
  3. The output file format used for exported records
  4. The error behavior used when the query returns no records

Explanation

The targeting dimension tells the Query activity which schema its filters apply to and what schema the outbound transition carries. It is not related to file format, delivery template, or error handling.

Question 44Workflow development and orchestration

What is the purpose of the Wait activity in a workflow?

  1. It requests approval before the branch continues.
  2. It pauses a branch until a duration or date is reached. Correct answer.
  3. It removes duplicate records from the inbound transition.
  4. It exports the inbound population to a delimited file.

Explanation

Wait pauses the branch for a configured duration or until an absolute date. It does not remove records, export files, or request approval.

Question 45Workflow development and orchestration

Which best describes what a Split activity does with an inbound population?

  1. It links imported rows to existing profiles in the database.
  2. It divides the population into subsets based on defined criteria. Correct answer.
  3. It transfers a file to a remote FTP server.
  4. It merges several populations into a single outbound transition.

Explanation

Split evaluates criteria and routes the inbound population into separate subsets, each with its own outbound transition. Merging, reconciliation, and file transfer are performed by other activities.

Question 46Workflow development and orchestration

What is the function of the Load file activity?

  1. It writes the inbound population to a CSV file.
  2. It reads data from a file into the workflow as a transition. Correct answer.
  3. It pauses the workflow until a specified date.
  4. It sends an email delivery to the inbound population.

Explanation

Load file imports data from a source file and makes it available on the outbound transition. It is commonly followed by Reconciliation when the imported rows must be matched to existing profiles.

Question 47Workflow development and orchestration

Which task does the Delivery activity perform in a workflow?

  1. It schedules the workflow to run at recurring times.
  2. It splits the population into several subsets.
  3. It defines the schema used by the query.
  4. It sends a delivery to the inbound population. Correct answer.

Explanation

The Delivery activity takes the inbound population and executes a delivery, such as an email or SMS. It does not define schemas, schedule the workflow, or split populations.

Question 48Workflow development and orchestration

What information does the History tab of a workflow primarily show?

  1. The fields available in the targeting schema
  2. The content and HTML source of deliveries
  3. Past executions and their statuses Correct answer.
  4. The list of user permissions on the workflow

Explanation

The History tab records past workflow executions, including start and end times and status. It is not the place to view schema fields, delivery HTML, or user permissions.

Question 49Workflow development and orchestration

An imported list contains multiple rows with the same email address. You need to keep only one row for each email before sending a delivery. Which activity should you use?

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

Explanation

Deduplication removes or identifies duplicate records based on one or more key fields, so duplicate email rows can be reduced to one. Union combines populations, Intersection keeps common records, and Enrichment adds data.

Question 50Workflow development and orchestration

After loading a CRM file, you must match each imported row to an existing profile so the profile can be updated. Which activity is designed to link the incoming data to existing profiles?

  1. Edit
  2. Wait
  3. Reconciliation Correct answer.
  4. Extract file

Explanation

Reconciliation is used to link incoming data, such as rows from a Load file, to existing records in the database. This makes it possible to update existing profiles instead of creating unrelated rows.