Free Salesforce MCE-Dev-201 Exam Dumps Questions & Answers

A marketer is planning a weekly promotionalsend.
Which two types of data extensions could be sent to?
Choose 2 answers

• A.  Synchronized Data Extension
• B.  Send Log Data Extension
• C.  Salesforce Data Extension
• D.  Sendable Data Extension

Northern Trail Outfitters (NTO) uses a numeric identifier for Subscriber Key. Customer data is stored in a data extension with the Subscriber Key set as a Primary Key.
Which step is required for NTO when creating relationships for this data extension in Data Designer'

• A.  Link the Contact ID to the Subscriber Key when creating the relationship
• B.  Use a one-to-one cardinality when creating the relationship
• C.  Link the Contact Key to the Subscriber's email address when creating the relationship
• D.  Set Subscriber Key as a text data type before linking the data extension to Contact Key

A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio. How should the developer optimize the query?

• A.  Configure a longer timeout period within Administration in Automation Studio.
• B.  Use intermediate tables to break queries into smaller parts.
• C.  Limit joins to the INNER JOIN within all SQL Query Activities.
• D.  Ensure all SQL Query Activities are in the same step in the automation.

A developer wants to retrieve a row of data from a data extension using the SOAP API. Which API Object should be used for this call?

• A.  DataExtension
• B.  Row
• C.  DataExtensionObject
• D.  DataExtensionField

A particular data extension need to be configured to store six months of data.
How shoulddata retention be added to the data extension in Email Studio?

• A.  Create a new data extension that includes data retention settings
• B.  Update the data extension configuration to include data retention settings.
• C.  Run a query to overwrite the rows with six months of data
• D.  Import a file to overwrite the rows with six months of data