A company wants to use an automatic machine learning (ML) Random Cut Forest (RCF) algorithm to visualize complex real-world scenarios, such as detecting seasonality and trends, excluding outers, and imputing missing values.
The team working on this project is non-technical and is looking for an out-of-the-box solution that will require the LEAST amount of management overhead.
Which solution will meet these requirements?

1. A. Use an AWS Glue ML transform to create a forecast and then use Amazon QuickSight to visualize the data.
2. B. Use Amazon QuickSight to visualize the data and then use ML-powered forecasting to forecast the key business metrics.
3. C. Use a pre-build ML AMI from the AWS Marketplace to create forecasts and then use Amazon QuickSight to visualize the data.
4. D. Use calculated fields to create a new forecast and then use Amazon QuickSight to visualize the data.

Correct Answer: A

A data analytics specialist is setting up workload management in manual mode for an Amazon Redshift environment. The data analytics specialist is defining query monitoring rules to manage system performance and user experience of an Amazon Redshift cluster.
Which elements must each query monitoring rule include?

1. A. A unique rule name, a query runtime condition, and an AWS Lambda function to resubmit any failed queries in off hours
2. B. A queue name, a unique rule name, and a predicate-based stop condition
3. C. A unique rule name, one to three predicates, and an action
4. D. A workload name, a unique rule name, and a query runtime-based condition

Correct Answer: C

A company stores Apache Parquet-formatted files in Amazon S3 The company uses an AWS Glue Data Catalog to store the table metadata and Amazon Athena to query and analyze the data The tables have a large number of partitions The queries are only run on small subsets of data in the table A data analyst adds new time partitions into the table as new data arrives The data analyst has been asked to reduce the query runtime
Which solution will provide the MOST reduction in the query runtime?

1. A. Convert the Parquet files to the csv file format..Then attempt to query the data again
2. B. Convert the Parquet files to the Apache ORC file forma
3. C. Then attempt to query the data again
4. D. Use partition projection to speed up the processing of the partitioned table
5. E. Add more partitions to be used over the tabl
6. F. Then filter over two partitions and put all columns in the WHERE clause

Correct Answer: C

A marketing company is using Amazon EMR clusters for its workloads. The company manually installs third- party libraries on the clusters by logging in to the master nodes. A data analyst needs to create an automated solution to replace the manual process.
Which options can fulfill these requirements? (Choose two.)

1. A. Place the required installation scripts in Amazon S3 and execute them using custom bootstrap actions.
2. B. Place the required installation scripts in Amazon S3 and execute them through Apache Spark in Amazon EMR.
3. C. Install the required third-party libraries in the existing EMR master nod
4. D. Create an AMI out of that master node and use that custom AMI to re-create the EMR cluster.
5. E. Use an Amazon DynamoDB table to store the list of required application
6. F. Trigger an AWS Lambda function with DynamoDB Streams to install the software.
7. G. Launch an Amazon EC2 instance with Amazon Linux and install the required third-party libraries on the instanc
8. H. Create an AMI and use that AMI to create the EMR cluster.

Correct Answer: AE
https://aws.amazon.com/about-aws/whats-new/2017/07/amazon-emr-now-supports-launching-clusters-with-cust https://docs.aws.amazon.com/de_de/emr/latest/ManagementGuide/emr-plan-bootstrap.html