AWS Certified Database Specialty-(DBS-C01)
The AWS Certified Database Specialty-(DBS-C01) were last updated on today.
- Viewing page 1 out of 68 pages.
- Viewing questions 1-5 out of 340 questions
- - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.and Azure
- - Trademarks, certification & product names are used for reference only and belong to Amazon.and Azure
Topic 1 - Exam A
A finance company migrated its 3 ׀¢׀’ on-premises PostgreSQL database to an Amazon Aurora PostgreSQL DB cluster. During a review after the migration, a database specialist discovers that the database is not encrypted at rest. The database must be encrypted at rest as soon as possible to meet security requirements. The database specialist must enable encryption for the DB cluster with minimal downtime. Which solution will meet these requirements?
- A Modify the unencrypted DB cluster using the AWS Management Console. Enable encryption and choose to apply the change immediately.
- B Take a snapshot of the unencrypted DB cluster and restore it to a new DB cluster with encryption enabled. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.
- C Create an encrypted Aurora Replica of the unencrypted DB cluster. Promote the Aurora Replica as the new master.
- D Create a new DB cluster with encryption enabled and use the pg_dump and pg_restore utilities to load data to the new DB cluster. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.
NOTE: To enable encryption for a new DB cluster, choose Enable encryption on the console. For information on creating a DB cluster. Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Overview.Encryption.html
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.)
- A 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.
- B Stream real-time data into Redshift temporary tables before loading the data into permanent tables.
- C 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.
- D For bulk inserts, use the parallel parameter in the COPY command to enable multi-threading.
- E Optimize analytics SQL queries to use sort keys.
- F Avoid using temporary tables in analytics SQL queries.
NOTE:
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?
- A Amazon RDS with cross-Region read replicas
- B Amazon DynamoDB global tables
- C Amazon Aurora global database
- D Amazon Athena and Amazon S3 with S3 Cross Region Replication
NOTE:
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?
- A 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.
- B 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.
- C 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.
- D Use Amazon CloudWatch Logs Insights to search and analyze the logs when the logs are automatically uploaded by the DB cluster.
NOTE: Reference: https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/AnalyzingLogData.html
A bank is using an Amazon RDS for MySQL DB instance in a proof of concept. A database specialist is evaluating automated database snapshots and cross- Region snapshot copies as - part of this proof of concept. After validating three automated snapshots successfully, the database specialist realizes that the fourth snapshot was not created. Which of the following are possible reasons why the snapshot was not created? (Choose two.)
- A A copy of the automated snapshot for this DB instance is in progress within the same AWS Region.
- B A copy of a manual snapshot for this DB instance is in progress for only certain databases within the DB instance.
- C The RDS maintenance window is not specified.
- D The DB instance is in the STORAGE_FULL state.
- E RDS event notifications have not been enabled.
NOTE: