DynamoDBquery~30 mins

First table creation in DynamoDB - Mini Project: Build & Apply

Choose your learning style10 modes available

Learn Why Deep Visual Try Challenge Project Recall Time

Start learning this pattern below

Jump into concepts and practice - no test required

Recommended

Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong

Create Your First DynamoDB Table

📖 Scenario: You are setting up a simple database table to store information about books in a library. Each book has a unique ID and a title.

🎯 Goal: Create a DynamoDB table named Books with a primary key called BookID of type string.

📋 What You'll Learn

Create a table named Books

Use BookID as the partition key

Set the partition key type to S (string)

Set the read and write capacity units to 5

💡 Why This Matters

🌍 Real World

Creating DynamoDB tables is a common task when setting up cloud databases for applications like online stores, mobile apps, or IoT devices.

💼 Career

Knowing how to create and configure DynamoDB tables is essential for cloud developers, database administrators, and backend engineers working with AWS.

Progress0 / 4 steps

Define the table name and key schema

Create a variable called table_name and set it to 'Books'. Then create a variable called key_schema that defines the partition key with AttributeName as 'BookID' and KeyType as 'HASH'.

DynamoDB

# Your code here

Hint

Remember, the partition key is called BookID and its key type is HASH.

Define the attribute definitions and provisioned throughput

Create a variable called attribute_definitions that defines BookID as type 'S'. Then create a variable called provisioned_throughput with ReadCapacityUnits and WriteCapacityUnits both set to 5.

DynamoDB

table_name = 'Books'
key_schema = [{
    'AttributeName': 'BookID',
    'KeyType': 'HASH'
}]
# Your code here

Hint

Attribute type 'S' means string. Set both read and write capacity units to 5.

Create the table creation parameters dictionary

Create a variable called table_params that combines table_name, key_schema, attribute_definitions, and provisioned_throughput into one dictionary with keys TableName, KeySchema, AttributeDefinitions, and ProvisionedThroughput respectively.

DynamoDB

table_name = 'Books'
key_schema = [{
    'AttributeName': 'BookID',
    'KeyType': 'HASH'
}]
attribute_definitions = [{
    'AttributeName': 'BookID',
    'AttributeType': 'S'
}]
provisioned_throughput = {
    'ReadCapacityUnits': 5,
    'WriteCapacityUnits': 5
}
# Your code here

Hint

Combine all parts into one dictionary called table_params.

Add the final command to create the DynamoDB table

Create a variable called dynamodb_client that represents the DynamoDB client. Then create a variable called create_table_response that calls dynamodb_client.create_table() with table_params as the argument.

DynamoDB

table_name = 'Books'
key_schema = [{
    'AttributeName': 'BookID',
    'KeyType': 'HASH'
}]
attribute_definitions = [{
    'AttributeName': 'BookID',
    'AttributeType': 'S'
}]
provisioned_throughput = {
    'ReadCapacityUnits': 5,
    'WriteCapacityUnits': 5
}
table_params = {
    'TableName': table_name,
    'KeySchema': key_schema,
    'AttributeDefinitions': attribute_definitions,
    'ProvisionedThroughput': provisioned_throughput
}
# Your code here

Hint

Use boto3.client('dynamodb') to create the client and call create_table() with the parameters.

Practice

(1/5)

1. What is the minimum required element when creating a DynamoDB table?

easy

A. Table name and global secondary index

B. Table name and secondary index

C. Table name and primary key

D. Provisioned throughput only

5. You want to create a DynamoDB table named Employees with a composite primary key: EmployeeId (string) as partition key and Department (string) as sort key. Which command correctly creates this table?

hard

A. aws dynamodb create-table --table-name Employees --attribute-definitions AttributeName=EmployeeId,AttributeType=S AttributeName=Department,AttributeType=S --key-schema AttributeName=EmployeeId,KeyType=HASH AttributeName=Department,KeyType=RANGE --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5

B. aws dynamodb create-table --table-name Employees --attribute-definitions EmployeeId=S Department=S --key-schema EmployeeId=HASH Department=RANGE --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5

C. aws dynamodb create-table --table Employees --attributes EmployeeId:string Department:string --keys EmployeeId:partition Department:sort --throughput 5 5

D. aws dynamodb create-table --table-name Employees --attribute-definitions AttributeName=EmployeeId,AttributeType=S --key-schema AttributeName=EmployeeId,KeyType=HASH --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5

First table creation in DynamoDB - Mini Project: Build & Apply

Start learning this pattern below

Practice

Solution

Step 1: Understand DynamoDB table basics

Step 2: Identify required elements for creation

Final Answer:

Quick Check:

Solution

Step 1: Check AWS CLI syntax for create-table

Step 2: Verify option correctness

Final Answer:

Quick Check:

Solution

Step 1: Identify attribute type in attribute-definitions

Step 2: Confirm key schema uses ProductId as HASH key

Final Answer:

Quick Check:

Solution

Step 1: Check attribute-definitions syntax

Step 2: Verify other parts

Final Answer:

Quick Check:

Solution

Step 1: Define attribute-definitions for both keys

Step 2: Define key-schema with HASH and RANGE keys

Step 3: Check command syntax

Final Answer:

Quick Check: