ExamGecko
Login
Home / Amazon / DBS-C01 / List of questions
Ask Question

Amazon DBS-C01 Practice Test - Questions Answers, Page 21

List of questions

Question 201

Report
Export
Collapse

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.)

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.
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.
Use AWS Systems Manager Run Command to install and configure the AWS Schema Conversion Tool on the on-premises servers.
Use AWS Systems Manager Run Command to install and configure the AWS Schema Conversion Tool on the on-premises servers.
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.
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.
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.
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.
Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration.
Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration.
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.
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.
Suggested answer: A, C, E

Explanation:


https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/replatform-sql-server.html

https://d1.awsstatic.com/events/reinvent/2019/REPEAT_1_Leverage_automation_to_replatform_SQL_Server_to_Linux_WIN322-R1.pdf

asked 16/09/2024
Tamas Szekely
36 questions

Question 202

Report
Export
Collapse

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?

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.
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.
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.
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.
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.
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.
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.
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.
Suggested answer: C

Explanation:


https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/encrypt-an-existing-amazonrds-for-postgresql-db-instance.html

When the new, encrypted copy of the DB instance becomes available, you can point your applications to the new database. However, if your project doesn’t allow for significant downtime for this activity, you need an alternate approach that helps minimize the downtime. This pattern uses the AWS Database Migration Service (AWS DMS) to migrate and continuously replicate the data so that the cutover to the new, encrypted database can be done with minimal downtime.

asked 16/09/2024
samer salami
34 questions

Question 203

Report
Export
Collapse

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?

Use network ACLs to ensure that any outgoing or incoming connections to any port except DynamoDB are deactivated. Encrypt API calls by using TLS.
Use network ACLs to ensure that any outgoing or incoming connections to any port except DynamoDB are deactivated. Encrypt API calls by using TLS.
Create a VPC endpoint for DynamoDB in the application's VPC. Use the VPC endpoint to access the table.
Create a VPC endpoint for DynamoDB in the application's VPC. Use the VPC endpoint to access the table.
Create an AWS Lambda function that has access to DynamoDB. Restrict outgoing access only to this Lambda function from the application.
Create an AWS Lambda function that has access to DynamoDB. Restrict outgoing access only to this Lambda function from the application.
Use a VPN to route all communication to DynamoDB through the company's own corporate network infrastructure.
Use a VPN to route all communication to DynamoDB through the company's own corporate network infrastructure.
Suggested answer: B

Explanation:


https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/vpc-endpointsdynamodb.html

asked 16/09/2024
taheireem shaikh
35 questions

Question 204

Report
Export
Collapse

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?

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.
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.
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.
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.
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.
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.
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.
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.
Suggested answer: C

Explanation:


Step 1: Download S3 Files Amazon RDS for SQL Server comes with several custom stored procedures and functions. These are located in the msdb database. The stored procedure to download files from S3 is "rds_download_from_s3". The syntax for this stored procedure is shown here: exec msdb.dbo.rds_download_from_s3 @s3_arn_of_file='arn:aws:s3:::<bucket_name>/<file_name>', @rds_file_path='D:\S3\<custom_folder_name>\<file_name>', @overwrite_file=1;

asked 16/09/2024
Victor Avila
29 questions

Question 205

Report
Export
Collapse

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?

Override the default uppercase format of Oracle schema by encasing object names in quotation marks during creation.
Override the default uppercase format of Oracle schema by encasing object names in quotation marks during creation.
Use AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convertlowercase.
Use AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convertlowercase.
Use the AWS Schema Conversion Tool conversion agent to convert the metadata from uppercase to lowercase.
Use the AWS Schema Conversion Tool conversion agent to convert the metadata from uppercase to lowercase.
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.
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.
Suggested answer: B

Explanation:


https://aws.amazon.com/premiumsupport/knowledge-center/dms-mapping-oracle-postgresql/

asked 16/09/2024
Sunila Chugh
40 questions

Question 206

Report
Export
Collapse

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.)

Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified log group in Amazon CloudWatch Logs.
Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified log group in Amazon CloudWatch Logs.
Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified Amazon S3 bucket
Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified Amazon S3 bucket
Modify the cluster by enabling continuous delivery of AWS CloudTrail logs to Amazon S3.
Modify the cluster by enabling continuous delivery of AWS CloudTrail logs to Amazon S3.
Create a new parameter group with the enable_user_activity_logging parameter set to true. Configure the cluster to use the new parameter group.
Create a new parameter group with the enable_user_activity_logging parameter set to true. Configure the cluster to use the new parameter group.
Modify the system table to enable logging for each user.
Modify the system table to enable logging for each user.
Suggested answer: A, D

Explanation:


AWS CloudWatch Logs are stored indefinitely and CloudWatch Log Insights is used to analyze the logs and query upon them.

https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/AnalyzingLogData.html

https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/WhatIsCloudWatchLogs.html"

Log retention – By default, logs are kept indefinitely and never expire. You can adjust the retention policy for each log group, keeping the indefinite retention, or choosing a retention period between10 years and one day."

https://docs.aws.amazon.com/redshift/latest/mgmt/db-auditing.html

asked 16/09/2024
GLAUCIA C N SILVA
41 questions

Question 207

Report
Export
Collapse

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?

Deploy an Amazon RDS DB instance with a read replica.
Deploy an Amazon RDS DB instance with a read replica.
Deploy an Amazon RDS Multi-AZ DB instance.
Deploy an Amazon RDS Multi-AZ DB instance.
Deploy Amazon DynamoDB global tables.
Deploy Amazon DynamoDB global tables.
Deploy multiple Amazon RDS DB instances. Use Amazon Route 53 DNS with failover health checks configured.
Deploy multiple Amazon RDS DB instances. Use Amazon Route 53 DNS with failover health checks configured.
Suggested answer: B

Explanation:


asked 16/09/2024
Mustafa Hussien
41 questions

Question 208

Report
Export
Collapse

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?

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.
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.
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.
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.
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.
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.
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.
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.
Suggested answer: B

Explanation:


https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SQLtoNoSQL.ReadData.html

asked 16/09/2024
Juliet Kihonge
43 questions

Question 209

Report
Export
Collapse

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?

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.
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.
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.
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.
Create a read replica that uses a larger instance size than the primary DB instance. Offload the reads from the primary DB instance.
Create a read replica that uses a larger instance size than the primary DB instance. Offload the reads from the primary DB instance.
Take the latest backup, and restore it in a DB cluster of a larger size. Point the application to the newly created DB cluster.
Take the latest backup, and restore it in a DB cluster of a larger size. Point the application to the newly created DB cluster.
Suggested answer: C

Explanation:


https://docs.aws.amazon.com/neptune/latest/userguide/manage-console-add-replicas.html

Neptune replicas connect to the same storage volume as the primary DB instance and support only read operations. Neptune replicas can offload read workloads from the primary DB instance.

asked 16/09/2024
Khaled Mohamed Abdraboh Metwalli
34 questions

Question 210

Report
Export
Collapse

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?

Amazon RDS with cross-Region read replicas
Amazon RDS with cross-Region read replicas
Amazon DynamoDB global tables
Amazon DynamoDB global tables
Amazon Aurora global database
Amazon Aurora global database
Amazon Athena and Amazon S3 with S3 Cross Region Replication
Amazon Athena and Amazon S3 with S3 Cross Region Replication
Suggested answer: B

Explanation:


asked 16/09/2024
Stefan Finke
41 questions
Total 321 questions
Go to page: of 33
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora DB cluster is appropriate for the peak workload. The company is now looking at cutting costs for this DB cluster, but needs to have a sufficient number of nodes in the cluster to support the workload at different times. The workload has not changed since the previous benchmarking exercise. How can a Database Specialist address these requirements with minimal user involvement?
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup. The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company. Which solution will meet these requirements with minimal effort?
A Database Specialist is creating Amazon DynamoDB tables, Amazon CloudWatch alarms, and associated infrastructure for an Application team using a development AWS account. The team wants a deployment method that will standardize the core solution components while managing environment-specific settings separately, and wants to minimize rework due to configuration errors. Which process should the Database Specialist recommend to meet these requirements?
A large financial services company uses Amazon ElastiCache for Redis for its new application that has a global user base. A database administrator must develop a caching solution that will be available across AWS Regions and include low-latency replication and failover capabilities for disaster recovery (DR). The company's security team requires the encryption of cross-Region data transfers. Which solution meets these requirements with the LEAST amount of operational effort?
An ecommerce company uses Amazon DynamoDB as the backend for its payments system. A new regulation requires the company to log all data access requests for financial audits. For this purpose, the company plans to use AWS logging and save logs to Amazon S3 How can a database specialist activate logging on the database?
A company needs to migrate Oracle Database Standard Edition running on an Amazon EC2 instance to an Amazon RDS for Oracle DB instance with Multi-AZ. The database supports an ecommerce website that runs continuously. The company can only provide a maintenance window of up to 5 minutes. Which solution will meet these requirements?
A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime using AWS DMS. A Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover. The migration must have minimal impact on the performance of the source database. Which approach will MOST effectively meet these requirements?
A company is about to launch a new product, and test databases must be re-created from production dat a. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort. What should the Database Specialist do to meet these requirements?
A company is due for renewing its database license. The company wants to migrate its 80 TB transactional database system from on-premises to the AWS Cloud. The migration should incur the least possible downtime on the downstream database applications. The company’s network infrastructure has limited network bandwidth that is shared with other applications. Which solution should a database specialist use for a timely migration?
A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users. How should the Database Specialist apply the parameter group change for the DB instance?