database aws

A customer is ordering a product from an online retailer. If the payment for the transaction is successful, the Orders table must be updated so that a new order row is inserted. The stockTable table must also be updated so that product rows are removed for the purchased products. If one step fails, then all steps fail.

Which type of database transaction property does this scenario represent?

• Atomicity

• Consistency

• Isolation

• Durability

Which type of database is Amazon DynamoDB?

• Centralized database

• NoSQL database

• Relational database

• Personal database

How does Amazon DynamoDB achieve high availability and scalability across Regions?

• By using a collection of multiple replica tables

• By using a collection of multiple items

• By using a collection of multiple partition keys

• By using a collection of one or more attributes

Which statement describes the concept of partitioning in Amazon DynamoDB?

• Partitioning is the allocation of storage for a table.

• Partitioning is used to locate items in a table.

• Partitioning is the manual replication of table across multiple Availability Zones within an AWS Region.

• As data grows, table data is partitioned and indexed by a composite key.

Which statement about Amazon DynamoDB partition keys is true?

• Partition keys uniquely identify each item in the table.

• No two items in a table can use the same partition keys.

• A table can have two partition keys.

• A primary key is composed of two partition keys

How many ways can Amazon DynamoDB retrieve data from a DynamoDB table?

• Four ways

• Two ways

• One way

• Three ways

What is a database?

• A collection of data that is organized into files called columns

• A collection of data that is organized into files called rows

• A collection of data that is organized into tables

• A collection of data that organized into files called datasets.

Which database attributes accurately represent elements of a relational database? (Select TWO.)

• Tables

• Key-value pairs

• Columns

• Horizontal scaling

• Forms

What are the primary features of a NoSQL database? (Select TWO.)

• NoSQL databases use data models that are not based on relational tables

• NoSQL databases work well for customer relation management (CRM) applications or enterprise resource planning (ERP) applications.

• NoSQL databases have a flexible schema.

• NoSQL databases use vertical scaling.

• NoSQL databases can run transactional or analytical queries.

What is a data lake?

• A centralized repository that can store structured and unstructured data

• A database that does not use a table structure to store data

• A database that uses a table structure to store data

• A type of software that provides database functionality