Timedora
Free Practice Quiz Question List

5 Amazon Redshift in Practice Online Quiz Questions

Use this free practice quiz with 20 questions to review 5 Amazon Redshift in Practice, test your knowledge, and prepare for your next test or exam.

20 questions
01
True or false
1 point

A checkout service must update an order and retrieve it immediately. This is an operational workload suited to a transactional database.

  1. A

    True

  2. B

    False

02
Choose one
1 point

A team is choosing a database for a checkout service that frequently updates individual orders and needs low-latency retrieval. Which option is the best fit?

  1. A

    Use Redshift as the primary database because it is optimized for frequent, low-latency order updates.

  2. B

    Use an operational database suited to application transactions.

  3. C

    Use a data warehouse because checkout updates require aggregating large datasets.

03
Fill in the blank
1 point

To bulk-load a CSV from S3 into a Redshift table, use the command with an S3 path and an IAM role.

04
True or false
1 point

In a sales warehouse, a fact table can record sale events, while dimension tables provide descriptive context such as product or date information.

  1. A

    True

  2. B

    False

05
Choose one
1 point

An analyst needs quarterly revenue totals spanning several years of orders. Which database is the likely fit for this analytical task?

  1. A

    Use an operational database because quarterly summaries are individual transaction lookups.

  2. B

    Use DynamoDB because the analyst is retrieving a user profile by a known key.

  3. C

    Use Redshift to analyze quarterly revenue across years of orders.

06
Written response
1 point

For sale_id 1003 in the sample data, what month and year does its sale_date belong to? Enter the answer in YYYY-MM format.

07
Choose all
1 point

Which characteristics of Redshift support analytical queries over large datasets? Select all correct choices.

  1. A

    Massively parallel processing

  2. B

    A design focused on frequent, low-latency updates to individual application records

  3. C

    Columnar storage

  4. D

    Compression to help scan and aggregate data efficiently

08
Fill in the blank
1 point

In a warehouse, fact tables record such as sales, while dimension tables add such as product, customer, or date details.

09
Choose one
1 point

An application must retrieve a user profile by a known key at scale. Which database is a likely fit when the access pattern matches?

  1. A

    Redshift, because broad analytical scans are the same as key-based profile lookups.

  2. B

    DynamoDB, when its key-value access pattern fits the application.

  3. C

    A data warehouse, because it is optimized for frequent low-latency access to one user profile.

10
Choose all
1 point

A team is loading a large CSV from S3 into Redshift. Which statements describe an appropriate approach? Select all correct choices.

  1. A

    Use COPY to load the CSV from its S3 location.

  2. B

    Grant no bucket access to Redshift; an IAM role is unnecessary.

  3. C

    Provide an IAM role that permits access to the S3 bucket.

  4. D

    COPY can load data in parallel and is generally more efficient than inserting a large dataset row by row.

11
Open ended
1 point

A company needs both low-latency checkout updates and reports on revenue across many years of orders. Propose a database design using the appropriate roles for an operational database and Redshift, and explain how the analyst can access the data without placing every large analytical scan on the application’s primary database.

12
Choose one
1 point

Which NoSQL database does the material suggest considering when an application’s key-value access pattern fits?

  1. A

    Amazon Redshift

  2. B

    DynamoDB

  3. C

    Amazon RDS

  4. D

    Amazon Aurora

13
True or false
1 point

True or false: When loading a file from S3 with Redshift's COPY command, the IAM role must permit access to the bucket.

  1. A

    True

  2. B

    False

14
Written response
1 point

In the sales table schema, unit_price is defined as DECIMAL(10, 2). How many digits are allowed after the decimal point?

15
Choose one
1 point

An analyst needs quarterly revenue summaries across years of orders. Which option is the best fit for this analytical workload?

  1. A

    Amazon Redshift

  2. B

    DynamoDB

  3. C

    An operational database optimized for individual transactions

  4. D

    A database chosen only for updating one order at a time

16
Choose one
1 point

You have a large CSV file in S3 and want to load it into the Redshift sales table efficiently. Which approach should you choose?

  1. A

    Insert every CSV row individually with a separate SQL statement

  2. B

    Use SELECT COUNT(*) to import the CSV

  3. C

    Use COPY to load the CSV from S3

  4. D

    Use GROUP BY to load the CSV from S3

17
Choose one
1 point

In the described warehouse design, the sales table records individual sales events, while product and customer tables provide descriptive context. What role does sales have?

  1. A

    The sales table is a dimension table because it contains dates.

  2. B

    The sales table is a fact table because it records sales events.

  3. C

    The sales table is an operational database because its rows are sales.

  4. D

    The sales table is a dimension table because it contains quantities.

18
Written response
1 point

To find how many records were loaded into sales, what SQL expression is used inside SELECT in the example count query?

19
Choose one
1 point

A query selects region and SUM(quantity * unit_price) AS revenue, then groups by region. What does the query report?

  1. A

    It returns one row for each sale, with quantity and unit price unchanged.

  2. B

    It returns total revenue for each region.

  3. C

    It returns the number of sales in each region.

  4. D

    It returns monthly revenue for each product.

20
Written response
1 point

In the monthly-by-product query, each result row corresponds to a grouping of which two selected fields? Enter both field names joined by and.