AD0-E318 Exam Questions Get Updated [2023] with Correct Answers [Q19-Q36]

QUESTION 19
The Recipient table is linked with a custom schema called Reservation, which contains a high volume of data that is needed at all times.
The deployment team reports that each time a query the location attribute the Reservation table, there is a long return time.
What should the Architect recommend?

Ensure the Location attribute contains string values at all times

Advise to run the query during right time when less load is on the db.

Reduce the data with the Reservation table to contain max 100,000 rows.

Apply a db index on the Location attribute of the Reservation table

QUESTION 20
A brick and mortar retailer that is experience a digital transformation typically outsources non-core business functions including marketing technology.
The retailer recently close Teradata as their data warehouse solutions.
The retailer wants to implement Adobe Campaign Classic and efficiently ingest data from Teradata, using the FDA connector to avoid the production and movement of flat files.
Which two hosting models should an Architect recommend?

Standalone

On-premises

Hybrid

Managed Service (Hosted)

Enterprise

QUESTION 21
A company has a campaign workflow that has 20 different segment defined in a Cell activity. Once the workflow reaches Delivery activity, the requirement is to provide counts that contain the following:
– Initial Query Population
– Count of records in each segment of the Cell activity
– Final Population targets in the Delivery

Which solution should the Architect recommend?

Within a JavaScript activity, write a script that queries the counts from the various branches this data then be sent via an Approval activity.

Use an Alert activity to notify the Workflow Supervisor to review the counts from the workflow.

Enable the”Target Content Approval” option within the delivery and assign it to the desired operator.

After the Delivery activity has completed, use a File Export activity to extract all counts into a CSV file on the SFTP server and send a notification

QUESTION 22
A multi-national customer has Adobe Campaign users working in different geographic locations. They want to ensure that operations in each country can only work with recipients with physical addresses based in their region.
Which solution should be used?

Implement a sysFilter condition on Recipient schema applying readAccess() condition based on Organizational Entity attributes of the Operator record, and Organizational entities defined by Region.

Leverage the GDPR module and implement national opt-in permissioning per country

Implement physically separate recipient tables per country with accessible () conditions on confidential attributes, and use Folder Permission to restrict access to Operator group organization by related region

Using the main Recipient schema, create dedicated Folders for each Country, and restrict Read rights by Operator Regional settings and Organizational entities

QUESTION 23
A client wants to protect PII data at recipient level for anyone that is not an Administrator.
What should the Architect do?

Add Visible with S{login) = ” admin to each PII attribute

Use Accessible with HasNamed Right = ‘admin for each PII attribute

Add AccessibleIf with S{login) = ” admin to each PII attribute

Use Visible with HasNameRight= administrator’ for each PII attribute

QUESTION 24
A technical Architect is setting up the data model for a new Adobe Campaign implementation.
The customer wants to set up personalized birthday campaign and has the following fields in the source database table.
* First_Name
* Age
* Social_Security
* Upload_Data
* DateOyBirth
Which two fields should be included in Campaign data mode? (Choose two.)

Social_Security, used for personalization

First_Name, used for personalization

Age, used for segmentation

DateOfBirth used for segmentation

Upload_Date used for segmentation

QUESTION 25
A company has Google Analytics. Adobe Campaign and Adobe target in their marketing stack.
They want to message customers with an hour after they abandon their carts.
Which option should the Architect recommend?

Configure an API call to Message Control to trigger on email to the customers.

Configure Experience Cloud triggered to target customers who abandon cart

Create all file export from google analytics to campaign with Abandon cart customer

Integration with Google Analytics using the Genesis connector and execute a Reminder campaign

QUESTION 26
In the database diagram, a company has tables orders products Recipient items.
*Recipient is linked to Orders as 1-N
*Products to Orders as N-N
RecipientID, Email Full Name, Customer ID Orders: Orders ID, Recipient ID, Product ID, Date of purchase items: Prodduct ID, order ID, item ID products Product ID, Name, Status, Creation Date.
Which columns act as both primary and forgive keys?

Recipient ID, Product ID, Order ID

Customer ID, Product ID, item ID

Order ID, Recipient ID, item ID

Recipient ID, Product ID, Customer ID

QUESTION 27
A brick and mortar retailer that is experience a digital transformation typically outsources non-core business functions including marketing technology.
The retailer recently close Teradata as their data warehouse solutions.
The retailer wants to implement Adobe Campaign Classic and efficiently ingest data from Teradata, using the FDA connector to avoid the production and movement of flat files.
Which two hosting models should an Architect recommend?

Standalone

On-premises

Hybrid

Managed Service (Hosted)

Enterprise

QUESTION 28
A customer needs help to optimize a workflow that automatically exports tracking records campaigns sent during the day.
The workflow has a scheduler that runs every 6 hours and reads tracking logs created current date minus 6 hours. During data validation, the customer notices that records are missing with this approach.
Which two recommendations should the Architect make? (Choose two.)

Add a scheduler to execute every 6 hours, use an option to store the date since last execution of the export workflow, and use as a reference point.

Use an incremental query activity to fetch the last modified records from the tracking table modified in the last 6 hours.

Create an incremental query activity to fetch the last modified records from the recipient table that has tracing logs modified in the last 6 hours.

Add a scheduler to execute every 6 hours and use a dirty flag to update the tracking record that was picked in the execution of the workflow

Create a loop with a wait for 6 hours, store an instance variable of the id field that was last selected, and use that in the next query.

QUESTION 29
A campaign workflow has been configured to query recipients that have received deliveries and clicked on a link in the past 90 days.
Delivery history will be retrieved from boardLOgRop and click history from trackingLogRcp: The data volumes for both tables are increasing by an average of 10 million per month.
Which two recommendations should the Architect make? (Choose two.)

Reduce time period and run the workflow more frequently

Recommend to use webAppLogRcp instead of trackingLogRcp

Avoid using both schemas when possible

Query data from trackingLogRcp and retrieve the related data from broadLogRcP

Increase the time period and run the workflow more frequently.

QUESTION 30
A client to enrich delivery data with additional custom information. The data will exist in a table will exist in a table named customDelivery, but will not be required for each delivery.
Which syntax be used?
A)

B)

C)

D)

Option A

Option B

Option C

Option D

QUESTION 31
A customer is migrating its legacy marketing platform with Adobe Campaign.
The customer has dependencies on a few significant custom database functions that enabled specific string manipulations and custom encryption.
While developing workflow, the team struggle to match these functions that the customer was able to use prior to Adobe Campaign.
What should the Architect recommend?

Get the development team to build a javaScript library to try to achieve what the sql functions are capable of doing.

Create workflow templates containing SQL code activities. Within each SQL code activity each database function can be defined.

Request the database team for the sql function defining and add those as SQL script objects in Administration -> Configuration -> SQL Scripts.

Implement the function in AC database and install them as package files in the prescribed xml structure.

QUESTION 32
The Adobe Campaign setup of a company has a large number of campaign and technical workflows.
The customer highlight that the impact of failing workflows could result in very high cost for them.
The Architect must ensure highlights that the impact of failing workflow could result in very high cost for them.
The Architect must ensure high availability and decides to configure several workflow servers.
What should the Architect do?

Use Workflow Heat Map and update the schedule timings of the recurring workflows

Define affinities on the workflows and update the wfserver module line in ni6/configure-<instance>.xml file to
<wfserver autoStart=”true” affinity=”XXX, YYY,’/>

Install multiple Adobe Campaign instances to get.several workflow servers and migrate the workflows

Define affinities on the workflows and update the wfserver module line in ni6/conf/confi- Instane>.xml file to

QUESTION 33
A client has a hybrid hosting model and is trying to send a request from a workflow to a third-party API. When sending the request. Adobe Campaign does not receive a response.
What is causing this issue?

User name is password is incorrect

The URL is not allowed is incorrect

The URL is not allowed in the serverConf.xml

Logging is not enabled

Adobe can only send requests via http method POST

QUESTION 34
During the production smoke test the marketer modifies the delivery properties like period and delivery validity to test the deployed templates.
The marketer does not remember all the changes done and wants to revert the changes by redeploying the package that contained the templates for executing more tests.
What should the Architect do?

Create a package of the affect entity and include the delivery meta data in the package definition

Create a package of the affected entity and include the definition of the delivery template

Create a package of the delivery template and include the default values

Create a package of the entity and include the delivery schema that contains the properties

QUESTION 35
An Architect on a new project needs to review the existing Campaign solution. The current solution sends emails, SMS, and Push messages.
The customer currently has a mobile application that sends approximately 500.000 Push messages an hour.
The company wants to add another mobile application to alert customers about the start of upcoming television shows.
Volume estimates for Push messages for the new application are approximately 1.5 million per hour.
What should the Architect focus on first for the new design?

The Workflow that operates the push messaging activities

The number of dedicated Push MTAs in the solution

Whether any of the existing channels have overlapping deliveries planned

The integration of the Push SDK into the mobile application

QUESTION 36
A company currently manages their Adobe Campaign users via Active Directory (LDAP).
In the future, they will be required to utilize a TLS 1.0 provider that the currently use to authenticate users on other platforms.
What is the risks this approach.

iDP server will not authenticate without a custom script.

LDAP will not support TLS 1.0.

Adobe IMS will not support upgrade from LDAP

Adobe IMS will not work with their provider

Leave a Reply Cancel reply