DAS-C01 Question #87: Real Exam Question with Answer & Explanation

Question

A bank operates in a regulated environment. The compliance requirements for the country in which the bank operates say that customer data for each state should only be accessible by the bank's employees located in the same state. Bank employees in one state should NOT be able to access data for customers who have provided a home address in a different state. The bank's marketing team has hired a data analyst to gather insights from customer data for a new campaign being launched in certain states. Currently, data linking each customer account to its home state is stored in a tabular .csv file within a single Amazon S3 folder in a private S3 bucket. The total size of the S3 folder is 2 GB uncompressed. Due to the country's compliance requirements, the marketing team is not able to access this folder. The data analyst is responsible for ensuring that the marketing team gets one-time access to customer data for their campaign analytics project, while being subject to all the compliance requirements and controls. Which solution should the data analyst implement to meet the desired requirements with the LEAST amount of setup effort?

Options

• ARe-arrange data in Amazon S3 to store customer data about each state in a different S3 folder
• BLoad tabular data from Amazon S3 to an Amazon EMR cluster using s3DistCp.
• CLoad tabular data from Amazon S3 to Amazon Redshift with the COPY command.
• DLoad tabular data from Amazon S3 to Amazon QuickSight Enterprise edition by directly importing