CA Foundation Business Economics Questions 2023 - Part 32
Fri, 03 Mar 2023
Inspirational journeys
Follow the stories of academics and their research expeditions
AWS Certified Data Analytics - Specialty - Part 1
4. 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 separateCOPY 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) Use Amazon EMR to copy all the data files into one folder and issue a COPY command to load the data into Amazon Redshift.
B) Load all the data files in parallel to Amazon Aurora, and run an AWS Glue job to load the data into Amazon Redshift.
C) 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.
D) Create a manifest file that contains the data file locations and issue a COPY command to load the data into Amazon Redshift.
5. A company's marketing team has asked for help in identifying a high performing long-term storage service for their data based on the following requirements:' The data size is approximately 32 TB uncompressed.' There is a low volume of single-row inserts each day.' There is a high volume of aggregation queries each day.' Multiple complex joins are performed.' The queries typically involve a small subset of the columns in a table.Which storage service will provide the MOST performant solution?
A) Amazon Aurora MySQL
B) Amazon Redshift
C) Amazon Neptune
D) Amazon Elasticsearch
A) Use Amazon EMR to copy all the data files into one folder and issue a COPY command to load the data into Amazon Redshift.
B) Load all the data files in parallel to Amazon Aurora, and run an AWS Glue job to load the data into Amazon Redshift.
C) 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.
D) Create a manifest file that contains the data file locations and issue a COPY command to load the data into Amazon Redshift.
5. A company's marketing team has asked for help in identifying a high performing long-term storage service for their data based on the following requirements:' The data size is approximately 32 TB uncompressed.' There is a low volume of single-row inserts each day.' There is a high volume of aggregation queries each day.' Multiple complex joins are performed.' The queries typically involve a small subset of the columns in a table.Which storage service will provide the MOST performant solution?
A) Amazon Aurora MySQL
B) Amazon Redshift
C) Amazon Neptune
D) Amazon Elasticsearch
4. Right Answer: D
Explanation: You can use a manifest to ensure that the COPY command loads all of the required files, and only the required files, for a data loadReferencehttps://docs.aws.amazon.com/redshift/latest/dg/loading-data-files-using-manifest.html
5. Right Answer: B
Explanation:
Explanation: You can use a manifest to ensure that the COPY command loads all of the required files, and only the required files, for a data loadReferencehttps://docs.aws.amazon.com/redshift/latest/dg/loading-data-files-using-manifest.html
5. Right Answer: B
Explanation:
Tags:
aws cloud awc cloud cerification certified aws aws certifications aws cloud practitioner aws solution architect aws training aws certified cloud practitioner aws exam aws certification exam aws practice exams aws 2023 aws updated questions aws questions aws cert aws certified solutions architect aws solution architect associate aws training and certification aws certified developer associate certification for devops0 Comments
Categories
Recent posts
CA Foundation Business Economics Questions 2023 - Part 31
Fri, 03 Mar 2023
CA Foundation Business Economics Questions 2023 - Part 30
Fri, 03 Mar 2023
Leave a comment