Salesforce Certified Marketing Cloud Engagement Consultant Practice Questions

Salesforce Certified Marketing Cloud Engagement Consultant exam preparation

Salesforce Certified Marketing Cloud Engagement Consultant practice questions in English: 180 questions with explanations. The mock exam has 60 questions and 105 minutes.

Salesforce Certified Marketing Cloud Engagement Consultant free question 6 / 10 · Domain 4: Automation

A SQL Query activity in a nightly automation has failed on several runs and now shows as suspended. A consultant is asked how to get it running again. What does the Restart a Suspended SQL Query Activity article describe?

  1. Run it one time from the query list to test the fix, and then add it back to the automation by hand
  2. Open the action log, fix the error that it shows, and save, which restarts the activity
  3. Wait, as the system resolves a suspended query by itself and re-enables the activity
  4. Copy the suspended query and add the copy to the automation, then run the copy as a test
Show the answer and explanation

Answer: B

Why this is correct
A SQL Query activity is suspended when it encounters a system error or fails 24 consecutive times. To restart it, go to the action log and view the error, resolve the error, and save your work. After you edit and save the query activity, it's automatically restarted. If the log shows the error Query activity was terminated, you don't modify the activity, because that system error resolves automatically and re-enables the activity.

Why the other options are wrong
"Copy the suspended query and add the copy to the automation, then run the copy as a test" … You can't copy a suspended query, add it to an automation, or run it once. The fix is made on the suspended activity itself.
"Wait, as the system resolves a suspended query by itself and re-enables the activity" … Only the error Query activity was terminated resolves on its own. For all other errors you fix the problem stated in the error message.
"Run it one time from the query list to test the fix, and then add it back to the automation by hand" … A suspended query can't be run once. After you edit and save it, it is restarted automatically.

Key point
Read the action log. Fix the error, unless it is the self-resolving terminated error, and save.

Go to the Salesforce Certified Marketing Cloud Engagement Consultant practice app (10 free questions; purchase unlocks all questions)

See the full practice set