Which solution will protect the data and limit user access to the SELECT statement on a specific portion of data?

An organization needs to store sensitive information on Amazon S3 and process it through Amazon EMR. Data must be encrypted on Amazon S3 and Amazon EMR at rest and in transit. Using Thrift Server, the Data Analysis team users HIVE to interact with this data. The organization would like to grant access to only specific databases and tables, giving permission only to the SELECT statement.

Which solution will protect the data and limit user access to the SELECT statement on a specific portion of data?
A . Configure Transparent Data Encryption on Amazon EM
B . Create an Amazon EC2 instance and install Apache Ranger. Configure the authorization on the cluster to use Apache Ranger.
C . Configure data encryption at rest for EMR File System (EMRFS) on Amazon S3. Configure data encryption in transit for traffic between Amazon S3 and EMRF
D . Configure storage and SQL base authorization on HiveServer2.
E . Use AWS KMS for encryption of data. Configure and attach multiple roles with different permissions based on the different user needs.
F . Configure Security Group on Amazon EM
G . Create an Amazon VPC endpoint for Amazon S3. Configure HiveServer2 to use Kerberos authentication on the cluster.

View Answer

Answer: B