Marketing Cloud Software Marketing Cloud Automation Studio 1 — Questions and Answers
Question 1: What is the primary purpose of Automation Studio in Salesforce Marketing Cloud?
- To design responsive email templates
- To automate multi-step marketing workflows and data management tasks (Correct answer)
- To manage subscriber preference centers only
- To build and publish landing pages
Correct answer: To automate multi-step marketing workflows and data management tasks
Automation Studio enables marketers to automate complex, multi-step marketing and data management workflows without requiring manual intervention.
Question 2: Which activity type in Automation Studio is used to run SQL queries against Marketing Cloud data extensions?
- Filter Activity
- Import File Activity
- SQL Query Activity (Correct answer)
- Script Activity
Correct answer: SQL Query Activity
The SQL Query Activity allows you to run SQL statements against data in Marketing Cloud data extensions to segment, transform, or aggregate records.
Question 3: Which trigger type in Automation Studio starts an automation when a file is dropped into a specific FTP location?
- Schedule Trigger
- API Trigger
- File Drop Trigger (Correct answer)
- Event Trigger
Correct answer: File Drop Trigger
The File Drop trigger starts an automation automatically when a file is detected in a designated folder on the Marketing Cloud Enhanced FTP site.
Question 4: What does the 'Import File' activity do in Automation Studio?
- Exports subscriber data to an external FTP server
- Sends a triggered email to newly imported contacts
- Imports data from a file into a Marketing Cloud data extension (Correct answer)
- Creates a new empty data extension
Correct answer: Imports data from a file into a Marketing Cloud data extension
The Import File activity reads records from a file (typically CSV) stored on the Enhanced FTP site and loads them into a specified Marketing Cloud data extension.
Question 5: In Automation Studio, what does the 'Script Activity' allow a marketer or developer to execute?
- Python scripts for machine learning models
- Server-Side JavaScript (SSJS) or AMPscript for data processing (Correct answer)
- Shell scripts on the Marketing Cloud server
- JavaScript on the subscriber's browser
Correct answer: Server-Side JavaScript (SSJS) or AMPscript for data processing
The Script Activity allows execution of Server-Side JavaScript (SSJS) or AMPscript within an automation for advanced custom data manipulation.
Question 6: What is the purpose of the 'Data Extract' activity in Automation Studio?
- To extract data from Salesforce CRM into Marketing Cloud
- To export data from Marketing Cloud data extensions into a file for FTP delivery (Correct answer)
- To permanently delete old records from data extensions
- To extract Journey Builder tracking metrics into a report
Correct answer: To export data from Marketing Cloud data extensions into a file for FTP delivery
The Data Extract activity exports data from Marketing Cloud (such as data extensions or tracking data) into a file, typically placed on the Enhanced FTP site for external pickup.
Question 7: What happens by default in Automation Studio when one activity in a multi-step automation fails?
- The automation automatically retries the failed activity up to three times
- The automation skips the failed activity and proceeds to the next step
- The automation halts at the failed activity and logs an error in the activity log (Correct answer)
- The automation sends a notification email and continues running
Correct answer: The automation halts at the failed activity and logs an error in the activity log
By default, when an activity fails in Automation Studio, the entire automation stops at that point and records an error entry in the activity log for administrator review.
Marketing Cloud Software Marketing Cloud Automation Studio 1
What is the primary purpose of Automation Studio in Salesforce Marketing Cloud?