AWS Data Analytics Certification

Why not prepare for Amazon’s AWS Data Analytics – Specialty certification with these questions & test your knowledge of Amazon Redshift?

Find questions on the following topic(s) –

0 votes, 0 avg
Created on By adminadmin

AWS Certification

AWS Data Analytics – Quiz 3: Redshift

1 / 6

QUESTION

Which of the following are true regarding data merge (‘upsert’) operations and Amazon Redshift?

(Select Two)

2 / 6

QUESTION

You have created two tables on Redshift which will be used to support data analysis and will be frequently accessed, holding a 1-2GB data set. Often, analytics queries will require joins on these tables. Which  style would ensure the appropriate data distribution for these tables?

 

3 / 6

QUESTION

Which of the following are true regarding loading of data into Redshift from DynamoDB?

(Select Two)

4 / 6

QUESTION

At the end of the month, data analyst teams run end of month reporting and ad hoc analysis  consisting long, complex queries, creating a spike in read usage. Queries are running slowly. Automatic  Workload Management (WLM) and Short Queue Acceleration (SQA) are in place but have not fixed the problem.

Which of the following are the most cost effective and least disruptive means of scaling to meet demand?

(Select Two)

5 / 6

QUESTION

The data analysis team wish to create new insights on data currently located in S3, Amazon Aurora and Redshift, to be published in a new Business Intelligence application. Which of the following is the most straight-forward solution?

6 / 6

QUESTION

Which of the following are best practice when loading data to Redshift?

Your score is

The average score is 30%

0%

No responses yet

    Leave a Reply

    Your email address will not be published. Required fields are marked *