Free Amazon (DBS-C01) Certification Sample Questions with Online Practice Test
DBS-C01 Certification Study Guide Pass DBS-C01 Fast
NEW QUESTION # 23
A financial services company has an application deployed on AWS that uses an Amazon Aurora PostgreSQL DB cluster. A recent audit showed that no log files contained database administrator activity. A database specialist needs to recommend a solution to provide database access and activity logs. The solution should use the least amount of effort and have a minimal impact on performance.
Which solution should the database specialist recommend?
- A. Allow connections to the DB cluster through a bastion host only. Restrict database access to the bastion host and application servers. Push the bastion host logs to Amazon CloudWatch Logs using the CloudWatch Logs agent.
- B. Create an AWS CloudTrail trail in the Region where the database runs. Associate the database activity logs with the trail.
- C. Enable Aurora Database Activity Streams on the database in asynchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Firehose destination to an Amazon S3 bucket.
- D. Enable Aurora Database Activity Streams on the database in synchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Kinesis Data Firehose destination to an Amazon S3 bucket.
Answer: C
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/DBActivityStreams.Overview.html
NEW QUESTION # 24
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?
- A. 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.
- B. 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.
- C. 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.
- D. 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: D
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;
NEW QUESTION # 25
A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.
Which AWS services should the Database Specialist consider? (Choose two.)
- A. Amazon Neptune
- B. Amazon Elasticsearch Service
- C. Amazon DynamoDB
- D. Amazon Redshift
- E. Amazon ElastiCache
Answer: C,E
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html#Strategies.WriteThrough
https://aws.amazon.com/products/databases/real-time-apps-elasticache-for-redis/
NEW QUESTION # 26
A company has multiple applications serving data from a secure on-premises database. The company is migrating all applications and databases to the AWS Cloud. The IT Risk and Compliance department requires that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as the migration target, and leveraging the Advanced Auditing feature in Aurora.
Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements? (Choose three.)
- A. QUERY_DML
- B. QUERY_DCL
- C. CONNECT
- D. TABLE
- E. QUERY
- F. QUERY_DDL
Answer: B,C,F
Explanation:
Explanation
Connect - logins / DCL - authorizations (grant,revoke), DDL - schema updates
NEW QUESTION # 27
A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster. The database will be accessed by multiple applications across the company. The company has mandated that all communications to the database be encrypted and the server identity must be validated. Any non-SSL-based connections should be disallowed access to the database.
Which solution addresses these requirements?
- A. Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-ca.
- B. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-full.
- C. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=disable.
- D. Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=allow.
Answer: B
Explanation:
Explanation
PostgreSQL: sslrootcert=rds-cert.pem sslmode=[verify-ca | verify-full]
NEW QUESTION # 28
A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues. A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created. The database specialist must effectively apply this new partition key to all existing and new data.
How can this solution be implemented?
- A. Use the AWS CLI to update the DynamoDB table and modify the partition key.
- B. Use the AWS CLI to back up the DynamoDB table. Then use the restore-table-from-backup command and modify the partition key.
- C. Use AWS DMS to copy the data from the current DynamoDB table to Amazon S3. Then import the DynamoDB table to create a new DynamoDB table with the new partition key.
- D. Use Amazon EMR to export the data from the current DynamoDB table to Amazon S3. Then use Amazon EMR again to import the data from Amazon S3 into a new DynamoDB table with the new partition key.
Answer: B
NEW QUESTION # 29
For the first time, a database professional is establishing a test graph database on Amazon Neptune. The database expert must input millions of rows of test observations from an Amazon S3.csv file. The database professional uploaded the data to the Neptune DB instance through a series of API calls.
Which sequence of actions enables the database professional to upload the data most quickly? (Select three.)
- A. Use AWS DMS to move data from Amazon S3 to the Neptune Loader.
- B. Ensure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket.
- C. Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.
- D. Ensure the vertices and edges are specified in different .csv files with proper header column formatting.
- E. Create an S3 VPC endpoint and issue an HTTP POST to the database's loader endpoint.
- F. Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.
Answer: B,D,E
Explanation:
Explanation
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-optimize.html
NEW QUESTION # 30
A business is operating an on-premises application that is divided into three tiers: web, application, and MySQL database. The database is predominantly accessed during business hours, with occasional bursts of activity throughout the day. As part of the company's shift to AWS, a database expert wants to increase the availability and minimize the cost of the MySQL database tier.
Which MySQL database choice satisfies these criteria?
- A. Amazon RDS for MySQL with read replica
- B. Amazon Aurora Serverless MySQL cluster
- C. Amazon Aurora MySQL cluster
- D. Amazon RDS for MySQL with Multi-AZ
Answer: B
Explanation:
Amazon Aurora Serverless v1 is a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. https://aws.amazon.com/rds/aurora/serverless/
NEW QUESTION # 31
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?
- A. When stopping the DB instance, the duration for stopping the DB instance should have been selected.
- B. When stopping the DB instance, the option to create a snapshot should have been selected.
- C. Stopped DB instances will automatically restart if the number of attempted connections exceeds the threshold set.
- D. Stopped DB instances will automatically restart if the instance is not manually started after 7 days.
Answer: D
Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/rds-stop-seven-days/
NEW QUESTION # 32
A company's Security department established new requirements that state internal users must connect to an existing Amazon RDS for SQL Server DB instance using their corporate Active Directory (AD) credentials. A Database Specialist must make the modifications needed to fulfill this requirement.
Which combination of actions should the Database Specialist take? (Choose three.)
- A. Stop the RDS SQL Server DB instance, modify it to use the directory for Windows authentication, and start it again. Create appropriate new logins.
- B. Disable Transparent Data Encryption (TDE) on the RDS SQL Server DB instance.
- C. Modify the RDS SQL Server DB instance to use the directory for Windows authentication. Create appropriate new logins.
- D. Use the AWS Management Console to create an AWS Managed Microsoft AD. Create a trust relationship with the corporate AD.
- E. Configure the AWS Managed Microsoft AD domain controller Security Group.
- F. Use the AWS Management Console to create an AD Connector. Create a trust relationship with the corporate AD.
Answer: C,D,E
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerWinAuth.html
NEW QUESTION # 33
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi- AZ DB instance. Tests were run on the database after work hours, which generated additional database logs.
The free storage of the RDS DB instance is low due to these additional logs.
What should the company do to address this space constraint issue?
- A. Create a ticket with AWS Support to have the logs deleted
- B. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to be deleted
- C. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs
- D. Log in to the host and run the rm $PGDATA/pg_logs/* command
Answer: B
Explanation:
Explanation
To set the retention period for system logs, use the rds.log_retention_period parameter. You can find rds.log_retention_period in the DB parameter group associated with your DB instance. The unit for this parameter is minutes. For example, a setting of 1,440 retains logs for one day. The default value is 4,320 (three days). The maximum value is 10,080 (seven days).
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_LogAccess.Concepts.PostgreSQL.ht
NEW QUESTION # 34
A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-
1.rds.amazonaws.com endpoint listening on port 3306. The company's Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logging a "could not connect to server: Connection times out" error message to Amazon CloudWatch Logs.
What is the cause of this error?
- A. The user name and password the application is using are incorrect.
- B. The user name and password are correct, but the user is not authorized to use the DB instance.
- C. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
- D. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.
Answer: C
NEW QUESTION # 35
A database expert is responsible for building a highly available online transaction processing (OLTP) solution that makes use of Amazon RDS for MySQL production databases. Disaster recovery criteria include a cross-regional deployment and an RPO and RTO of 5 and 30 minutes, respectively.
What should the database professional do to ensure that the database meets the criteria for high availability and disaster recovery?
- A. Use Multi-AZ and read replica deployments within a Region.
- B. Use Multi-AZ and deploy a read replica in a secondary Region.
- C. Use a Multi-AZ deployment in each Region.
- D. Use read replica deployments in all Availability Zones of the secondary Region.
Answer: B
NEW QUESTION # 36
A business is transferring a database from one AWS Region to another using an Amazon RDS for SQL Server DB instance. The organization wishes to keep database downtime to a minimum throughout the transfer.
Which migration strategy should the organization use for this cross-regional move?
- A. Add an RDS for SQL Server cross-Region read replica in the target Region. Once the replication is in sync, promote the read replica to master.
- B. Back up the source database using native backup to an Amazon S3 bucket in the same Region. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Region. Then restore the backup in the target Region.
- C. Back up the source database using native backup to an Amazon S3 bucket in the same Region. Then restore the backup in the target Region.
- D. Configure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target databases. Once the replication is in sync, terminate the DMS task.
Answer: D
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.XRgn.html With Amazon RDS, you can create a MariaDB, MySQL, Oracle, or PostgreSQL read replica in a different AWS Region from the source DB instance. Creating a cross-Region read replica isn't supported for SQL Server on Amazon RDS.
NEW QUESTION # 37
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.)
- A. Deploy two additional read replicas matching the existing replica DB instance size.
- B. Increase the instance size of the read replicas to the same size and class as the primary DB instance.
- C. Increase the instance size of the primary DB instance within the same instance class.
- D. Move the read replicas to the same Availability Zone as the primary DB instance.
- E. Migrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora Replicas.
Answer: B,E
Explanation:
https://www.quora.com/What-is-the-difference-between-a-RDS-read-replica-and-an-Amazon-Aurora-Read-replica
https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-high-replica-lag/
NEW QUESTION # 38
A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?
- A. Configure RDS Storage Auto Scaling.
- B. Modify the DB instance allocated storage to meet the forecasted requirements.
- C. Configure RDS instance Auto Scaling.
- D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
Answer: A
Explanation:
Explanation
If your workload is unpredictable, you can enable storage autoscaling for an Amazon RDS DB instance. With storage autoscaling enabled, when Amazon RDS detects that you are running out of free database space it automatically scales up your storage.
https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html#USER_PIOPS.A
NEW QUESTION # 39
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. The company recently conducted tests on the database after business hours, and the tests generated additional database logs. As a result, free storage of the DB instance is low and is expected to be exhausted in 2 days.
The company wants to recover the free storage that the additional logs consumed. The solution must not result in downtime for the database.
Which solution will meet these requirements?
- A. Modify the rds.log_retention_period parameter to 0. Reboot the DB instance to save the changes.
- B. Modify the rds.log_retention_period parameter to 1440. Wait up to 24 hours for database logs to be deleted.
- C. Modify the rds.log_retention_period parameter to 1440. Reboot the DB instance to save the changes.
- D. Modify the temp file_limit parameter to a smaller value to reclaim space on the DB instance.
Answer: B
Explanation:
Correct Answer: B
Explanation from Amazon documents:
The rds.log_retention_period parameter specifies how long your RDS for PostgreSQL DB instance keeps its log files. The default setting is 3 days (4,320 minutes), but you can set this value to anywhere from 1 day (1,440 minutes) to 7 days (10,080 minutes)123. By reducing the log retention period, you can free up storage space on your DB instance without affecting its availability or performance.
To modify the rds.log_retention_period parameter, you need to use a custom DB parameter group for your RDS for PostgreSQL instance. You can modify the parameter value using the AWS Management Console, the AWS CLI, or the RDS API1. The parameter change is applied immediately, but it may take up to 24 hours for the database logs to be deleted2. Therefore, you do not need to reboot the DB instance to save the changes or to reclaim the storage space.
Therefore, option B is the correct solution to meet the requirements. Option A is incorrect because setting the rds.log_retention_period parameter to 0 disables log retention and prevents you from viewing or downloading any database logs1. Rebooting the DB instance is also unnecessary and may cause downtime. Option C is incorrect because the temp file_limit parameter controls the maximum size of temporary files that a session can generate, not the size of database logs. Modifying this parameter will not reclaim any storage space on the DB instance. Option D is incorrect because rebooting the DB instance is not required to save the changes or to reclaim the storage space.
NEW QUESTION # 40
A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.
Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)
- A. Use policy conditions to restrict access to selective IP addresses
- B. Enable AWS CloudTrail logging and Enhanced Monitoring
- C. Use AccessList Controls policy type to restrict users for database instance deletion
- D. Allow all users to restore a database from a backup that will reduce the overall downtime to restore thedatabase
- E. Grant least privilege to groups, users, and roles
- F. Enable multi-factor authentication for sensitive operations to access sensitive resources and APIoperations
Answer: A,E,F
NEW QUESTION # 41
A large ecommerce company uses Amazon DynamoDB to handle the transactions on its web portal. Traffic patterns throughout the year are usually stable; however, a large event is planned. The company knows that traffic will increase by up to 10 times the normal load over the 3-day event. When sale prices are published during the event, traffic will spike rapidly.
How should a Database Specialist ensure DynamoDB can handle the increased traffic?
- A. Ensure the table is always provisioned to meet peak needs
- B. Preprovision additional capacity for the known peaks and then reduce the capacity after the event
- C. Allow burst capacity to handle the additional load
- D. Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic
Answer: B
Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-partition-key-design.html#bp-partition
"DynamoDB provides some flexibility in your per-partition throughput provisioning by providing burst capacity. Whenever you're not fully using a partition's throughput, DynamoDB reserves a portion of that unused capacity for later bursts of throughput to handle usage spikes. DynamoDB currently retains up to 5 minutes (300 seconds) of unused read and write capacity. During an occasional burst of read or write activity, these extra capacity units can be consumed quickly-even faster than the per-second provisioned throughput capacity that you've defined for your table. DynamoDB can also consume burst capacity for background maintenance and other tasks without prior notice. Note that these burst capacity details might change in the future."
NEW QUESTION # 42
A company is using an Amazon ElastiCache for Redis cluster to host its online shopping website. Shoppers receive the following error when the website's application queries the cluster:
Which solutions will resolve this memory issues with the LEAST amount of effort? (Choose three.)
- A. Test different values in the parameter group for the maxmemory-policy parameter to find the ideal value to use.
- B. Increase the TTL value for keys on the node.
- C. Increase the number of nodes.
- D. Reduce the TTL value for keys on the node.
- E. Monitor the EngineCPUUtilization Amazon CloudWatch metric. Create an AWS Lambda function to delete keys on nodes when a threshold is reached.
- F. Choose a larger node type.
Answer: A,D,F
Explanation:
Explanation
https://aws.amazon.com/premiumsupport/knowledge-center/oom-command-not-allowed-redis/
NEW QUESTION # 43
......
Get Perfect Results with Premium DBS-C01 Dumps Updated 325 Questions: https://getfreedumps.passreview.com/DBS-C01-exam-questions.html