Marketing Cloud Software Marketing Cloud Automation Studio 3

Question 1

Which file format is most commonly used with the 'Import File' activity in Automation Studio for loading subscriber records?

Accepted Answer

CSV (Comma-Separated Values)

Answer

JSON (JavaScript Object Notation)

Answer

XML (Extensible Markup Language)

Answer

Parquet (columnar storage format)

Question 2

An SQL Query Activity in Automation Studio writes its output to which destination?

Accepted Answer

A specified target data extension in Marketing Cloud

Answer

Directly to a Salesforce CRM object

Answer

An external database via JDBC connection

Answer

The Marketing Cloud email send log

Question 3

Which of the following correctly describes the relationship between 'automations' and 'activities' in Automation Studio?

Accepted Answer

An automation is a container made up of one or more steps, each containing one or more activities

Answer

An activity contains multiple automations that run in sequence

Answer

Activities and automations are interchangeable terms for the same concept

Answer

A single activity can span multiple automations simultaneously

Question 4

What is the key difference between a 'Scheduled' trigger and a 'File Drop' trigger in Automation Studio?

Accepted Answer

Scheduled triggers run at defined time intervals; File Drop triggers start when a file arrives on the FTP site

Answer

Scheduled triggers support email sends; File Drop triggers only support data imports

Answer

Scheduled triggers require API calls; File Drop triggers run automatically every hour

Answer

Scheduled triggers are free; File Drop triggers require an additional license

Question 5

When an automation in Automation Studio is set to 'Run Once,' what does this mean?

Accepted Answer

The automation executes a single time at the scheduled start and does not repeat

Answer

The automation runs every 24 hours for one week then stops

Answer

The automation runs once per subscriber in the data extension

Answer

The automation is limited to one activity per step

Question 6

In Automation Studio, which best practice helps ensure data integrity when using the SQL Query Activity to overwrite a data extension?

Accepted Answer

Set the query to 'Overwrite' and verify row counts using a Verification Activity afterward

Answer

Always use the 'Append' action so no existing data is lost before the new query runs

Answer

Run the SQL Query Activity without a target to preview results before writing

Answer

Use the Filter Activity before the SQL Query Activity to reduce the dataset size

Question 7

Which of the following scenarios is best handled by Automation Studio rather than Journey Builder in Salesforce Marketing Cloud?

Accepted Answer

Nightly batch import of a CRM export file, SQL transformation, and a data-driven email send

Answer

Sending a personalized welcome email series triggered by a subscriber's signup

Answer

Real-time triggered messaging based on a subscriber opening a previous email

Answer

Branching subscriber paths based on engagement behavior over 30 days