AWS

AWS Interview Questions and Answer Part – 16

January 15, 2020 comments off

Elastic Block Storage is limited in size and won’t auto scale with your storage needs.

  • False
  • True (Ans)

Compared to a relational database’s data model…

  • A DynamoDB attribute is like a row, and item is like a column
  • None of these
  • A DynamoDB key is like a column, and item is like a row
  • A DynamoDB attribute is like a column, and item is like a row (Ans)

A local secondary index can be created at any time, unlike a global secondary index.

  • True
  • False (Ans)

You cannot use an Amazon-provided license for an Oracle Enterprise Edition.

  • False
  • True (Ans)

What is an example of a native capability of DynamoDB?

  • All of these (Ans)
  • SSD storage
  • Multiple data consistency options
  • Built-in data replication

What question does NOT factor into your decisions when creating a new RDS instance?

  • Number of manual snapshots you will take (Ans)
  • Region to create the database in
  • How much storage you need
  • Which database engine to use

Redshift customers have to pay data transfer costs when loading the warehouse.

  • False (Ans)
  • True

Why should a read replica use the same (or better) instance class as the source database?

  • None of these
  • Because instance size is immutable and can’t be changed later
  • To avoid falling behind on synchronization (Ans)
  • Because RDS requires it when configuring a read replica

Why should you use multiple files in S3 to import data?

  • So Redshift can allocate the biggest files to the largest nodes
  • Get better throughput by putting all the node slices to work (Ans)
  • All of these
  • The cost of importing data goes down

Why would you add a read replica to an RDS database?

  • Have an alternate database to insert records
  • Scale performance of a high traffic database (Ans)
  • Establish an automatic failover database in case of AZ outage

Which of the following are native Redshift capabilities?

  • Up to petabytes of storage
  • Encryption at rest
  • Parallel query processing
  • All of these (Ans)

Both query and scan requests support parallel execution via segments.

  • False (Ans)
  • True

What is the name of the setting that controls placement of data among the nodes?

  • Sort key
  • Primary key
  • Data distribution key (Ans)
  • Index key

What happens when you ask for an attribute that wasn’t projected into a local secondary index?

  • DynamoDB throws an exception
  • The data is retrieved from the source table (Ans)
  • Empty data is returned
  • DynamoDB copies the data into the index and then returns it

Which of the following are supported RDS database engines?

  • MySQL
  • All of these (Ans)
  • Microsoft SQL Server
  • Oracle

Which command lets you validate data without actually importing it?

  • VALIDATE
  • SKIP
  • STAGE
  • NOLOAD (Ans)

Read replicas cannot be promoted to standalone RDS database instances.

  • True
  • False (Ans)

Which of the following databases is based on PostgreSQL?

  • Amazon DynamoDB
  • Amazon RDS
  • All of these
  • Amazon Redshift (Ans)

Throughput units are set during table creation time and cannot be changed.

  • True
  • False (Ans)

How does DynamoDB decide on the number of partitions to create for your table?

  • Based on the “partition count” parameter set during table creation
  • Based on throughput units chosen
  • Based on data storage
  • Based on data storage or throughput units chosen (Ans)
Rajesh Kumar
Follow me
Latest posts by Rajesh Kumar (see all)