AWS Database Specialty Practice

Q: How many questions are in this practice set?

This practice set contains 60 questions with detailed explanations.

Q: What topics does this practice cover?

It covers the key topics and question types for AWS Database Specialty, including vocabulary, grammar, reading, and practical test skills.

Q: Are there explanations for every question?

Yes, every question includes a clear explanation so you can understand the correct answer and learn from mistakes.

Q: Can I save my progress and mistakes?

Your wrong answers, favorites, scores, and study streak are saved in your browser, so you can review them on the same device.

Q: What practice modes are available?

You can practice randomly, take a timed mock exam, filter by difficulty, type, and topic, search questions, and review wrong answers.

Practice 60 original AWS Database Specialty questions covering database engines, design, operations, security, performance and migration, with detailed explanations.

Level: AWS Database Specialty Difficulty: advanced 60 questions 60 min

Choose a practice mode, answer each AWS Database Specialty question, then review the explanation. Wrong answers are saved locally for review.

Practice mode Difficulty Topic Question type Search questions

Day streak: 0 days Saved only on this device

Question 1

What is Amazon RDS?

Select an answer A CDNA managed relational database serviceA NoSQL databaseAn object store

Question 2

What is Amazon Aurora?

Select an answer A MySQL and PostgreSQL compatible relational databaseA graph databaseA cacheA data warehouse

Question 3

What is DynamoDB?

Select an answer A cacheA data warehouseA managed NoSQL key-value and document databaseA relational database

Question 4

What is Amazon Redshift?

Select an answer A NoSQL databaseA cacheA graph databaseA petabyte-scale data warehouse

Question 5

What is Amazon ElastiCache?

Select an answer A relational databaseA data warehouseA graph databaseAn in-memory cache service

Question 6

What is Amazon Neptune?

Select an answer A managed graph databaseA relational databaseA cacheA warehouse

Question 7

What is Amazon DocumentDB?

Select an answer A warehouseA MongoDB compatible document databaseA graph databaseA cache

Question 8

What is RDS Multi-AZ?

Select an answer A cacheA backupA high-availability deployment across availability zonesA read replica

Question 9

What is Aurora Serverless?

Select an answer A cacheA warehouseAn on-demand scaling Aurora databaseA fixed-size database

Question 10

Match each database engine to its purpose.

RDSAuroraDynamoDBRedshift

Question 11

What is a primary key?

Select an answer A foreign keyAn indexA backupA unique identifier for a row

Question 12

What is a foreign key?

Select an answer A snapshotA column that links to another table primary keyA unique row identifierA cache

Question 13

What is an index?

Select an answer A structure that speeds up queriesA tableA backupA cache

Question 14

What is partitioning?

Select an answer Encrypting dataCreating reportsSplitting data into smaller segmentsDeleting data

Question 15

What is normalization?

Select an answer Creating cachesReducing data redundancyAdding duplicate dataDeleting tables

Question 16

What is denormalization?

Select an answer Reducing redundancyDeleting indexesEncrypting dataAdding redundancy to improve read performance

Question 17

What is a DynamoDB partition key?

Select an answer A foreign keyAn indexA backupA key that determines data distribution

Question 18

What is a sort key?

Select an answer A snapshotA key that orders items within a partitionA primary keyA cache

Question 19

What is schema design?

Select an answer Defining tables, keys, and relationshipsCreating backupsDeleting dataConfiguring a CDN

Question 20

Match each design concept to its purpose.

Primary keyIndexPartitioningNormalization

Question 21

What is an RDS automated backup?

Select an answer A cacheA read replicaAn automatic backup with point-in-time recoveryA manual snapshot

Question 22

What is a database snapshot?

Select an answer An automated backupA cacheA queryA manual backup of a database

Question 23

What is a maintenance window?

Select an answer A scheduled period for database maintenanceA backupA read replicaA security group

Question 24

What does Multi-AZ failover do?

Select an answer Deletes dataSwitches to a standby instance during failureCreates a read replicaStarts a cache

Question 25

What is a read replica?

Select an answer A cacheA database copy used for read scalingA standby instanceA backup

Question 26

What is point-in-time recovery?

Select an answer Restoring a database to a specific timeDeleting old dataCreating a cacheEncrypting data

Question 27

What is backup retention?

Select an answer A cacheAn indexA security groupHow long backups are kept

Question 28

What is a parameter group?

Select an answer A snapshotA cacheA set of database configuration parametersA backup

Question 29

What is an option group?

Select an answer A set of database feature optionsA backupA cacheAn index

Question 30

Match each operations concept to its purpose.

BackupSnapshotRead replicaMaintenance window

Question 31

What is encryption at rest?

Select an answer Encrypting network trafficA cacheA backupEncrypting stored database files

Question 32

What is encryption in transit?

Select an answer A snapshotAn indexEncrypting data while it movesEncrypting stored files

Question 33

What is IAM database authentication?

Select an answer A backupUsing IAM credentials to access a databaseA database engineA cache

Question 34

What is AWS KMS used for?

Select an answer Managing encryption keysStoring filesFiltering trafficCreating reports

Question 35

What is a security group?

Select an answer A cacheA backupA firewall that controls traffic to a resourceA database

Question 36

Why place databases in a VPC?

Select an answer To increase storageTo disable encryptionTo create reportsTo isolate and protect network access

Question 37

What is AWS Secrets Manager?

Select an answer A firewallA service for storing and rotating secretsA databaseA cache

Question 38

What does TLS/SSL provide for databases?

Select an answer Encrypted client connectionsFaster queriesMore storageBetter indexes

Question 39

What are database audit logs?

Select an answer BackupsCachesIndexesRecords of database activity

Question 40

Match each security concept to its purpose.

IAMKMSSecurity groupSecrets Manager

Question 41

What is query tuning?

Select an answer Improving query execution performanceDeleting tablesCreating backupsConfiguring DNS

Question 42

What is index optimization?

Select an answer Creating cachesBacking up dataAdding or adjusting indexes for faster queriesDeleting tables

Question 43

How do read replicas improve performance?

Select an answer By deleting dataBy creating reportsBy serving read traffic away from the primaryBy encrypting data

Question 44

What is caching?

Select an answer Creating backupsStoring frequently used data for faster accessDeleting dataEncrypting data

Question 45

What is DynamoDB Accelerator?

Select an answer A relational databaseA data warehouseA backupAn in-memory cache for DynamoDB

Question 46

What is database auto scaling?

Select an answer Adjusting capacity based on demandDeleting dataEncrypting dataCreating reports

Question 47

What is Provisioned IOPS?

Select an answer A security groupDedicated input/output capacity for a databaseA cacheA backup

Question 48

What is a query plan?

Select an answer A backupA cacheA reportThe execution plan chosen for a query

Question 49

What is connection pooling?

Select an answer Encrypting dataCreating backupsReusing database connections to reduce overheadDeleting connections

Question 50

Match each performance concept to its purpose.

Read replicaDAXProvisioned IOPSQuery plan

Question 51

What is AWS Database Migration Service?

Select an answer A backupA service for migrating databases to AWSA database engineA cache

Question 52

What is AWS Schema Conversion Tool?

Select an answer A backup serviceA cacheA firewallA tool for converting database schemas

Question 53

What is change data capture?

Select an answer Capturing database changes for replicationDeleting dataEncrypting dataCreating reports

Question 54

What is a replication instance in DMS?

Select an answer A target databaseA cacheAn instance that moves data between databasesA source database

Question 55

What is AWS DataSync?

Select an answer A cacheA backupA service for transferring files and dataA database engine

Question 56

What is schema conversion?

Select an answer Encrypting dataTransforming schema objects to a target engineDeleting schemasCreating backups

Question 57

What is a homogeneous migration?

Select an answer Migration between different enginesA cacheA backupMigration between the same database engine

Question 58

What is a heterogeneous migration?

Select an answer Migration between different database enginesMigration within one engineA cacheA snapshot

Question 59

What is cutover?

Select an answer A cacheThe final switch to the new databaseThe start of migrationA backup

Question 60

Match each migration concept to its purpose.

DMSSCTCDCDataSync