Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 242 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 242
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is using Amazon Redshift as its data warehouse solution. The Redshift cluster handles the following types of workloads:
✑ Real-time inserts through Amazon Kinesis Data Firehose
✑ Bulk inserts through COPY commands from Amazon S3
✑ Analytics through SQL queries
Recently, the cluster has started to experience performance issues.
Which combination of actions should a database specialist take to improve the cluster's performance? (Choose three.)

A. Modify the Kinesis Data Firehose delivery stream to stream the data to Amazon S3 with a high buffer size and to load the data into Amazon Redshift by using the COPY command.
B. Stream real-time data into Redshift temporary tables before loading the data into permanent tables.
C. For bulk inserts, split input files on Amazon S3 into multiple files to match the number of slices on Amazon Redshift. Then use the COPY command to load data into Amazon Redshift.
D. For bulk inserts, use the parallel parameter in the COPY command to enable multi-threading.
E. Optimize analytics SQL queries to use sort keys.
F. Avoid using temporary tables in analytics SQL queries.

Show Suggested Answer

Suggested Answer: BCE 🗳️

by mbar94 at Sept. 7, 2022, 11:19 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

snehilsrcs

Highly Voted 2 years, 8 months ago

Selected Answer: BCE

https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/ Tip #6: Improving the efficiency of temporary tables Tip #9: Maintaining efficient data loads Amazon Redshift best practices suggest using the COPY command to perform data loads of file-based data. Tip #3: Sort key recommendation Sorting a table on an appropriate sort key can accelerate query performance, especially queries with range-restricted predicates, by requiring fewer table blocks to be read from disk. Hence BCE

upvoted 7 times

...

MultiAZ

Most Recent 1 year, 6 months ago

Selected Answer: ACE

ACE No question about C and E For A vs B... Using B may result in data loss. Temporary tables are better fit for storing temporary results.

upvoted 1 times

...

Sathish_dbs

2 years, 6 months ago

there is no mention how temp table is used here to conclude it optimises or not..

upvoted 1 times

...

awsjjj

2 years, 8 months ago

Selected Answer: BCE

https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/

upvoted 2 times

...

Changwha

2 years, 9 months ago

Selected Answer: BCE

Ax: Kinesis Data Firehose is a fully managed service that automatically scales to match the throughput of your data and requires no ongoing administration. B: The proper use of temporary tables can significantly improve performance of some ETL operations.

upvoted 4 times

...

JeanGat

2 years, 9 months ago

C for sure - from Tip #9 here. https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/

upvoted 2 times

...

zoomac

2 years, 9 months ago

A is wrong because "Note that in circumstances where data delivery to the destination is falling behind data ingestion into the delivery stream, Kinesis Data Firehose raises the buffer size automatically to catch up and make sure that all data is delivered to the destination." Reference: https://aws.amazon.com/kinesis/data-firehose/faqs/

upvoted 2 times

...

SonamDhingra

2 years, 10 months ago

Selected Answer: ACE

ACE is correct

upvoted 2 times

...

mbar94

2 years, 10 months ago

Selected Answer: ACE

It's ACE.

upvoted 1 times

...