2023年最新のMarketing-Cloud-Consultant問題集レビュー専門クイズ学習材料
Marketing-Cloud-Consultantテスト準備トレーニング練習試験問題 練習テスト
質問 # 51
Northern Trail Outfitters wants to send an email to website visitors who add items to their cart but fail to make a purchase. The email will include a list of products they added to their shopping cart.
* A sendable data extension contains the contact information and a session ID field for each subscriber who has abandoned their cart.
* A second data extension contains a corresponding session ID field and product data for each abandoned cart item, including product SKU, product name, quantity, price, and image URL.
Which feature should be used to display the list of products for each subscriber in this email?
- A. LookupRows AMPscript function
- B. Lookup AMPscript function
- C. Dynamic Content Block
- D. Enhanced Dynamic Content Block
正解：A
解説：
Explanation
The LookupRows AMPscript function returns a rowset from a data extension that matches the specified criteria. It can be used to retrieve multiple rows of data from a data extension based on one or more column values. For example, NTO can use the LookupRows function to retrieve all rows from the second data extension that have the same session ID as the subscriber in the sendable data extension, and then loop through the rowset to display the product data for each abandoned cart item in the email. References:
https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-co
質問 # 52
Northern Trail Outfitters (NTO) wants to import recent customer transaction data from their data warehouse into Marketing Cloud on a nightly basis. They plan to create a File Drop Automation to trigger an automation when a data file is transferred from the data warehouse to the import folder in their Enhanced FTP account.
NTO notes that user passwords expire every 90 days and they do not want to update their file transfer script on the data warehouse each time a password changes and they do not want to compromise security.
Which solution should the consultant recommend?
- A. Request SSH key authentication to be enabled for the FTP user and create an SSH Key in Key Management
- B. Enable the 'Exclude FTP Users From Password Expiration' option in Setup > Security Settings
- C. Contact the Marketing Cloud account representative to enable Single Sign-On Authentication using SAML
- D. Upload data files to Marketing Cloud using SFTP instead of FTP
正解：A
質問 # 53
Northern Trail Outfitters (NTO) wants to use dynamic content within their emails to provide customers with more personalized communications. This includes using a Dynamic Sender Profile to customize the From Name and From Email Address to use the regional store manager's information. If a new manager is assigned to a region, NTO only wants to update the information in one place.
What data should a consultant ensure exists within Marketing Cloud in order to facilitate this?
- A. Regional store manager's name and email address for each customer.
- B. Region code, regional store manager's name, and email address for each customer.
- C. Each customer's region code and the manager's name and email address for each region code.
- D. Name and email address for each regional store manager stored on a lookup table.
正解：C
質問 # 54
Northern Trail Outfitters is investigating implementing MobileConnect to allow SMS messaging in their UK, Germany, and Swiss subsidiaries. Each subsidiary has its own business unit and they are trying to determine if a single long code could be used for all markets.
What functionality would tie to additional long code Implementation?
- A. Do they need to have independent reporting on SMS sends by country?
- B. Do they need to support different From Names by country?
- C. Do they need to support UTF-8 characters in their SMS?
- D. Do they need to support inbound messages in each country?
正解：D
質問 # 55
Northern Trail Outfitters has integrated their Marketing Cloud account with their Salesforce sandbox.
In what order should the steps be performed to refresh the sandbox in their integrated account?
- A. Refresh / Disconnect / Reconnect / Synchronize / Authenticate
- B. Refresh / Disconnect / Reconnect / Authenticate / Synchronize
- C. Disconnect / Refresh / Reconnect / Authenticate / Synchronize
- D. Disconnect / Refresh / Reconnect / Synchronize / Authenticate
正解：C
質問 # 56
A retail company's database of record resides at a 3rd-party company that also keeps track of purchase history.
That database only updates once a day where new records can be created and merged. The database uses an
"Email ID," which is a numeric field that represents both the business unit and email address. The company now wants to be able to send real-time Welcome emails to people (newly registered website users) who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to "Email ID" in the database.
What key issue should be addressed? Choose 3 answers
- A. What will be used as the Subscriber Key?
- B. Will the company need a custom preference center?
- C. What publication lists will be used?
- D. Will new users have an "Email ID"?
- E. How will Marketing Cloud and the database sync up?
正解：A、D、E
質問 # 57
A retail company needs to create journeys that will target subscribers based on website behavior. They have identified three separate groups:
* Customers who searched for an item on their website.
* Customers who abandoned a cart on their website.
* Customers who made a purchase on their website.
What should the consultant ask in order to design the data structure for this solution? (Choose three.)
- A. Should a single customer exist in multiple journeys at the same time?
- B. Should customers exit the journey when the goal is met?
- C. How many messages should be included in each journey?
- D. How long after the behavior occurs will a subscriber need to enter a journey?
- E. How are subscribers identified in your web analytics?
正解：A、D、E
質問 # 58
Northern Trail Outfitters is investigating implementing MobileConnect to allow SMS messaging in their UK, Germany, and Swiss subsidiaries. Each subsidiary has its own business unit and they are trying to determine if a single long code could be used for all markets.
What functionality would tie to additional long code Implementation?
- A. Do they need to have independent reporting on SMS sends by country?
- B. Do they need to support different From Names by country?
- C. Do they need to support UTF-8 characters in their SMS?
- D. Do they need to support inbound messages in each country?
正解：D
解説：
Explanation
Supporting inbound messages in each country would require additional long code implementation for MobileConnect. A long code is a standard phone number that can send and receive SMS messages. Each country has its own regulations and requirements for long codes, so a single long code cannot be used for all markets. The other functionalities do not tie to additional long code implementation. References:
https://help.salesforce.com/s/articleView?id=sf.mc_moc_long_codes.htm&type=5
質問 # 59
Northern Trail Outfitters (NTO) wants to personalize emails and display different content based on customer points. NTO has limited development expertise and chooses to use dynamic content.
What should the consultant consider when building dynamic content rules?
- A. Standardize field naming across all sendable data extensions.
- B. Create a custom list and add all fields required for personalization.
- C. Create a synchronized data extension to keep all fields required for personalization up-to-date
- D. Build rules before uploading the respective content.
正解：D
解説：
Explanation
A consideration that should be made when building dynamic content rules is that rules should be built before uploading the respective content. Dynamic content rules are rules that define what content should be displayed based on subscriber attributes or behaviors. Dynamic content rules should be created before uploading content blocks or images into Content Builder, as they cannot be edited after content is uploaded. References:
https://help.salesforce.com/s/articleView?id=sf.mc_ceb_dynamic_content_rules.htm&type=5
質問 # 60
Northern Trail Outfitters wants to suppress their highly engaged email subscribers (multiple opens and clicks for a target campaign) from active display campaigns to reduce overall cost and eliminate unnecessary targeting to the user.
What should be recommended?
- A. Mobile Studio
- B. Einstein Engagement Scoring
- C. Advertising Studio
- D. Google Analytics 360
正解：B
質問 # 61
A customer wants to create a mobile app that requires users to log in or register before accessing their dat
a. Their source of truth Is Sales Cloud which Is connected to Marketing Cloud. Users who log In with existing credentials will have their device associated with their ContactKey. Users who register with the mobile app will not have their devices associated with a ContactKey for up to 24 hours.
What consideration should a consultant provide to the customer?
- A. User device data is unavailable in Contact Builder for up to 48 hours.
- B. All mobile app users will create additional Contacts in Marketing Cloud.
- C. Newly registered users will create additional Contacts in Marketing Cloud.
- D. Existing users will create additional Contacts in Marketing Cloud.
正解：C
質問 # 62
An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and NotSent, to ensure they are fulfilling a legal obligation due to the nature of their messages.
What method should be suggested in this scenario?
- A. Data Retrieves on the Send Object
- B. Data View Export with every send
- C. Platform Events API
- D. Event Notification Service
正解：D
質問 # 63
Northern Trail Outfitters is sending to an audience of over one million subscribers. They will use 10 different personalized fields in the email which reside in multiple data extensions. The goal is a timely email send from start to finish as it contains a limited quantity, first come-first served, special offer.
How should they accomplish this task?
- A. Use the Lookup AMPscript function in the email to pull the fields from the data extensions for each subscriber.
- B. Create and populate profile attributes for each of the 10 data extension fields and schedule a send with high priority.
- C. Enable Send Throttling on high to ensure the speed Is increased to process the email as fast as possible.
- D. Create and send to a sendable data extension containing those needed fields using a query activity.
正解：A
質問 # 64
A customer provides a file containing only new and updated subscriber records exported from its marketing database.
* The file will be uploaded to the customer's Enhanced FTP automatically at 3AM daily.
* The customer requires that the import completes prior to 4AM.
* On average, the file will contain about 2 million rows of data each day.
Based on the customer's requirements and recommended best practices, how should the daily file be imported?
- A. Import the file to a list, using the 'add and update' method.
- B. Import the file to a data extension, using the 'add and update' method.
- C. Import the file to a data extension, using the 'overwrite' method.
- D. Import the file to a list, using the 'update only' method.
正解：B
解説：
Since Record count in more than 500 K so DE is used. New and Update is already specified in question.
質問 # 65
A publishing company presented the following: A need to send renewal reminders to customers whose subscribers expire in 7 days and 15 days. A campaign needs to created and managed by a general marketing user who will not have administrative rights and who is not technical. The customer's expiration data is included in the data filter.
Which three components should the customer's solution include?
- A. Triggered Send
- B. Template Based emails
- C. Data Filter
- D. Automation Studio
- E. Suppression List
正解：B、C、D
質問 # 66
A customer has an eCommerce site and Imports data into three data extensions daily; 'Orders', 'Order_Details' and 'Products' the data extension contains the following information:
* Orders: OrderId, CustomerId, OrderNumber, OrderDate, OrderTotal, GrandTotal
* Order_Details: ProductId, OrderId, Qty, UnitPrice, ExtendedPrice, Discount
* Products: ProductId, SKU, Name, Description, Cost, Price
What two actions should be taken in Data Designer?
- A. Create a one-to-one relationship between Order_Details and Products
- B. Create a one-to-one relationship between Orders and order_Details
- C. Create a one-to-many relationship between Orders and Order_Details
- D. Create a one-to-one relationship between the contact record and Order_Details
正解：A、C
質問 # 67
Northern Trail Outfitters wants to target all customer who have registered to receive Push Notifications. Their app uses the Mobile Push multiple with Mobile Push SDK.
In which two ways should this segment be created?
- A. Using Contact Builder, create a Filtered Data Extension from All Contact where there is a record in MobilePush Demographics.
- B. Using Journey Builder, target the entire customer database then filter using MobilePush Demographics attribute group.
- C. Using Mobile Studio, create a Mobile Push Filtered List filter on the MobilePush Demographics attribute group.
- D. Using Automation Studio, query the_MobilePushDemographics Data View and saved this to a data extension.
正解：B
質問 # 68
Every day at 3 a.m., Northern Trail Outfitter' (NTO) data lake instance starts generating a file that contains all records that should be sent one email or another for the next day's marketing campaigns. The size of the file varies depending on the previous day's tracking activity. As soon as the file is generated, NTO wants to import the data, segment the data, and then execute the daily sends.
What end-to-end process should deliver this efficiently?
- A. Triggered Automation> Import > Data Extension Extract > Marketing Journey
- B. Scheduled Automation > File Transfer > Import > Series of Query Activities
- C. Scheduled Automation > Import Activity > Series of Query Activities > Series of Sends
- D. Triggered Automation > Import Activity > Series of Query Activities > Series of Sends
正解：D
解説：
Explanation
To import the data, segment the data, and execute the daily sends as soon as the file is generated by the data lake instance, Northern Trail Outfitters should use a triggered automation that contains an import activity, a series of query activities, and a series of sends. A triggered automation can start when a file is dropped in a specified location, such as an FTP folder. An import activity can import the file into a data extension. A series of query activities can segment the data based on the criteria for different campaigns. A series of sends can send the emails to the segmented data extensions. References:
https://help.salesforce.com/s/articleView?id=sf.mc_as_automation_studio_triggers.htm&type=5
https://help.salesforce.com/s/articleView?id=sf.mc_as_import_activity.htm&type=5
https://help.salesforce.com/s/articleView?id=sf.mc_as_query_activity.htm&type=5
https://help.salesforce.com/s/articleView?id=sf.mc_es_create_a_user_initiated_email_interaction.htm&type=5
質問 # 69
A financial services customer wants to send email to customers who log in for the first on a new IP. This message should be deployed as fast as possible due to its sensitive content. The message contain information related to the login IP.
What should a consultant recommend to deploy the email?
- A. Inject the subscriber into a Journey.
- B. Execute a Triggered Emails Interaction.
- C. Use the Transactional Messaging API.
- D. Use a User-Initiated Emails Interaction.
正解：C
解説：
Explanation
The Transactional Messaging API can be used to send email to customers who log in for the first time on a new IP. The Transactional Messaging API allows for fast and reliable delivery of transactional messages, such as password resets, order confirmations, or account alerts. The message can include information related to the login IP by using personalization strings or AMPscript variables. References:
https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/transactional-messaging-api.html
https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/transactional-messaging-personalization
質問 # 70
Northern Trail Outfitters (NTO) stores customer purchase data m an external system. NTO ingests this data into Marketing Cloud through a file drop automation. The automation contains an import activity which overwrites a staging data extension, as well as an SQL Query activity which brings this data into a sendable data extension.
NTO's marketing manager wants to be informed If mort than 1,000 records are ever imported through this automation, and would also like to prevent the sendable date extension from being updated that day.
Which solution ts appropriate m this situation'
- A. validate the row count of the staging data extension and send a notification email.
- B. Write a custom SSJS script to
- C. Q Split the existing activities into two
separate automations. - D. Place a Verification Activity between the import and SQL Query activity.
- E. Implement a Wait Activity to wait until the data extension is populated with records.
正解：E
解説：
Explanation
By placing a Verification Activity between the import and SQL Query activities, you can check to see if more than 1,000 records have been imported from the external system. If the row count exceeds 1,000, the automation can be paused and a notification email can be sent. This will allow NTO's marketing manager to be informed if more than 1,000 records are imported, and will also prevent the sendable data extension from being updated that day. For further information, please refer to the following Salesforce documentation:
* Automation Studio Overview: https://help.salesforce.com/articleView?id=mc_as_overview.htm&type=5 * Automation Studio Activities: https://help.salesforce.com/articleView?id=mc_as_activities.htm&type=5 * Verification Activity in Automation Studio: https://help.salesforce.com/articleView?id=mc_as_verification_activity.htm&type=5 * Wait Activity in Automation Studio: https://help.salesforce.com/articleView?id=mc_as_wait_activity.htm&type=5
質問 # 71
Northern Trail Outfitters wants to export a data file to its SFTP using Automation Studio. The file should contain all subscribers who did not receive their intended email in the last 24 hours. The automation will be scheduled to run each day.
Which activity Is required in the automation?
- A. Data Extract Activity
- B. SQL Query Activity
- C. Report Definition Activity
- D. SendLog Extract
正解：D
解説：
Explanation
The SendLog Extract activity in Automation Studio will allow Northern Trail Outfitters to export a data file containing all subscribers who did not receive their intended email in the last 24 hours. The automation can then be scheduled to run each day to ensure that the data file is updated.
Reference: https://help.salesforce.com/articleView?id=mc_as_sendlog_extract_activity.htm&type=5
質問 # 72
Tracking Alias question:
- A. Same URL
- B. Differentiate clicking email
- C. Email Conversion Tracking
- D. Can be found in some reports
正解：A、B、C、D
質問 # 73
......
試験問題解答ブレーン問題集でMarketing-Cloud-Consultant試験問題集PDF問題：https://jp.fast2test.com/Marketing-Cloud-Consultant-premium-file.html
Marketing-Cloud-Consultant試験問題集、Marketing-Cloud-Consultant練習テスト問題：https://drive.google.com/open?id=1BXNhPt-5k58SJ0TCrX4blqWtck_QN-c_