Quiz IT certification exam

Question 1

A company runs hundreds of Microsoft SQL Server databases on Windows servers in its on-premises data center. A database specialist needs to migrate these databases to Linux on AWS.

Which combination of steps should the database specialist take to meet this requirement? (Choose three.)

Become a Premium Member for full access

Unlock Premium Member

Accepted Answer

Install AWS Systems Manager Agent on the on-premises servers. Use Systems Manager Run Command to install the Windows to Linux replatforming assistant for Microsoft SQL Server Databases.

Accepted Answer

On the Amazon EC2 console, launch EC2 instances and select a Linux AMI that includes SQL Server. Install and configure AWS Systems Manager Agent on the EC2 instances.

Accepted Answer

Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration.

Answer

Use AWS Systems Manager Run Command to install and configure the AWS Schema Conversion Tool on the on-premises servers.

Answer

On the AWS Management Console, set up Amazon RDS for SQL Server DB instances with Linux as the operating system. Install AWS Systems Manager Agent on the DB instances by using an options group.

Answer

On the AWS Management Console, set up AWS Database Migration Service (AWS DMS) by entering details of the source SQL Server database and the destination SQL Server database on AWS. Start migration.

Question 2

A company is running a blogging platform. A security audit determines that the Amazon RDS DB instance that is used by the platform is not configured to encrypt the data at rest. The company must encrypt the DB instance within 30 days.What should a database specialist do to meet this requirement with the LEAST amount of downtime?

Accepted Answer

Create a new encrypted DB instance. Perform an initial data load, and set up logical replication between the two DB instances When the new DB instance is in sync with the source DB instance, update the endpoint that is used by the application. Delete the unencrypted DB instance.

Answer

Create a read replica of the DB instance, and enable encryption. When the read replica is available, promote the read replica and update the endpoint that is used by the application. Delete the unencrypted DB instance.

Answer

Take a snapshot of the DB instance. Make an encrypted copy of the snapshot. Restore the encrypted snapshot. When the new DB instance is available, update the endpoint that is used by the application. Delete the unencrypted DB instance.

Answer

Convert the DB instance to an Amazon Aurora DB cluster, and enable encryption. When the DB cluster is available, update the endpoint that is used by the application to the cluster endpoint. Delete the unencrypted DB instance.

Question 3

An ecommerce company uses a backend application that stores data in an Amazon DynamoDB table.The backend application runs in a private subnet in a VPC and must connect to this table.The company must minimize any network latency that results from network connectivity issues, even during periods of heavy application usage. A database administrator also needs the ability to use a private connection to connect to the DynamoDB table from the application.Which solution will meet these requirements?

Accepted Answer

Create a VPC endpoint for DynamoDB in the application's VPC. Use the VPC endpoint to access the table.

Answer

Use network ACLs to ensure that any outgoing or incoming connections to any port except DynamoDB are deactivated. Encrypt API calls by using TLS.

Answer

Create an AWS Lambda function that has access to DynamoDB. Restrict outgoing access only to this Lambda function from the application.

Answer

Use a VPN to route all communication to DynamoDB through the company's own corporate network infrastructure.

Question 4

A company's database specialist is building an Amazon RDS for Microsoft SQL Server DB instance to store hundreds of records in CSV format. A customer service tool uploads the records to an Amazon S3 bucket.An employee who previously worked at the company already created a custom stored procedure to map the necessary CSV fields to the database tables. The database specialist needs to implement a solution that reuses this previous work and minimizes operational overhead.Which solution will meet these requirements?

Accepted Answer

Download the .csv file from Amazon S3 to the RDS D drive by using an AWS msdb stored procedure. Call the custom stored procedure to insert the data from the RDS D drive into the tables.

Answer

Create an Amazon S3 event to invoke an AWS Lambda function. Configure the Lambda function to parse the .csv file and use a SQL client library to run INSERT statements to load the data into the tables.

Answer

Write a custom .NET app that is hosted on Amazon EC2. Configure the .NET app to load the .csv file and call the custom stored procedure to insert the data into the tables.

Answer

Create an Amazon S3 event to invoke AWS Step Functions to parse the .csv file and call the custom stored procedure to insert the data into the tables.

Question 5

A company hosts a 2 TB Oracle database in its on-premises data center. A database specialist is migrating the database from on premises to an Amazon Aurora PostgreSQL database on AWS.The database specialist identifies a problem that relates to compatibility Oracle stores metadata in its data dictionary in uppercase, but PostgreSQL stores the metadata in lowercase. The database specialist must resolve this problem to complete the migration.What is the MOST operationally efficient solution that meets these requirements?

Accepted Answer

Use AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convertlowercase.

Answer

Override the default uppercase format of Oracle schema by encasing object names in quotation marks during creation.

Answer

Use the AWS Schema Conversion Tool conversion agent to convert the metadata from uppercase to lowercase.

Answer

Use an AWS Glue job that is attached to an AWS Database Migration Service (AWS DMS) replication task to convert the metadata from uppercase to lowercase.

Question 6

A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions.The company needs to generate connection logs, user logs, and user activity logs. The company also must make these logs available for future analysis.Which combination of steps should a database specialist take to meet these requirements? (Choose two.)

Accepted Answer

Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified log group in Amazon CloudWatch Logs.

Accepted Answer

Create a new parameter group with the enable_user_activity_logging parameter set to true. Configure the cluster to use the new parameter group.

Answer

Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified Amazon S3 bucket

Answer

Modify the cluster by enabling continuous delivery of AWS CloudTrail logs to Amazon S3.

Answer

Modify the system table to enable logging for each user.

Question 7

A company plans to migrate a MySQL-based application from an on-premises environment to AWS.The application performs database joins across several tables and uses indexes for faster query response times. The company needs the database to be highly available with automatic failover.Which solution on AWS will meet these requirements with the LEAST operational overhead?

Accepted Answer

Deploy an Amazon RDS Multi-AZ DB instance.

Answer

Deploy an Amazon RDS DB instance with a read replica.

Answer

Deploy Amazon DynamoDB global tables.

Answer

Deploy multiple Amazon RDS DB instances. Use Amazon Route 53 DNS with failover health checks configured.

Question 8

A social media company is using Amazon DynamoDB to store user profile data and user activity dat a. Developers are reading and writing the data, causing the size of the tables to grow significantly.Developers have started to face performance bottlenecks with the tables.Which solution should a database specialist recommend to read items the FASTEST without consuming all the provisioned throughput for the tables?

Accepted Answer

Use the Scan API operation with a filter expression that allows multiple items to be read. Use the Query API operation to read multiple items that have a specific partition key and sort key. Use the GetItem API operation to read a single item.

Answer

Use the Scan API operation in parallel with many workers to read all the items. Use the Query API operation to read multiple items that have a specific partition key and sort key. Use the GetItem API operation to read a single item.

Answer

Use the Scan API operation with a filter expression that allows multiple items to be read. Use the Query API operation to read a single item that has a specific primary key. Use the BatchGetItem API operation to read multiple items.

Answer

Use the Scan API operation in parallel with many workers to read all the items. Use the Query API operation to read a single item that has a specific primary key Use the BatchGetItem API operation to read multiple items.

Question 9

A pharmaceutical company's drug search API is using an Amazon Neptune DB cluster. A bulk uploader process automatically updates the information in the database a few times each week. A few weeks ago during a bulk upload, a database specialist noticed that the database started to respond frequently with a ThrottlingException error. The problem also occurred with subsequent uploads.The database specialist must create a solution to prevent ThrottlingException errors for the database. The solution must minimize the downtime of the cluster.Which solution meets these requirements?

Accepted Answer

Create a read replica that uses a larger instance size than the primary DB instance. Offload the reads from the primary DB instance.

Answer

Create a read replica that uses a larger instance size than the primary DB instance. Fail over the primary DB instance to the read replica.

Answer

Add a read replica to each Availability Zone. Use an instance for the read replica that is the same size as the primary DB instance. Keep the traffic between the API and the database within the Availability Zone.

Answer

Take the latest backup, and restore it in a DB cluster of a larger size. Point the application to the newly created DB cluster.

Question 10

A global company is developing an application across multiple AWS Regions. The company needs a database solution with low latency in each Region and automatic disaster recovery. The database must be deployed in an active-active configuration with automatic data synchronization between Regions.Which solution will meet these requirements with the LOWEST latency?

Accepted Answer

Amazon DynamoDB global tables

Answer

Amazon RDS with cross-Region read replicas

Answer

Amazon Aurora global database

Answer

Amazon Athena and Amazon S3 with S3 Cross Region Replication

Question 11

A pharmaceutical company uses Amazon Quantum Ledger Database (Amazon QLDB) to store its clinical trial data records. The company has an application that runs as AWS Lambda functions. The application is hosted in the private subnet in a VPC.The application does not have internet access and needs to read some of the clinical data records.The company is concerned that traffic between the QLDB ledger and the VPC could leave the AWS network. The company needs to secure access to the QLDB ledger and allow the VPC traffic to have read-only access.Which security strategy should a database specialist implement to meet these requirements?

Accepted Answer

Create an AWS PrivateLink VPC endpoint for the QLDB ledger. Attach a VPC policy to the VPC endpoint to allow read-only traffic for the Lambda functions that run inside the VPC.

Answer

Move the QLDB ledger into a private database subnet inside the VPC. Run the Lambda functions inside the same VPC in an application private subnet. Ensure that the VPC route table allows readonly flow from the application subnet to the database subnet.

Answer

Add a security group to the QLDB ledger to allow access from the private subnets inside the VPC where the Lambda functions that access the QLDB ledger are running.

Answer

Create a VPN connection to ensure pairing of the private subnet where the Lambda functions are running with the private subnet where the QLDB ledger is deployed.

Question 12

A company's application development team wants to share an automated snapshot of its Amazon RDS database with another team. The database is encrypted with a custom AWS Key Management Service (AWS KMS) key under the "WeShare" AWS account. The application development team needs to share the DB snapshot under the "WeReceive" AWS account.Which combination of actions must the application development team take to meet these requirements? (Choose two.)

Accepted Answer

Add access from the "WeReceive" account to the custom AWS KMS key policy of the sharing team.

Accepted Answer

Make a copy of the DB snapshot, and set the encryption option to enable.

Answer

Make a copy of the DB snapshot, and set the encryption option to disable.

Answer

Share the DB snapshot by setting the DB snapshot visibility option to public.

Answer

Share the DB snapshot by using the default AWS KMS encryption key.

Question 13

A company is using Amazon Redshift as its data warehouse solution. The Redshift cluster handles the following types of workloads:*Real-time inserts through Amazon Kinesis Data Firehose *Bulk inserts through COPY commands from Amazon S3 *Analytics through SQL queries Recently, the cluster has started to experience performance issues.Which combination of actions should a database specialist take to improve the cluster's performance? (Choose three.)

Accepted Answer

Stream real-time data into Redshift temporary tables before loading the data into permanent tables.

Accepted Answer

For bulk inserts, split input files on Amazon S3 into multiple files to match the number of slices on Amazon Redshift. Then use the COPY command to load data into Amazon Redshift.

Accepted Answer

Optimize analytics SQL queries to use sort keys.

Answer

Modify the Kinesis Data Firehose delivery stream to stream the data to Amazon S3 with a high buffer size and to load the data into Amazon Redshift by using the COPY command.

Answer

For bulk inserts, use the parallel parameter in the COPY command to enable multi-threading.

Answer

Avoid using temporary tables in analytics SQL queries.

Question 14

An information management services company is storing JSON documents on premises. The company is using a MongoDB 3.6 database but wants to migrate to AWS. The solution must be compatible, scalable, and fully managed. The solution also must result in as little downtime as possible during the migration.Which solution meets these requirements?

Accepted Answer

Create an AWS Database Migration Service (AWS DMS) replication instance, a source endpoint for MongoDB, and a target endpoint of Amazon DocumentDB (with MongoDB compatibility).

Answer

Create an AWS Database Migration Service (AWS DMS) replication instance, a source endpoint for MongoDB, and a target endpoint of a MongoDB image that is hosted on Amazon EC2

Answer

Use the mongodump and mongorestore tools to migrate the data from the source MongoDB deployment to Amazon DocumentDB (with MongoDB compatibility).

Answer

Use the mongodump and mongorestore tools to migrate the data from the source MongoDB deployment to a MongoDB image that is hosted on Amazon EC2.

Question 15

A company stores critical data for a department in Amazon RDS for MySQL DB instances. The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time. To meet this requirement, the database specialist stopped all the DB instances used by the department but did not select the option to create a snapshot. Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully.What could be the reason for this?

Accepted Answer

Stopped DB instances will automatically restart if the instance is not manually started after 7 days.

Answer

When stopping the DB instance, the option to create a snapshot should have been selected.

Answer

When stopping the DB instance, the duration for stopping the DB instance should have been selected.

Answer

Stopped DB instances will automatically restart if the number of attempted connections exceeds the threshold set.

Question 16

A company uses an on-premises Microsoft SQL Server database to host relational and JSON data and to run daily ETL and advanced analytics. The company wants to migrate the database to the AWS Cloud. Database specialist must choose one or more AWS services to run the company's workloads.Which solution will meet these requirements in the MOST operationally efficient manner?

Accepted Answer

Use Amazon Redshift for relational data and JSON data.

Answer

Use Amazon Redshift for relational data. Use Amazon DynamoDB for JSON data

Answer

Use Amazon RDS for relational data. Use Amazon Neptune for JSON data

Answer

Use Amazon Redshift for relational data. Use Amazon S3 for JSON data.

Question 17

An online gaming company is using an Amazon DynamoDB table in on-demand mode to store game scores. After an intensive advertisement campaign in South America, the average number of concurrent users rapidly increases from 100,000 to 500,000 in less than 10 minutes every day around 5 PM.The on-call software reliability engineer has observed that the application logs contain a high number of DynamoDB throttling exceptions caused by game score insertions around 5 PM. Customer service has also reported that several users are complaining about their scores not being registered.How should the database administrator remediate this issue at the lowest cost?

Accepted Answer

Switch the table to provisioned mode and enable auto scaling.

Answer

Enable auto scaling and set the target usage rate to 90%.

Answer

Switch the table to provisioned mode and set the throughput to the peak value.

Answer

Create a DynamoDB Accelerator cluster and use it to access the DynamoDB table.

Question 18

A gaming company uses Amazon Aurora Serverless for one of its internal applications. The company's developers use Amazon RDS Data API to work with the Aurora Serverless DB cluster. After a recent security review, the company is mandating security enhancements. A database specialist must ensure that access to RDS Data API is private and never passes through the public internet. What should the database specialist do to meet this requirement?

Accepted Answer

Create an interface VPC endpoint that uses AWS PrivateLink for RDS Data API.

Answer

Modify the Aurora Serverless cluster by selecting a VPC with private subnets.

Answer

Modify the Aurora Serverless cluster by unchecking the publicly accessible option.

Answer

Create a gateway VPC endpoint for RDS Data API.

Question 19

A startup company in the travel industry wants to create an application that includes a personal travel assistant to display information for nearby airports based on user location. The application will use Amazon DynamoDB and must be able to access and display attributes such as airline names, arrival times, and flight numbers. However, the application must not be able to access or display pilot names or passenger counts.Which solution will meet these requirements MOST cost-effectively?

Accepted Answer

Use IAM policies with a combination of IAM conditions and actions to implement fine-grained access control.

Answer

Use a proxy tier between the application and DynamoDB to regulate access to specific tables, items, and attributes.

Answer

Use DynamoDB resource policies to regulate access to specific tables, items, and attributes.

Answer

Configure an AWS Lambda function to extract only allowed attributes from tables based on user profiles.

Question 20

A large IT hardware manufacturing company wants to deploy a MySQL database solution in the AWS Cloud. The solution should quickly create copies of the company's production databases for test purposes. The solution must deploy the test databases in minutes, and the test data should match the latest production data as closely as possible. Developers must also be able to make changes in the test database and delete the instances afterward.Which solution meets these requirements?

Accepted Answer

Leverage Amazon Aurora MySQL. Use database cloning to create multiple test copies of the production DB clusters.

Answer

Leverage Amazon RDS for MySQL with write-enabled replicas running on Amazon EC2. Create the test copies using a mysqidump backup from the RDS for MySQL DB instances and importing them into the new EC2 instances.

Answer

Leverage Amazon Aurora MySQL. Restore previous production DB instance snapshots into new test copies of Aurora MySQL DB clusters to allow them to make changes.

Answer

Leverage Amazon RDS for MySQL. Use database cloning to create multiple developer copies of the production DB instance.

Question 21

An ecommerce company is running AWS Database Migration Service (AWS DMS) to replicate an onpremises Microsoft SQL Server database to Amazon RDS for SQL Server. The company has set up an AWS Direct Connect connection from its on-premises data center to AWS. During the migration, the company's security team receives an alarm that is related to the migration. The security team mandates that the DMS replication instance must not be accessible from public IP addresses.What should a database specialist do to meet this requirement?

Accepted Answer

Delete the DMS replication instance. Recreate the DMS replication instance with the publicly accessible option disabled.

Answer

Set up a VPN connection to encrypt the traffic over the Direct Connect connection.

Answer

Modify the DMS replication instance by disabling the publicly accessible option.

Answer

Create a new replication VPC subnet group with private subnets. Modify the DMS replication instance by selecting the newly created VPC subnet group.

Question 22

A company is using an Amazon Aurora MySQL database with Performance Insights enabled. A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase: `Performance Insights is unable to collect SQL Digest statistics on new queries`¦` Which action will resolve this alert message?

Accepted Answer

Truncate the events_statements_summary_by_digest table.

Answer

Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights.

Answer

Set the value for the performance_schema parameter in the parameter group to 1.

Answer

Disable and reenable Performance Insights to be effective in the next maintenance window.

Question 23

A bike rental company operates an application to track its bikes. The application receives location and condition data from bike sensors. The application also receives rental transaction data from the associated mobile app. The application uses Amazon DynamoDB as its database layer. The company has configured DynamoDB with provisioned capacity set to 20% above the expected peak load of the application. On an average day, DynamoDB used 22 billion read capacity units (RCUs) and 60 billion write capacity units (WCUs). The application is running well. Usage changes smoothly over the course of the day and is generally shaped like a bell curve. The timing and magnitude of peaks vary based on the weather and season, but the general shape is consistent.Which solution will provide the MOST cost optimization of the DynamoDB database layer?

Accepted Answer

Enable DynamoDB capacity-based auto scaling.

Answer

Change the DynamoDB tables to use on-demand capacity.

Answer

Use AWS Auto Scaling and configure time-based scaling.

Answer

Enable DynamoDB Accelerator (DAX).

Question 24

A company has a quarterly customer survey. The survey uses an Amazon EC2 instance that is hosted in a public subnet to host a customer survey website. The company uses an Amazon RDS DB instance that is hosted in a private subnet in the same VPC to store the survey results.The company takes a snapshot of the DB instance after a survey is complete, deletes the DB instance, and then restores the DB instance from the snapshot when the survey needs to be conducted again.A database specialist discovers that the customer survey website times out when it attempts to establish a connection to the restored DB instance.What is the root cause of this problem?

Accepted Answer

The wrong security group was associated with the new DB instance when it was restored from the snapshot.

Answer

The VPC peering connection has not been configured properly for the EC2 instance to communicate with the DB instance.

Answer

The route table of the private subnet that hosts the DB instance does not have a NAT gateway configured for communication with the EC2 instance.

Answer

The public subnet that hosts the EC2 instance does not have an internet gateway configured for communication with the DB instance.

Question 25

A company wants to improve its ecommerce website on AWS. A database specialist decides to add Amazon ElastiCache for Redis in the implementation stack to ease the workload off the database and shorten the website response times.The database specialist must also ensure the ecommerce website is highly available within the company's AWS Region.How should the database specialist deploy ElastiCache to meet this requirement?

Accepted Answer

Launch an ElastiCache for Redis cluster and select read replicas in different Availability Zones.

Answer

Launch an ElastiCache for Redis cluster using the AWS CLI with the -cluster-enabled switch.

Answer

Launch two ElastiCache for Redis clusters in two different Availability Zones. Configure Redis streams to replicate the cache from the primary cluster to another.

Answer

Launch an ElastiCache cluster in the primary Availability Zone and restore the cluster's snapshot to a different Availability Zone during disaster recovery.

Question 26

A company hosts an on-premises Microsoft SQL Server Enterprise edition database with Transparent Data Encryption (TDE) enabled. The database is 20 TB in size and includes sparse tables. The company needs to migrate the database to Amazon RDS for SQL Server during a maintenance window that is scheduled for an upcoming weekend. Data-at-rest encryption must be enabled for the target DB instance.Which combination of steps should the company take to migrate the database to AWS in the MOST operationally efficient manner? (Choose two.)

Accepted Answer

Disable TDE. Create a database backup without encryption. Copy the backup to Amazon S3.

Accepted Answer

Restore the backup to the RDS for SQL Server DB instance. Enable TDE for the RDS for SQL Server DB instance.

Answer

Use AWS Database Migration Service (AWS DMS) to migrate from the on-premises source database to the RDS for SQL Server target database.

Answer

Set up an AWS Snowball Edge device. Copy the database backup to the device. Send the device to AWS. Restore the database from Amazon S3.

Answer

Encrypt the data with client-side encryption before transferring the data to Amazon RDS.

Question 27

A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available. Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.What might account for this? (Choose two.)

Accepted Answer

The new minor version has not yet been designated as preferred and requires a manual upgrade.

Accepted Answer

The AWS CLI command did not include an apply-immediately parameter.

Answer

Configuring automatic upgrades using the AWS CLI is not supported. This must be enabled expressly using the AWS Management Console.

Answer

Applying minor version upgrades requires sufficient free space.

Answer

Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.

Question 28

A security team is conducting an audit for a financial company. The security team discovers that the database credentials of an Amazon RDS for MySQL DB instance are hardcoded in the source code.The source code is stored in a shared location for automatic deployment and is exposed to all users who can access the location.A database specialist must use encryption to ensure that the credentials are not visible in the source code.Which solution will meet these requirements?

Accepted Answer

Store the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the credentials with calls to Systems Manager.

Answer

Use an AWS Key Management Service (AWS KMS) key to encrypt the most recent database backup. Restore the backup as a new database to activate encryption.

Answer

Store the source code to access the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the code with calls to Systems Manager.

Answer

Use an AWS Key Management Service (AWS KMS) key to encrypt the DB instance at rest. Activate RDS encryption in transit by using SSL certificates.

Question 29

A gaming company is evaluating Amazon ElastiCache as a solution to manage player leaderboards.Millions of players around the world will complete in annual tournaments. The company wants to implement an architecture that is highly available. The company also wants to ensure that maintenance activities have minimal impact on the availability of the gaming platform.Which combination of steps should the company take to meet these requirements? (Choose two.)

Accepted Answer

Deploy an ElastiCache for Redis cluster with read replicas and Multi-AZ enabled.

Accepted Answer

Choose a preferred maintenance window at the time of lowest usage to apply any required changes and mandatory updates.

Answer

Deploy an ElastiCache for Memcached global datastore.

Answer

Deploy a single-node ElastiCache for Redis cluster with automatic backups enabled. In the event of a failure, create a new cluster and restore data from the most recent backup.

Answer

Use the default maintenance window to apply any required system changes and mandatory updates as soon as they are available.

Question 30

A company stores session history for its users in an Amazon DynamoDB table. The company has a large user base and generates large amounts of session data.Teams analyze the session data for 1 week, and then the data is no longer needed. A database specialist needs to design an automated solution to purge session data that is more than 1 week old.Which strategy meets these requirements with the MOST operational efficiency?

Accepted Answer

Enable TTL on the DynamoDB table and set a Number data type as the TTL attribute. DynamoDB will automatically delete items that have a TTL that is less than the current time.

Answer

Create an AWS Step Functions state machine with a DynamoDB DeleteItem operation that uses the ConditionExpression parameter to delete items older than a week. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that runs the Step Functions state machine on a weekly basis.

Answer

Create an AWS Lambda function to delete items older than a week from the DynamoDB table. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that triggers the Lambda function on a weekly basis.

Answer

Enable Amazon DynamoDB Streams on the table. Use a stream to invoke an AWS Lambda function to delete items older than a week from the DynamoDB table

Question 31

A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and a MySQL database that is hosted in Amazon RDS.After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company's database team needs to configure the database to require in-transit encryption for all connections.Which solution will meet this requirement?

Accepted Answer

Update the parameter group in use by the DB instance, and set the require_secure_transport parameter to ON.

Answer

Connect to the database, and use ALTER USER to enable the REQUIRE SSL option on the database user.

Answer

Update the security group in use by the DB instance, and remove port 80 to prevent unencrypted connections from being established.

Answer

Update the DB instance, and enable the Require Transport Layer Security option.

Question 32

A database specialist is designing an enterprise application for a large company. The application uses Amazon DynamoDB with DynamoDB Accelerator (DAX).The database specialist observes that most of the queries are not found in the DAX cache and that they still require DynamoDB table reads.What should the database specialist review first to improve the utility of DAX?

Accepted Answer

The DAX cluster's TTL setting

Answer

The DynamoDB ConsumedReadCapacityUnits metric

Answer

The trust relationship to perform the DynamoDB API calls

Answer

The validity of customer-specified AWS Key Management Service (AWS KMS) keys for DAX encryption at rest

Question 33

A company is loading sensitive data into an Amazon Aurora MySQL database. To meet compliance requirements, the company needs to enable audit logging on the Aurora MySQL DB cluster to audit database activity. This logging will include events such as connections, disconnections, queries, and tables queried. The company also needs to publish the DB logs to Amazon CloudWatch to perform real-time data analysis.Which solution meets these requirements?

Accepted Answer

Create a custom DB cluster parameter group. Modify the parameters for Advanced Auditing. Modify the cluster to associate the new custom DB parameter group with the Aurora MySQL DB cluster.

Answer

Modify the default option group parameters to enable Advanced Auditing. Restart the database for the changes to take effect.

Answer

Take a snapshot of the database. Create a new DB instance, and enable custom auditing and logging to CloudWatch. Deactivate the DB instance that has no logging.

Answer

Enable AWS CloudTrail for the DB instance. Create a filter that provides only connections, disconnections, queries, and tables queried.

Question 34

A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A database specialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Server backup file is approximately 120 GB in size. The application can be down for an extended period of time to complete the migration. Connectivity between the on-premises environment and AWS can be initiated from premises only.How can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?

Accepted Answer

Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Restore the backup files from the S3 bucket into the new production RDS instance.

Answer

Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Download the backup files on an Amazon EC2 instance and restore them from the EC2 instance into the new production RDS instance.

Answer

Provision and configure AWS DMS. Set up replication between the on-premises SQL Server environment to replicate the database to the new production RDS instance.

Answer

Back up the SQL Server database using AWS Backup. Once the backup is complete, restore the completed backup to an Amazon EC2 instance and move it to the new production RDS instance.

Question 35

A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table. TTL is enabled on one of the attributes. The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.What is the MOST likely reason that the items are not being deleted?

Accepted Answer

The TTL attribute's value is set as a Binary data type.

Answer

The TTL attribute's value is set as a Number data type.

Answer

The TTL attribute's value is a timestamp in the Unix epoch time format in seconds.

Answer

The TTL attribute's value is set with an expiration of 1 year.

Question 36

A company has deployed an application that uses an Amazon RDS for MySQL DB cluster. The DB cluster uses three read replicas. The primary DB instance is an 8XL-sized instance, and the read replicas are each XL-sized instances.Users report that database queries are returning stale dat a. The replication lag indicates that the replicas are 5 minutes behind the primary DB instance. Status queries on the replicas show that the SQL_THREAD is 10 binlogs behind the IO_THREAD and that the IO_THREAD is 1 binlog behind the primary.Which changes will reduce the lag? (Choose two.)

Accepted Answer

Migrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora Replicas.

Accepted Answer

Increase the instance size of the read replicas to the same size and class as the primary DB instance.

Answer

Deploy two additional read replicas matching the existing replica DB instance size.

Answer

Move the read replicas to the same Availability Zone as the primary DB instance.

Answer

Increase the instance size of the primary DB instance within the same instance class.

Question 37

A company is using Amazon Aurora MySQL as the database for its retail application on AWS. The company receives a notification of a pending database upgrade and wants to ensure upgrades do not occur before or during the most critical time of year. Company leadership is concerned that an Amazon RDS maintenance window will cause an outage during data ingestion.Which step can be taken to ensure that the application is not interrupted?

Accepted Answer

Choose to defer the upgrade and then find an appropriate down time for patching.

Answer

Disable weekly maintenance on the DB cluster.

Answer

Clone the DB cluster and migrate it to a new copy of the database.

Answer

Set up an Aurora Replica and promote it to primary at the time of patching.

Question 38

A company's development team needs to have production data restored in a staging AWS account.The production database is running on an Amazon RDS for PostgreSQL Multi-AZ DB instance, which has AWS KMS encryption enabled using the default KMS key.A database specialist planned to share the most recent automated snapshot with the staging account, but discovered that the option to share snapshots is disabled in the AWS Management Console.What should the database specialist do to resolve this?

Accepted Answer

Copy the automated snapshot specifying a custom KMS encryption key. Share both the copied snapshot and the custom KMS encryption key with the staging account. Restore the snapshot to the staging account within the same Region.

Answer

Disable automated backups in the DB instance. Share both the automated snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account and enable automated backups.

Answer

Modify the DB instance to use a custom KMS encryption key. Share both the automated snapshot and the custom KMS encryption key with the staging account. Restore the snapshot in the staging account.

Answer

Copy the automated snapshot while keeping the default KMS key. Share both the snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account.

Question 39

A software-as-a-service (SaaS) company is using an Amazon Aurora Serverless DB cluster for its production MySQL database. The DB cluster has general logs and slow query logs enabled. A database engineer must use the most operationally efficient solution with minimal resource utilization to retain the logs and facilitate interactive search and analysis.Which solution meets these requirements?

Accepted Answer

Use Amazon CloudWatch Logs Insights to search and analyze the logs when the logs are automatically uploaded by the DB cluster.

Answer

Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.

Answer

Download the logs from the DB cluster and store them in Amazon S3 by using manual scripts. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.

Answer

Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Elasticsearch Service (Amazon ES) and Kibana to search and analyze the logs.

Question 40

A retail company uses Amazon Redshift Spectrum to run complex analytical queries on objects that are stored in an Amazon S3 bucket. The objects are joined with multiple dimension tables that are stored in an Amazon Redshift database.The company uses the database to create monthly and quarterly aggregated reports. Users who attempt to run queries are reporting the following error message: error: Spectrum Scan Error: Access throttled Which solution will resolve this error?

Accepted Answer

Check file sizes of fact tables in Amazon S3, and look for small files. Merge the small files into larger files of at least 64 MB in size.

Answer

Check file sizes of fact tables in Amazon S3, and look for large files. Break up large files into smaller files of equal size between 100 MB and 1 GB

Answer

Reduce the number of queries that users can run in parallel.

Answer

Review and optimize queries that submit a large aggregation step to Redshift Spectrum.

Amazon DBS-C01 Practice Test 6

Amazon DBS-C01 Practice Tests

Amazon DBS-C01 Practice Test 6

Question

Amazon DBS-C01 Practice Tests

Practice Tests