An Amazon Redshift database contains sensitive user data. Logging is necessary to meet compliance requirements. The logs must contain database authentication attempts, connections, and disconnections. The logs must also contain each query run against the database and record which database user ran each query.
Which steps will create the required logs?

• A.Allow access to the Amazon Redshift database using AWS IAM only. Log access using AWS CloudTrail.
• B.Enable and download audit reports from AWS Artifact.
• C.Enable audit logging for Amazon Redshift using the AWS Management Console or the AWS CLI.
• D.Enable Amazon Redshift Enhanced VPC Routing. Enable VPC Flow Logs to monitor traffic.

Comment: *

Name: *

Email: *

Verification: *

A company is hosting an enterprise reporting solution with Amazon Redshift. The application provides reporting capabilities to three main groups: an executive group to access financial reports, a data analyst group to run long-running ad-hoc queries, and a data engineering group to run stored procedures and ETL processes.
The executive team requires queries to run with optimal performance. The data engineering team expects queries to take minutes.
Which Amazon Redshift feature meets the requirements for this task?

• A.Concurrency scaling
• B.Short query acceleration (SQA)
• C.Workload management (WLM)
• D.Materialized views

Comment: *

Name: *

Email: *

Verification: *

A financial company uses Amazon S3 as its data lake and has set up a data warehouse using a multi-node Amazon Redshift cluster. The data files in the data lake are organized in folders based on the data source of each data file. All the data files are loaded to one table in the Amazon Redshift cluster using a separate COPY command for each data file location. With this approach, loading all the data files into Amazon Redshift takes a long time to complete. Users want a faster solution with little or no increase in cost while maintaining the segregation of the data files in the S3 data lake.
Which solution meets these requirements?

• A.Load all the data files in parallel to Amazon Aurora, and run an AWS Glue job to load the data into Amazon Redshift.
• B.Use Amazon EMR to copy all the data files into one folder and issue a COPY command to load the data into Amazon Redshift.
• C.Create a manifest file that contains the data file locations and issue a COPY command to load the data into Amazon Redshift.
• D.Use an AWS Glue job to copy all the data files into one folder and issue a COPY command to load the data into Amazon Redshift.

Comment: *

Name: *

Email: *

Verification: *

A team of data scientists plans to analyze market trend data for their company's new investment strategy. The trend data comes from five different data sources in large volumes. The team wants to utilize Amazon Kinesis to support their use case. The team uses SQL-like queries to analyze trends and wants to send notifications based on certain significant patterns in the trends. Additionally, the data scientists want to save the data to Amazon S3 for archival and historical re-processing, and use AWS managed services wherever possible. The team wants to implement the lowest-cost solution.
Which solution meets these requirements?

• A.Publish data to two Kinesis data streams. Deploy a custom application using the Kinesis Client Library (KCL) to the first stream for analyzing trends, and send notifications using Amazon SNS. Configure Kinesis Data Firehose on the second Kinesis data stream to persist data to an S3 bucket.
• B.Publish data to one Kinesis data stream. Deploy Kinesis Data Analytic to the stream for analyzing trends, and configure an AWS Lambda function as an output to send notifications using Amazon SNS.
  Configure Kinesis Data Firehose on the Kinesis data stream to persist data to an S3 bucket.
• C.Publish data to one Kinesis data stream. Deploy a custom application using the Kinesis Client Library (KCL) for analyzing trends, and send notifications using Amazon SNS. Configure Kinesis Data Firehose on the Kinesis data stream to persist data to an S3 bucket.
• D.Publish data to two Kinesis data streams. Deploy Kinesis Data Analytics to the first stream for analyzing trends, and configure an AWS Lambda function as an output to send notifications using Amazon SNS.
  Configure Kinesis Data Firehose on the second Kinesis data stream to persist data to an S3 bucket.

Comment: *

Name: *

Email: *

Verification: *

A large company receives files from external parties in Amazon EC2 throughout the day. At the end of the day, the files are combined into a single file, compressed into a gzip file, and uploaded to Amazon S3. The total size of all the files is close to 100 GB daily. Once the files are uploaded to Amazon S3, an AWS Batch program executes a COPY command to load the files into an Amazon Redshift cluster.
Which program modification will accelerate the COPY process?

• A.Split the number of files so they are equal to a multiple of the number of slices in the Amazon Redshift cluster. Gzip and upload the files to Amazon S3. Run the COPY command on the files.
• B.Split the number of files so they are equal to a multiple of the number of compute nodes in the Amazon Redshift cluster. Gzip and upload the files to Amazon S3. Run the COPY command on the files.
• C.Upload the individual files to Amazon S3 and run the COPY command as soon as the files become available.
• D.Apply sharding by breaking up the files so the distkey columns with the same values go to the same file.
  Gzip and upload the sharded files to Amazon S3. Run the COPY command on the files.

Comment: *

Name: *

Email: *

Verification: *