A utility company wants to visualize data for energy usage on a daily basis in Amazon QuickSight A data analytics specialist at the company has built a data pipeline to collect and ingest the data into Amazon S3 Each day the data is stored in an individual csv file in an S3 bucket This is an example of the naming structure 20210707_datacsv 20210708_datacsv
To allow for data querying in QuickSight through Amazon Athena the specialist used an AWS Glue crawler to create a table with the path "s3 //powertransformer/20210707_data csv" However when the data is queried, it returns zero rows
How can this issue be resolved?

1. A. Modify the IAM policy for the AWS Glue crawler to access Amazon S3.
2. B. Ingest the files again.
3. C. Store the files in Apache Parquet format.
4. D. Update the table path to "s3://powertransformer/".

Correct Answer: D

A company is migrating its existing on-premises ETL jobs to Amazon EMR. The code consists of a series of jobs written in Java. The company needs to reduce overhead for the system administrators without changing the underlying code. Due to the sensitivity of the data, compliance requires that the company use root device volume encryption on all nodes in the cluster. Corporate standards require that environments be provisioned though AWS CloudFormation when possible.
Which solution satisfies these requirements?

1. A. Install open-source Hadoop on Amazon EC2 instances with encrypted root device volume
2. B. Configure the cluster in the CloudFormation template.
3. C. Use a CloudFormation template to launch an EMR cluste
4. D. In the configuration section of the cluster, define a bootstrap action to enable TLS.
5. E. Create a custom AMI with encrypted root device volume
6. F. Configure Amazon EMR to use the custom AMI using the CustomAmild property in the CloudFormation template.
7. G. Use a CloudFormation template to launch an EMR cluste
8. H. In the configuration section of the cluster, define a bootstrap action to encrypt the root device volume of every node.

Correct Answer: C