Amazon EBS provides persistent block storage volumes for use with Amazon EC2 instances.
Incorrect! Try again.
2Which AWS service commonly uses Amazon EBS volumes?
Amazon Elastic Block Store (EBS)
Easy
A.Amazon EC2
B.Amazon Route 53
C.Amazon CloudFront
D.Amazon SQS
Correct Answer: Amazon EC2
Explanation:
EBS volumes can be attached to Amazon EC2 instances to provide storage for operating systems, applications, and data.
Incorrect! Try again.
3What type of storage is Amazon S3?
Amazon S3
Easy
A.Relational storage
B.Object storage
C.Block storage
D.In-memory storage
Correct Answer: Object storage
Explanation:
Amazon S3 stores data as objects inside containers called buckets.
Incorrect! Try again.
4What is the main container used to organize objects in Amazon S3?
Amazon S3
Easy
A.Volume
B.Table
C.Cluster
D.Bucket
Correct Answer: Bucket
Explanation:
An S3 bucket is a container that stores objects such as files and metadata.
Incorrect! Try again.
5Which feature helps protect Amazon S3 data from accidental deletion or overwriting?
Amazon S3
Easy
A.Compaction
B.Versioning
C.Sharding
D.Replication only
Correct Answer: Versioning
Explanation:
S3 Versioning keeps multiple versions of an object, helping recover data after accidental changes.
Incorrect! Try again.
6What type of storage does Amazon EFS provide?
Amazon EFS
Easy
A.Block storage
B.Object storage
C.Tape storage
D.File storage
Correct Answer: File storage
Explanation:
Amazon EFS is a managed file system that provides shared file storage.
Incorrect! Try again.
7What is a key characteristic of Amazon EFS?
Amazon EFS
Easy
A.It works only with one instance
B.It can be shared by multiple instances
C.It stores only database indexes
D.It is designed only for archives
Correct Answer: It can be shared by multiple instances
Explanation:
Amazon EFS allows multiple compute resources to access the same file system at the same time.
Incorrect! Try again.
8What is the primary purpose of Amazon S3 Glacier?
Amazon S3 Glacier
Easy
A.Long-term data archiving
B.Web application hosting
C.Virtual machine networking
D.Real-time data processing
Correct Answer: Long-term data archiving
Explanation:
Amazon S3 Glacier is designed for low-cost storage of data that is accessed infrequently.
Incorrect! Try again.
9Compared with frequently accessed S3 storage, Glacier storage generally has what characteristic?
Amazon S3 Glacier
Easy
A.Built-in application hosting
B.Faster database queries
C.Higher memory capacity
D.Lower storage cost
Correct Answer: Lower storage cost
Explanation:
S3 Glacier offers lower-cost storage for archival data, usually with slower retrieval than active storage classes.
Incorrect! Try again.
10Which storage type is usually suitable for a shared directory accessed by several servers?
Storage technology selection
Easy
A.Block storage
B.File storage
C.Object storage
D.Cache storage
Correct Answer: File storage
Explanation:
File storage is organized into files and directories and is suitable for shared file access.
Incorrect! Try again.
11Which storage type is commonly used for backups, images, and other unstructured files?
Storage technology selection
Easy
A.Temporary storage
B.Block storage
C.Register storage
D.Object storage
Correct Answer: Object storage
Explanation:
Object storage is well suited to scalable storage of unstructured data such as images, videos, and backups.
Incorrect! Try again.
12Which storage type is most closely associated with a disk volume attached to a virtual machine?
Storage technology selection
Easy
A.Block storage
B.File storage
C.Object storage
D.Archive storage
Correct Answer: Block storage
Explanation:
Block storage presents data as blocks and is commonly used as a virtual disk for a virtual machine.
Incorrect! Try again.
13What does Amazon RDS primarily provide?
Amazon RDS
Easy
A.Object storage buckets
B.Managed file shares
C.Managed relational databases
D.Content delivery networks
Correct Answer: Managed relational databases
Explanation:
Amazon RDS makes it easier to set up, operate, and scale supported relational database engines.
Incorrect! Try again.
14Which language is commonly used to query relational databases managed by Amazon RDS?
Amazon RDS
Easy
A.HTML
B.CSS
C.SMTP
D.SQL
Correct Answer: SQL
Explanation:
Relational databases use SQL, or Structured Query Language, to manage and query structured data.
Incorrect! Try again.
15What type of database service is Amazon DynamoDB?
Amazon DynamoDB
Easy
A.File system database
B.NoSQL database
C.Relational database
D.Graphical database
Correct Answer: NoSQL database
Explanation:
Amazon DynamoDB is a managed NoSQL database service designed for fast and flexible performance.
Incorrect! Try again.
16Which data model is supported by Amazon DynamoDB?
Amazon DynamoDB
Easy
A.Video frame-only
B.Key-value
C.Spreadsheet-only
D.Hierarchical file-only
Correct Answer: Key-value
Explanation:
DynamoDB supports key-value and document data models.
Incorrect! Try again.
17What is Amazon Redshift mainly designed for?
Amazon Redshift
Easy
A.Data warehousing
B.Message queuing
C.File synchronization
D.DNS management
Correct Answer: Data warehousing
Explanation:
Amazon Redshift is a cloud data warehouse used to analyze large amounts of structured data.
Incorrect! Try again.
18Which type of workload is Amazon Redshift designed to support?
Amazon Redshift
Easy
A.Static file mounting
B.Analytical queries
C.Email delivery
D.Operating system booting
Correct Answer: Analytical queries
Explanation:
Redshift is optimized for analytical workloads that scan and summarize large datasets.
Incorrect! Try again.
19What kind of database is Amazon Aurora?
Amazon Aurora
Easy
A.File-based database
B.Key-value database
C.Caching database
D.Relational database
Correct Answer: Relational database
Explanation:
Amazon Aurora is a managed relational database engine compatible with MySQL and PostgreSQL.
Incorrect! Try again.
20Which database engines are compatible with Amazon Aurora?
Amazon Aurora
Easy
A.DynamoDB and Cassandra
B.Oracle and SQLite
C.MongoDB and Redis
D.MySQL and PostgreSQL
Correct Answer: MySQL and PostgreSQL
Explanation:
Aurora is compatible with MySQL and PostgreSQL, allowing applications to use familiar relational database tools and features.
Incorrect! Try again.
21An EC2-hosted database requires persistent block storage with consistently high IOPS and low latency. Which EBS volume type is the most appropriate?
Amazon Elastic Block Store (EBS)
Medium
A.Provisioned IOPS SSD
B.Throughput Optimized HDD
C.Cold HDD
D.General Purpose SSD
Correct Answer: Provisioned IOPS SSD
Explanation:
Provisioned IOPS SSD volumes are designed for I/O-intensive workloads that require sustained IOPS performance and low latency.
Incorrect! Try again.
22A team must create a new EBS volume in another AWS Region using the data from an existing volume. What should the team do?
Amazon Elastic Block Store (EBS)
Medium
A.Detach the volume and change its Region
B.Mount the volume through an S3 endpoint
C.Copy its snapshot to the target Region
D.Enable cross-Region access on the volume
Correct Answer: Copy its snapshot to the target Region
Explanation:
EBS volumes are Regional resources within an Availability Zone. Copying an EBS snapshot to another Region allows a new volume to be created there.
Incorrect! Try again.
23A company hosts documents in an S3 bucket and wants every uploaded object encrypted automatically without requiring uploaders to specify encryption headers. Which configuration should it use?
Amazon S3
Medium
A.S3 Transfer Acceleration
B.S3 Versioning
C.S3 default encryption
D.S3 Object Lock
Correct Answer: S3 default encryption
Explanation:
S3 default encryption automatically applies the selected server-side encryption method to new objects when no encryption setting is provided in the upload request.
Incorrect! Try again.
24Users frequently overwrite the same configuration file in Amazon S3. The operations team must be able to recover an earlier copy after an accidental overwrite. Which feature directly supports this requirement?
Amazon S3
Medium
A.S3 Replication
B.S3 Versioning
C.S3 Access Points
D.S3 Inventory
Correct Answer: S3 Versioning
Explanation:
S3 Versioning retains multiple versions of an object, allowing an earlier version to be restored after an overwrite or deletion.
Incorrect! Try again.
25An application generates large media files in an S3 bucket. Files older than 30 days are rarely accessed, and files older than 365 days may be deleted. Which solution requires the least operational effort?
Amazon S3
Medium
A.Enable S3 Transfer Acceleration
B.Create an S3 event for each download
C.Schedule an EC2 file-management script
D.Configure an S3 Lifecycle rule
Correct Answer: Configure an S3 Lifecycle rule
Explanation:
S3 Lifecycle rules can automatically transition objects to lower-cost storage classes and expire them according to their age.
Incorrect! Try again.
26Several Linux EC2 instances in different Availability Zones must concurrently access the same files through a standard file-system interface. Which service best meets this requirement?
Amazon EFS
Medium
A.Amazon Redshift
B.Amazon EFS
C.Amazon EBS
D.Amazon S3
Correct Answer: Amazon EFS
Explanation:
Amazon EFS provides a managed NFS file system that can be mounted concurrently by multiple Linux instances across Availability Zones.
Incorrect! Try again.
27An EFS file system stores project data that is actively used for one week and then accessed only a few times per year. Which feature can automatically reduce storage cost as access patterns change?
Amazon EFS
Medium
A.EFS Provisioned Throughput
B.EFS Lifecycle Management
C.EFS replication overwrite
D.EFS mount target rotation
Correct Answer: EFS Lifecycle Management
Explanation:
EFS Lifecycle Management can move infrequently accessed files into lower-cost EFS storage classes based on access patterns.
Incorrect! Try again.
28A company archives compliance records that are almost never retrieved. When retrieval is required, waiting up to 12 hours is acceptable, and minimizing storage cost is the priority. Which storage class is most suitable?
Amazon S3 Glacier
Medium
A.S3 Standard-Infrequent Access
B.S3 Glacier Instant Retrieval
C.S3 Glacier Flexible Retrieval
D.S3 Glacier Deep Archive
Correct Answer: S3 Glacier Deep Archive
Explanation:
S3 Glacier Deep Archive offers very low-cost long-term archival storage when retrieval times measured in hours are acceptable.
Incorrect! Try again.
29An archive stored in S3 Glacier Flexible Retrieval is needed for an urgent audit within several minutes. Which retrieval option should be requested?
Amazon S3 Glacier
Medium
A.Standard retrieval
B.Bulk retrieval
C.Lifecycle retrieval
D.Expedited retrieval
Correct Answer: Expedited retrieval
Explanation:
Expedited retrieval is intended for urgent access to eligible S3 Glacier Flexible Retrieval objects and typically completes within minutes.
Incorrect! Try again.
30A workload running on one EC2 instance needs a bootable, low-latency storage device that supports in-place updates to database files. Which storage technology should be selected?
Storage technology selection
Medium
A.S3 Glacier Deep Archive
B.Amazon S3
C.Amazon EFS
D.Amazon EBS
Correct Answer: Amazon EBS
Explanation:
Amazon EBS provides persistent block storage suitable for EC2 boot volumes and workloads that perform low-latency, in-place file updates.
Incorrect! Try again.
31A web application must store millions of user-uploaded images, serve them through HTTP, and scale without managing file servers. Which storage technology is the best fit?
Storage technology selection
Medium
A.Amazon EBS
B.Amazon RDS
C.Amazon S3
D.Amazon EFS
Correct Answer: Amazon S3
Explanation:
Amazon S3 is scalable object storage designed for large collections of files that can be accessed through HTTP-based APIs.
Incorrect! Try again.
32A production RDS database must remain available if its primary Availability Zone fails. The application does not need to direct read traffic to the standby instance. Which configuration should be used?
Amazon RDS
Medium
A.A Multi-AZ deployment
B.A cross-Region read replica
C.A larger database instance
D.A manual database snapshot
Correct Answer: A Multi-AZ deployment
Explanation:
An RDS Multi-AZ deployment maintains a synchronous standby in another Availability Zone and supports automatic failover.
Incorrect! Try again.
33An RDS database is handling too many read-only reporting queries, but its write workload is moderate. Which change can reduce the read load on the primary database?
Amazon RDS
Medium
A.Increase the backup window
B.Create additional snapshots
C.Enable a Multi-AZ standby
D.Create an RDS read replica
Correct Answer: Create an RDS read replica
Explanation:
A read replica can serve read-only queries, allowing reporting traffic to be moved away from the primary database.
Incorrect! Try again.
34A DynamoDB table uses CustomerId as its partition key. The application must efficiently query orders by OrderStatus, which is not part of the table's primary key. What should be added?
Amazon DynamoDB
Medium
A.A write-capacity alarm
B.A local table backup
C.A DynamoDB transaction
D.A global secondary index
Correct Answer: A global secondary index
Explanation:
A global secondary index provides an alternative partition key and optional sort key, enabling efficient queries on attributes outside the base table's primary key.
Incorrect! Try again.
35A new application has unpredictable DynamoDB traffic with occasional sharp spikes and long idle periods. The team wants to avoid capacity planning. Which capacity mode should it choose?
Amazon DynamoDB
Medium
A.Reserved capacity
B.Dedicated capacity
C.Provisioned capacity
D.On-demand capacity
Correct Answer: On-demand capacity
Explanation:
On-demand capacity automatically accommodates changing request volumes and charges per request, making it suitable for unpredictable traffic.
Incorrect! Try again.
36A company needs to run complex SQL aggregations across several terabytes of historical sales data for business intelligence dashboards. Which AWS service is most appropriate?
Amazon Redshift
Medium
A.Amazon EFS
B.Amazon Redshift
C.Amazon ElastiCache
D.Amazon DynamoDB
Correct Answer: Amazon Redshift
Explanation:
Amazon Redshift is a columnar data warehouse optimized for analytical SQL queries over large datasets.
Incorrect! Try again.
37A Redshift table is frequently joined with a large fact table using customer_id. Which design choice can reduce data movement during these joins?
Amazon Redshift
Medium
A.Export both tables to EBS
B.Use compatible distribution keys
C.Use different sort key columns
D.Store each table in one row
Correct Answer: Use compatible distribution keys
Explanation:
Distributing related rows using compatible keys can colocate join data on the same compute nodes, reducing network redistribution.
Incorrect! Try again.
38An Aurora cluster experiences heavy read traffic while writes remain stable. Which architecture best improves read scalability?
Amazon Aurora
Medium
A.Add Aurora Replicas
B.Add EBS volumes
C.Increase snapshot frequency
D.Enable S3 Versioning
Correct Answer: Add Aurora Replicas
Explanation:
Aurora Replicas share the cluster's distributed storage and can serve read traffic through the reader endpoint.
Incorrect! Try again.
39A global application uses Aurora and requires low-latency reads in several AWS Regions while keeping one primary write Region. Which feature should be used?
Amazon Aurora
Medium
A.Amazon Aurora Global Database
B.Amazon DynamoDB Streams
C.Amazon Redshift Spectrum
D.Amazon RDS Multi-AZ
Correct Answer: Amazon Aurora Global Database
Explanation:
Aurora Global Database replicates an Aurora cluster across Regions, providing low-latency local reads while retaining a primary write Region.
Incorrect! Try again.
40An application connects to an Aurora cluster using its cluster endpoint. After the writer instance fails, what is the main advantage of continuing to use this endpoint?
Amazon Aurora
Medium
A.It restores the failed instance immediately
B.It redirects writes to the new writer
C.It sends writes to every replica
D.It converts write requests into reads
Correct Answer: It redirects writes to the new writer
Explanation:
The Aurora cluster endpoint follows the current writer instance, so applications can reconnect after failover without tracking a new instance address.
Incorrect! Try again.
41A latency-sensitive database runs on an EC2 instance and requires 80,000 IOPS with consistent sub-millisecond storage latency. Its I/O pattern uses 16 KiB operations. Which EBS volume type is the most appropriate?
io2 Block Express is designed for the highest EBS IOPS, throughput, durability, and consistent low latency. gp3 cannot provide 80,000 IOPS on one volume.
Incorrect! Try again.
42An application takes nightly EBS snapshots. A 1 TiB volume contains 400 GiB of data before the first snapshot. Before the second snapshot, 25 GiB of blocks are modified and 10 GiB of files are deleted without overwriting their blocks. Approximately how much new snapshot data is stored by the second snapshot, ignoring compression and internal metadata?
Amazon Elastic Block Store (EBS)
Hard
A.Approximately 400 GiB
B.Approximately 35 GiB
C.Approximately 25 GiB
D.Approximately 390 GiB
Correct Answer: Approximately 25 GiB
Explanation:
EBS snapshots are incremental after the first snapshot and store newly changed blocks. File deletion generally changes only filesystem metadata; it does not cause every deleted file block to be copied into the next snapshot.
Incorrect! Try again.
43A team creates an EBS volume from a snapshot and immediately runs a full-volume latency benchmark. Initial reads are slower than expected, although the volume type is correctly provisioned. Which action best addresses this behavior before production traffic begins?
Amazon Elastic Block Store (EBS)
Hard
A.Enable EBS Multi-Attach on the volume
B.Convert the filesystem to use larger blocks
C.Read every block to initialize the restored volume
D.Create an AMI from the attached volume
Correct Answer: Read every block to initialize the restored volume
Explanation:
Blocks restored from a snapshot may incur a first-read penalty because they are fetched from snapshot storage. Reading all blocks initializes the volume; Fast Snapshot Restore is an alternative when enabled in advance.
Incorrect! Try again.
44A versioned S3 bucket replicates objects to another Region. An administrator deletes an object without specifying a version ID, creating a delete marker. Which statement best describes standard S3 replication behavior when delete-marker replication has not been enabled?
Amazon S3
Hard
A.Every replicated destination version is permanently deleted
B.The delete marker is not replicated to the destination
C.The destination bucket is suspended until the object returns
D.Only the latest destination version is permanently deleted
Correct Answer: The delete marker is not replicated to the destination
Explanation:
When delete-marker replication is not enabled, a delete marker created by an unversioned delete request is not copied to the destination. Existing replicated object versions remain available there.
Incorrect! Try again.
45A company must prevent every principal, including the root user of its AWS account, from deleting compliance records for seven years. Records may be replaced by newer versions, but each protected version must remain immutable for its retention period. Which configuration satisfies the requirement?
Amazon S3
Hard
A.An S3 lifecycle rule with noncurrent version retention
B.S3 Object Lock in Compliance mode with versioning
D.S3 Object Lock in Governance mode with versioning
Correct Answer: S3 Object Lock in Compliance mode with versioning
Explanation:
Compliance mode prevents a protected object version from being overwritten or deleted by any user, including the account root user, until its retention period expires. Object Lock also requires versioning.
Incorrect! Try again.
46A data pipeline uploads a 120 GiB object with S3 multipart upload but crashes before completing it. No lifecycle policy addresses incomplete uploads. Which outcome is expected?
Amazon S3
Hard
A.Uploaded parts transition automatically to S3 Glacier Flexible Retrieval
B.Uploaded parts continue incurring storage charges until removed
C.Uploaded parts are automatically deleted when the session expires
D.Uploaded parts become a readable object after twenty-four hours
Correct Answer: Uploaded parts continue incurring storage charges until removed
Explanation:
Incomplete multipart-upload parts are not exposed as an object, but their storage is billable. The upload must be completed or aborted, commonly through an abort-incomplete-multipart-upload lifecycle rule.
Incorrect! Try again.
47Hundreds of Linux EC2 instances across multiple Availability Zones need concurrent access to one shared POSIX filesystem. The workload occasionally bursts to very high throughput and can tolerate slightly higher metadata-operation latency. Which EFS performance mode is most suitable?
Amazon EFS
Hard
A.Max I/O performance mode
B.General Purpose performance mode
C.One Zone archive performance mode
D.Provisioned IOPS performance mode
Correct Answer: Max I/O performance mode
Explanation:
Max I/O is intended for highly parallel workloads that need greater aggregate throughput and operations per second, at the cost of somewhat higher latency than General Purpose mode.
Incorrect! Try again.
48An application mounts EFS from EC2 instances in three Availability Zones. Each instance currently connects through a mount target in a different Availability Zone, causing unnecessary cross-AZ traffic. What is the best correction?
Amazon EFS
Hard
A.Attach the EFS filesystem to each instance as a block device
B.Replace mount targets with an internet-facing Network Load Balancer
C.Create and use an EFS mount target in each client Availability Zone
D.Replicate the filesystem into one independent EFS per instance
Correct Answer: Create and use an EFS mount target in each client Availability Zone
Explanation:
Clients should normally use a mount target in their own Availability Zone. This avoids unnecessary cross-AZ routing, reduces latency, and avoids related cross-AZ data transfer.
Incorrect! Try again.
49An organization archives records that are almost never accessed. A rare legal request may require an object to become available in milliseconds rather than through a restore job. Which storage class is appropriate?
Amazon S3 Glacier
Hard
A.S3 Glacier Instant Retrieval
B.S3 Glacier Flexible Retrieval
C.S3 One Zone-Infrequent Access
D.S3 Glacier Deep Archive
Correct Answer: S3 Glacier Instant Retrieval
Explanation:
S3 Glacier Instant Retrieval provides millisecond object access for rarely accessed archives. Flexible Retrieval and Deep Archive generally require an asynchronous restore before the archived data can be read.
Incorrect! Try again.
50An object is restored temporarily from S3 Glacier Flexible Retrieval for five days. During that window, an S3 lifecycle rule reaches its scheduled transition date for the object. What happens?
Amazon S3 Glacier
Hard
A.The lifecycle transition is canceled for that object version
B.The lifecycle transition waits until the restored copy expires
C.The restored copy permanently replaces the archived object
D.The lifecycle transition applies to the archived object as scheduled
Correct Answer: The lifecycle transition applies to the archived object as scheduled
Explanation:
A restored copy is temporary and does not replace the archived object. Lifecycle processing continues against the underlying object, so scheduled transitions are not postponed by the temporary restored copy.
Incorrect! Try again.
51A workload consists of a shared Linux home-directory tree used concurrently by EC2 instances in several Availability Zones. It requires POSIX permissions, hierarchical directories, and file locking. Which storage service best matches these requirements?
Storage technology selection
Hard
A.Amazon EFS mounted through NFS
B.Amazon S3 accessed through its object API
C.Amazon S3 Glacier accessed after restore
D.Amazon EBS attached with Multi-Attach
Correct Answer: Amazon EFS mounted through NFS
Explanation:
EFS provides a regional, shared NFS filesystem with POSIX semantics and concurrent access. S3 is object storage, while EBS is primarily block storage and does not by itself provide a shared cross-AZ filesystem.
Incorrect! Try again.
52A single EC2-hosted transactional database requires a mountable block device, stable low latency, and crash-consistent point-in-time snapshots. The active volume does not need simultaneous cross-AZ mounting. Which service should store the database files?
Storage technology selection
Hard
A.Amazon EFS
B.Amazon S3 Glacier
C.Amazon EBS
D.Amazon S3
Correct Answer: Amazon EBS
Explanation:
EBS provides persistent block storage suitable for database filesystems and supports snapshots. EFS is shared file storage, while S3 and S3 Glacier expose object-storage interfaces rather than mountable database block devices.
Incorrect! Try again.
53A production RDS database uses a Multi-AZ deployment with one standby. A reporting workload must scale reads without affecting the primary. Which design correctly addresses both availability and read scaling?
Amazon RDS
Hard
A.Route read-only SQL to the primary through a second endpoint
B.Retain Multi-AZ and add one or more read replicas
C.Replace Multi-AZ with automated snapshots and larger storage
D.Send reports directly to the Multi-AZ standby endpoint
Correct Answer: Retain Multi-AZ and add one or more read replicas
Explanation:
A traditional Multi-AZ standby provides failover and is not used for application reads. Read replicas are separate instances intended to offload eligible read traffic, though replication is generally asynchronous.
Incorrect! Try again.
54An RDS read replica is promoted to a standalone database during a regional recovery exercise. What is the key consequence of promotion?
Amazon RDS
Hard
A.The promoted database automatically becomes a synchronous standby
B.The database remains read-only until the source instance is deleted
C.Replication stops and the promoted database becomes independently writable
D.Replication continues while writes are forwarded to the former source
Correct Answer: Replication stops and the promoted database becomes independently writable
Explanation:
Promotion breaks the replica relationship and converts the replica into an independent database instance that accepts writes. Reintegration requires a separately planned replication or migration process.
Incorrect! Try again.
55A DynamoDB table uses customerId as its partition key. One customer generates 35% of all writes, causing throttling despite ample unused capacity elsewhere. Which redesign most directly distributes this hot customer's write load?
Amazon DynamoDB
Hard
A.Increase the maximum item size for the customer's records
B.Request strongly consistent reads for the customer's items
C.Append a calculated shard suffix to the customer partition key
D.Add a local secondary index using the same partition key
Correct Answer: Append a calculated shard suffix to the customer partition key
Explanation:
Write sharding spreads one logical customer's items across multiple physical partition-key values. An LSI retains the original partition key, and read consistency or item-size settings do not distribute writes.
Incorrect! Try again.
56An application inserts an order only if no order with the same primary key already exists. Concurrent retries must not overwrite an existing order. Which DynamoDB operation provides the required atomic guarantee?
Amazon DynamoDB
Hard
A.Use PutItem with attribute_not_exists as a condition expression
B.Use BatchWriteItem and inspect the unprocessed-items response
C.Run GetItem first and issue an unconditional PutItem if absent
D.Write through a global secondary index with strongly consistent reads
Correct Answer: Use PutItem with attribute_not_exists as a condition expression
Explanation:
A conditional PutItem evaluates the existence check atomically with the write. A separate read followed by a write has a race condition, and global secondary indexes do not support strongly consistent reads.
Incorrect! Try again.
57A DynamoDB global table receives nearly simultaneous updates to the same item in two Regions. Neither application uses an explicit cross-Region conflict-resolution workflow. How are conflicting values normally reconciled?
Amazon DynamoDB
Hard
A.The service applies last-writer-wins reconciliation
B.Both item versions remain queryable until manually merged
C.The service runs a serializable transaction across Regions
D.The first Region to create the item permanently owns it
Correct Answer: The service applies last-writer-wins reconciliation
Explanation:
DynamoDB global tables use last-writer-wins conflict resolution for concurrent updates. Applications needing domain-specific merging must implement that behavior explicitly.
Incorrect! Try again.
58A large Redshift table is frequently joined to a smaller dimension table on account_id, and both tables are also filtered by date ranges. Which physical design most directly reduces data redistribution during the join while supporting range-restricted scans?
Amazon Redshift
Hard
A.Use account_id as the distribution key and date as the sort key
B.Use date as the distribution key and account_id as the sort key
C.Use ALL distribution for both tables and date as the distribution key
D.Use EVEN distribution for both tables and omit their sort keys
Correct Answer: Use account_id as the distribution key and date as the sort key
Explanation:
Co-locating rows by the join key can reduce redistribution, while sorting by date helps Redshift skip blocks during range filters. The key must still have enough cardinality to avoid distribution skew.
Incorrect! Try again.
59Analysts need to join Redshift warehouse tables with several terabytes of partitioned Parquet data in S3. The external data changes often and should not be loaded into local Redshift storage before every query. Which feature is designed for this?
Amazon Redshift
Hard
A.Redshift Spectrum with an external schema
B.RDS read replicas queried through JDBC
C.DynamoDB Accelerator attached to Redshift
D.Redshift snapshots restored into a new cluster
Correct Answer: Redshift Spectrum with an external schema
Explanation:
Redshift Spectrum queries supported data formats directly in S3 through external schemas and can join external data with local Redshift tables without first loading all data into the cluster.
Incorrect! Try again.
60An Aurora cluster has a writer and multiple Aurora Replicas. After the writer fails, the application must reconnect without discovering a specific promoted instance. Which endpoint should the write-capable application use?
Amazon Aurora
Hard
A.The cluster reader endpoint
B.The RDS service API endpoint
C.The cluster writer endpoint
D.A replica's instance endpoint
Correct Answer: The cluster writer endpoint
Explanation:
The cluster endpoint follows the current primary instance and supports writes after failover. The reader endpoint load-balances read connections and is not the correct target for write-capable sessions.
Incorrect! Try again.
Did this save you a night before the exam?
LPU Notes is free, and it stays free. Ads cover part of the server bill.
The rest comes out of a student's own pocket: the domain, the storage,
and keeping the site up through the weeks everyone needs it at once.
The payment button didn't load. An ad blocker or a filtered network is the usual reason.
to try again.
Nothing here is ever locked, and nothing unlocks. Chip in only if it was worth it.
What it pays for →