Salesforce Marketing-Cloud-Administrator Exam With Confidence Using Practice Dumps

 To clear inactive data stored in data extensions after 12 months, NTO should apply a row-based retention to each data extension as it is created, set to 12 months. This will delete any records that have not been modified in the last 12 months. Row-based retention can be applied to individual data extensions or data extension templates

AMPscript is the skill set that the customer team needs to possess in order for this solution to be viable. AMPscript is a scripting language that allows marketers to create personalized and dynamic content for emails, landing pages, mobile messages, and more. AMPscript can be used to retrieve data from data extensions, track click activity, populate content areas, and apply conditional logic based on regional market or other attributes.

 The correct answer is C because File Drop Automation can be used to trigger an automation when a file is dropped on the SFTP, and Import File Activity and SQL Query Activities can be used to import and separate the data into different data extensions. A is incorrect because Scheduled Automation cannot check if the file is present on time. B is incorrect because Scheduled Automation cannot trigger an alert if the file is not present. D is incorrect because Filter Activity cannot separate the data into different data extensions.