Marketing Cloud Developers Certification Practice Test

These questions are part of the practice quiz. Start practicing

• To view coupons used in your Marketing Cloud account, which data view should you query?
• In optimization, where should you use the primary key field in a query against data extensions?
• Which function counts the rows in a data extension?
• Why should you always select a list under subscriber management when creating a Triggered Send Definition?
• Which function would you use to fetch a content block by its name (another phrasing)?
• The Journey data view provides information about journeys, including status, created and last modified date, and other general journey information. Which option matches this description?
• When deleting records created by child business units in Enterprise 2.0, which MID should be used in the request?
• Agency and Agency Client accounts deletions?
• What does the getContent(callback) method do in a Marketing Cloud block?
• Which function allows you to retrieve a content block by its numeric identifier?
• Which data view provides subscription history for MobileConnect SMS sends, such as which mobile numbers are subscribed to a keyword?
• What is the recommended practice for storing client credentials in an API Integration?
• Which query pattern is not permitted in this environment?
• When enabling Field-Level Encryption for your Marketing Cloud account, which statement correctly describes how data is handled after import?
• Which data view contains data on Marketing Cloud email send jobs?
• What does getData(callback) retrieve for a custom block?
• Which of the following describes how the RaiseError function behaves with its second parameter?
• What does SMTPBounceReason represent in Marketing Cloud data fields?
• Nested Queries are supported.
• Which description best characterizes LookupOrderedRows in AMPscript?
• In Case 1, REST focuses on resource-based operations inherited from HTTP. Which verbs are commonly used to manage resources?
• When creating an API Integration in Legacy Packages, which option is automatically selected for the integration type?
• Which statement correctly describes the four components of a REST request?
• Which function retrieves a content image by its Key?
• Data View _Unsubscribe is used to:
• Which data format is predominantly used in REST to support browser clients?
• What is the requirement to uninstall a package or app in Marketing Cloud?
• On-Your-Behalf accounts deletions originate in?
• What does the Content Builder SDK cross-document wrapper provide?
• Using SELECT * in a Query Activity can cause which behavior regarding fields added after the query is saved?
• Which statement about LookupRows is correct?
• Which is a valid Server-Side JavaScript block declaration?
• To view data related to spam complaints from subscribers, which data view should you query?
• Which grant type does not provide a refresh token?
• JOIN is a supported SQL construct.
• Which SQL statement retrieves tracking information for a triggered send by querying the tracking data view?
• What does the ContentArea AMPscript function return?
• What does setData(dataObject, callback) do, and what risk does a partial data object introduce?
• Which data view is used to view email open events in Marketing Cloud?
• For On-Your-Behalf accounts, deletions originate in the parent account and cascade to which accounts?
• What is a fundamental property of REST that contrasts with SOAP's statefulness?
• Block widgets interact with the editor using what mechanism?
• To retrieve a content image by its ID, which function is used?
• Which type of integration performs tasks without an end-user context?
• Which SSJS statement adds a new row to a Data Extension?
• What is a recommended practice for data view queries to improve performance?
• Which of the following is a valid redirect URI for local testing in Enhanced Packages?
• Which pair best describes the core elements of a triggered send definition?
• What token flow is used for server-to-server integrations to obtain an access token?
• To add custom Journey Builder events or activities to an existing Marketing Cloud app, what must you do?
• After you add an API Integration component to a package, can you remove it?
• REST calls have different timeout values depending on operation. Which of the following is correct?
• GROUP BY is a supported SQL construct.
• What does FTAF stand for in Marketing Cloud terminology?
• To provide a real-time update experience, how should a custom block update the canvas when a user makes changes?
• Which AMPscript functions are listed for Field-Level Encryption Data Imports?
• LookupOrderedRowsCS returns a specified number of rows.
• How should you add custom Journey Builder events or activities to an existing Marketing Cloud app?
• What does URI stand for in REST APIs, and what does it specify?
• Which statement reflects best practice for triggered send definitions?
• In the example BuildRowSetFromString('123|456|789', '|'), how many rows are returned in the rowset?
• Contact Delete removes contact information across the entire enterprise for Enterprise 2.0 accounts.
• In Enterprise 2.0 accounts, when profile attributes are created, which data view can return profile attribute columns in addition to the standard columns?
• UNION is a supported SQL construct.
• Open-ended comment designations such as -- to comment out a line are not supported.
• What is the effect of calling triggerAuth(appID)?
• To persist user-selected configuration separately from the block content, which method should you use?
• Which statement best describes the UpsertData function?
• Which condition is a primary reason to use SOAP?
• How is a transactional message accessed in the SOAP API?
• Which account type isolates deletions to that account, no matter which accounts exist in the larger structure?
• What does JobID represent in the context of an email send?
• Which statement accurately describes REST in contrast to SOAP?
• In Enterprise 2.0 accounts, deletions must originate from which account?
• True or false: In Enhanced Packages, the API Integration component cannot be removed once added.
• Which data view provides behavioral information related to email messages forwarded to friends (FTAF)?
• Which data view lets you view subscribers in your Marketing Cloud account and their statuses (note that subscriber attributes are not available)?
• If you want to fetch a content block by its name, which function should you call?
• Where is the triggered send definition located in the UI?
• In best practices, which statement is correct regarding Publish vs Pause/Start?
• UpsertDE can add a new row if no match is found. Which option reflects this behavior?
• Lock-and-Publish accounts deletions?
• In ContentArea, which parameters are required?
• Which operator should be avoided in a WHERE clause to improve performance?
• Which method exports data as encrypted data only when Field-Level Encryption is enabled?
• To find subscribers on lists in your Marketing Cloud account, which data view should you query?
• In the example usage of BuildRowSetFromString, how many values are produced?
• In server-to-server integrations, which credentials are used to request the access token in the client credentials flow?
• Which data view provides information about publication lists in Marketing Cloud, including SMS opt-ins?
• What is AMPScript usage for transactional messages?
• Which statement is true about EnterpriseAttribute data view limitations?
• Email tracking data extensions allow only SELECT statements to data extensions or data views.
• What is the host in the sample request for the token endpoint?
• In a Marketing Cloud app integration, what is the Endpoint URL used to load assets and define the base path for resources?
• Which statement best describes REST API capabilities?
• Which data view provides SMS message tracking information for MobileConnect SMS sends, including send and receive history?
• Which authentication method does an enhanced Marketing Cloud App package use to acquire an access token on behalf of a user?
• Which statement about redirect URIs in Enhanced Packages is true?
• When re-importing a MobileConnect contact, which status must be re-imported?
• Which data view provides tracking data on content shared from your Marketing Cloud sends via Social Forward?
• LookupRowsCS returns a rowset from a data extension where the field matches the specified value.
• Which of the following is NOT a field when creating a Triggered Send Definition?
• Which statement best describes what a triggered send definition does?
• InsertData is used in which scenarios?
• The Forward To A Friend data view stores what kind of information?
• What base URLs are accessed with the access token?
• SOAP can benefit developers when there is a high need for transactional reliability due to support for which features?
• Which statement best describes the JourneyActivity data view?
• Which scenario best illustrates REST's suitability for extensive back-and-forth messaging?
• What happens when you uninstall a package installed from AppExchange across the enterprise?
• For Field-Level Encryption Data Imports, which option is used for Triggered Sends?
• What is the effect of splitting a long query into multiple component queries that each have timeouts of 30 minutes?
• Understand the Contact Record Deletion Process
• LookupOrderedRowsCS treats strings as case-sensitive.
• When using setContent, which statement about the source of truth for content is correct?
• What is the recommended action to improve performance when business-critical functions rely on data extensions used in a query activity?
• Which account type isolates deletions to that account regardless of the larger structure?
• Data views such as _open and _click have what limitations?
• SetSuperContent is intended for what purpose in the editor?
• Which data view does not support MobileConnect?
• Public App Integration describes which of the following?
• Which of the following is a correct example of a component of a triggered send?
• To identify the Triggered Send Definition for an email activity in a Marketing Cloud journey, which data view would you join to the email tracking system data views?
• Which statement describes a key characteristic of SOAP?
• When should you use SELECT DISTINCT queries?
• Which SSJS call adds a subscriber to a List?
• What is a potential risk of passing a partial data object to setData?
• What does DataExtensionRowCount return?
• In Field-Level Encryption Data Imports, which API calls are available?
• In the Data View: Bounce example, what does left(smtpbouncereason, 4000) accomplish?
• REST calls are which of the following?
• Which statement about JSON in REST payloads is true?
• How can AttributeValue be used with Lookup to retrieve an attribute's value?
• Which function would you use to retrieve a content block by its numeric identifier?
• What fields are included in the token request for server-to-server integration?
• Which statement best describes the communication mechanism used by block widgets?
• Which statement about REST API requests is false?
• What is a recommended approach to improve performance for a poorly running query in Automation Studio?
• Data View _UndeliverableSms is used to view:
• Which function would you use to retrieve a content image by its ID?
• What is the primary purpose of calling setSuperContent on a custom block in the editor?
• For handling errors at scale, what approach is recommended instead of RaiseError?
• What is a potential side effect of using intermediate tables when you have many joins?
• In the SMS message tracking data view, which values are currently represented as static GUIDs?
• True or false: You can't URL-encode a redirect URI in Enhanced Packages, as part of API Integration.
• Which attribute is used to specify the execution context name in a Server-Side JavaScript block?
• Which statement about using setContent is correct?
• What does ContentAreaByName do?
• Which statement is true about the InsertDE function's scope?
• LookupOrderedRowsCS supports specifying multiple additional field-value pairs as part of an AND clause.
• What is the REST API route for sending transactional messages?
• Which statement describes REST + JSON as an easy way to expose web services?
• Which data view provides information about publication lists and can be used with SMS messages?
• What does ListID represent in Marketing Cloud data sends?
• Which data view lets you view impression data for content shared from your Marketing Cloud sends via Social Forward?
• Which statement best describes the InsertDE function in Marketing Cloud?
• Which clause should you specify with TOP queries to avoid unpredictable results?
• In the AMPscript example %%=Lookup('PostalCode','City','PostalCode',46016)=%%, what value is returned?
• Which statement correctly describes SOAP's support for reliability and security features?
• Which is an efficient search for last names starting with H?
• What fields are typically returned in a Marketing Cloud access token response?
• What is a key REST advantage in terms of developer response and testing?
• What context does getUserData(callback) provide about the currently authenticated user?
• Which function retrieves a content block by its Key?
• Which pattern is not permitted when combining data joins with column selection?
• To view click data for links in emails, which data view should you query?
• If Field-Level Encryption is enabled, exporting data via a data extension export to an FTP location results in what?
• MIN and MAX functions are supported.
• The AttributeValue AMPscript function can pull values from which data sources? (Select the most complete option.)
• In Enhanced Packages, true or false: After you add an API Integration component, it can't be removed.
• Which account type isolates deletions to that account, regardless of other accounts in the structure?
• Web Apps make API requests in the context of an end user and are issued what credentials?
• Which statement about the AMPscript Lookup function is true?
• For Enterprise 2.0 accounts, where does Enable Contact Delete occur?
• Data View _SurveyResponse is used to:
• IF constructs are supported for conditional statements.
• What is a practical outcome of REST tooling and browser extensions for developers?
• What is the account ID in a token request typically referred to as?
• According to best practices, what should you do when working with Triggered Send Definitions?
• Which statement about the Data View _SubscriberSMS is true?
• In an access token, the token grants access to which services?
• Which data view would you use to view the subscription history for SMS sends?
• Which of the following is true about the UpsertDE function?
• Public Apps are issued which credential(s) because they cannot maintain the confidentiality of a client secret?
• What does the InsertData function return when inserting a row into a data extension?
• The LookupOrderedRows example returns which of the following?
• Which data view would you query to view subscriber statuses in your account?
• What is the maximum payload for any REST call?
• If a query activity is part of a program or automation, what should you not do on the same step?
• What is the purpose of Triggered Send in Marketing Cloud SSJS?
• Which data view is used to confirm which subscribers were sent emails from your account?
• What is the default timeout for a query activity?
• An Installed Package Component is described as:
• Which HTTP verbs are typically used for CRUD operations in REST?
• JourneyActivityObjectID corresponds to which field in the _Sent, _Open, _Bounce, and _Unsubscribe data views?
• What is the content of the Public App Integration examples?
• Which data view lets you view subscribers in your Enterprise Marketing Cloud account and their profile attributes?
• Which function is restricted to use in landing pages, microsites, CloudPages, or an SMS message in MobileConnect?
• CAST and CONVERT functions are supported.
• What are the valid width constraints when using setBlockEditorWidth(width, callback())?
• Which statement about LookupRows is correct?
• Regarding the content passed to the callback versus the Super Content, is it always identical?
• Which data view would you query to view emails sent from your Marketing Cloud account?
• To create and install packages in Marketing Cloud, which permission is required?
• Agency and Agency Client account deletions behave how?
• Which data view provides tracking data on content shared from your Marketing Cloud sends via Social Forward?
• What happens when you delete a contact related to Email Studio?
• Which statement about the OAuth 2.0 integration in the enhanced Marketing Cloud App is true?
• Which data view would you query to view subscriber profile attributes added in Enterprise 2.0 accounts?
• What are the components of a triggered send?
• Does the width set by setBlockEditorWidth persist across sessions?
• Who can delete a package or app in Marketing Cloud?
• MobileConnect and MobilePush Contact Deletion
• What is the lifetime of an access token in this system?
• In Marketing Cloud, what tool is used to run queries against data views?
• When assigning scopes for a Legacy Package API Integration, what is recommended?
• What is the endpoint to request an access token in the v2 token flow?
• Which API supports username and password authentication?
• Who can install packages and apps in Marketing Cloud?
• Which statement best describes the SOAP API in Marketing Cloud?
• What does ContentAreaByName do, in terms of return behavior?
• Which statement best describes the use of Super Content in the block preview?
• For data views, what cap is recommended to optimize performance?
• What does the baseUrl represent in a Marketing Cloud integration?
• Which statement describes a benefit of explicitly listing column names in the SELECT clause rather than using SELECT *?
• Which SQL expression removes both carriage return and line feed characters from a string?
• LookupRowsCS returns a maximum of 2000 rows.
• Which statement best characterizes REST in terms of complexity and transparency?
• Which of the following lists the HTTP methods used by REST in this context?
• What does AttributeValue return if the requested attribute is not available in the current data source context?
• What is the purpose of intermediate tables in query design?
• What does the scope field represent in the access token request?
• What is emphasized about deleting contacts in Marketing Cloud?
• Which statement accurately describes SOAP's support for formal contracts and reliability features?
• Which statement correctly describes the InvokeCreate operation?
• Which statement best describes the relationship between REST and browser clients regarding data formats?
• Which data view lets you view subscribers in your Marketing Cloud account and their statuses, with no access to subscriber attributes?
• In AMPScript, what is the correct order of operations for composing and sending an email?