ExamGecko
Search Search Login
Home Home / Salesforce / Certified Marketing Cloud Developer
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels. What should be recommended5
NTO uses an external CRM which only exports encrypted files. NTO's marketing manager team wants to use some of the subscriber data found in the CRM for future marketing sends. Which three actions should be included in an automation given these requirements? Choose 3
A developer is building a landing page in Marketing Cloud and an email with a Call-To page will display personal information about the subscriber. In which way could the developer create the CTA link?
A developer created an email using the fasubjectLine variable as the subject line. Due to revisions, the developer declared <>subjectLine in multiple locations throughout the email, including: Which subject line will be used at the time of deployment?
A developer is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each. Which application utilizes the REST API?
A developer wants to create a data model in Contact Builder. Which two applications will be able to use this newly-created data model for segmentation? Choose 2 answers
A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio. How should the developer optimize the query?
A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV. Which SQL functions could be used to change each line break to a single space?
NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?
A developer is troubleshooting why an API client Jd and chent_secret are authenticating yet failing to access data from a child business unit. What should be checked to validate the installed package can access the child business unit data?

Question 149 - Certified Marketing Cloud Developer discussion

Report
Export

Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a data extension In the Shared Data Extensions folder named 'MemberData'. This data extension contains basic address information, as well as Boolean fields labeled 'US' and 'Global' indicating to which business unit the subscriber belongs. Automation needs to be created in the US business unit to query all records in New York who are members of the business unit US.

SELECT * FROM MemberData WHERE State = 'NY' AND US = 1 What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views."?

A.
Incorrect syntax; Query Activities are written in SOQL
Answers
A.
Incorrect syntax; Query Activities are written in SOQL
B.
MemberData should be prefixed with ENT
Answers
B.
MemberData should be prefixed with ENT
C.
Query should check for a US value of True'
Answers
C.
Query should check for a US value of True'
D.
Query Activities cannot use the " wildcard
Answers
D.
Query Activities cannot use the " wildcard
Suggested answer: B
Show Answer
asked 23/09/2024
Ricardo Andres
30 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms