最新 [2024年09月01日]Amazon DBS-C01試験練習でテストの素晴らしい結果を出そう
あなたのキャリアーを稼いで飛躍せよAmazon DBS-C01
Amazon DBS-C01 認定試験を受験するためには、データベース技術に関する最低2年の経験とAWSに関する最低1年の経験が必要です。認定試験は65の多肢選択問題と多重回答問題からなり、時間制限は170分です。試験は英語、日本語、韓国語、簡体字中国語で利用可能で、オンラインまたはテストセンターで受験できます。認定試験を成功裏に合格すると、候補者はAWSデータベース技術の専門知識を認定するデジタルバッジと証明書を受け取ります。この認定は3年間有効であり、再認定試験に合格するか、より高度なレベルの認定を取得することで更新できます。
AWS Certified Database - Specialty認定を受けるには、候補者は少なくともAWSとの2年間の経験を含む、データベース技術に関して5年以上の経験が必要です。さらに、データベース設計、正規化、セキュリティなどのデータベースの概念を熟知している必要があります。
質問 # 77
For 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. Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.
- B. Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.
- C. Ensure the vertices and edges are specified in different .csv files with proper header column formatting.
- D. Create an S3 VPC endpoint and issue an HTTP POST to the database's loader endpoint.
- E. 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.
- F. Use AWS DMS to move data from Amazon S3 to the Neptune Loader.
正解：C、D、E
解説：
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-optimize.html
質問 # 78
A banking company recently launched an Amazon RDS for MySQL DB instance as part of a proof-of-concept project. A database specialist has configured automated database snapshots. As a part of routine testing, the database specialist noticed one day that the automated database snapshot was not created.
Which of the following are possible reasons why the snapshot was not created? (Choose two.)
- A. A copy of the RDS automated snapshot for this DB instance is in progress within the same AWS Region.
- B. RDS event notifications have not been enabled.
- C. The RDS DB instance is in the STORAGE_FULL state.
- D. A copy of the RDS automated snapshot for this DB instance is in progress in a different AWS Region.
- E. The RDS maintenance window is not configured.
正解：A、C
解説：
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html
質問 # 79
A company is releasing a new mobile game featuring a team play mode. As a group of mobile device users play together, an item containing their statuses is updated in an Amazon DynamoDB table. Periodically, the other users' devices read the latest statuses of their teammates from the table using the BatchGetltemn operation.
Prior to launch, some testers submitted bug reports claiming that the status data they were seeing in the game was not up-to-date. The developers are unable to replicate this issue and have asked a database specialist for a recommendation.
Which recommendation would resolve this issue?
- A. Ensure the DynamoDB table is configured to be always consistent.
- B. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to true.
- C. Enable a stream on the DynamoDB table and subscribe each device to the stream to ensure all devices receive up-to-date status information.
- D. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to false.
正解：B
解説：
https://docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/API_BatchGetItem_v20111205.html By default, BatchGetItem performs eventually consistent reads on every table in the request. If you want strongly consistent reads instead, you can set ConsistentRead to true for any or all tables.
質問 # 80
A Database Specialist is working with a company to launch a new website built on Amazon Aurora with several Aurora Replicas. This new website will replace an on-premises website connected to a legacy relational database. Due to stability issues in the legacy database, the company would like to test the resiliency of Aurora.
Which action can the Database Specialist take to test the resiliency of the Aurora DB cluster?
- A. Remove the DB cluster endpoint to simulate a master DB instance failure
- B. Use Aurora fault injection to crash the master DB instance
- C. Stop the DB cluster and analyze how the website responds
- D. Use Aurora Backtrack to crash the DB cluster
正解：B
解説：
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.FaultInjectionQueries.html
"You can test the fault tolerance of your Amazon Aurora DB cluster by using fault injection queries. Fault injection queries are issued as SQL commands to an Amazon Aurora instance and they enable you to schedule a simulated occurrence of one of the following events: A crash of a writer or reader DB instance A failure of an Aurora Replica A disk failure Disk congestion When a fault injection query specifies a crash, it forces a crash of the Aurora DB instance. The other fault injection queries result in simulations of failure events, but don't cause the event to occur. When you submit a fault injection query, you also specify an amount of time for the failure event simulation to occur for."
質問 # 81
An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.
Which settings will meet this requirement? (Choose three.)
- A. Set DeletionProtection to True
- B. Set DeletionPolicy to Delete
- C. Set TerminationProtection to True
- D. Set DeleteAutomatedBackups to False
- E. Set DeletionPolicy to Retain
- F. Set MultiAZ to True
正解：A、C、E
質問 # 82
A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS. The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity. A Database Specialist wants to ensure that the changes made by the Application team will not change the Amazon RDS database resources already deployed.
Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)
- A. Review the stack drift before modifying the template
- B. Define the database resources in a nested stack
- C. Create and review a change set before applying it
- D. Export the database resources as stack outputs
- E. Set a stack policy for the database resources
正解：C、E
解説：
https://docs.amazonaws.cn/en_us/AWSCloudFormation/latest/UserGuide/best-practices.html#cfn-best-practices-changesets
質問 # 83
A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company's main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.
Which solution meets these requirements?
- A. Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
- B. Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replica in the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.
- C. Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the ap- northeast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cache application data from the replica to generate the dashboards.
- D. Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1 Region. Use Amazon QuickSight for displaying dashboard results.
正解：B
解説：
Explanation
https://aws.amazon.com/blogs/database/aurora-postgresql-disaster-recovery-solutions-using-amazon-aurora-glob
質問 # 84
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 Redshift
- C. Amazon ElastiCache
- D. Amazon Elasticsearch Service
- E. Amazon DynamoDB
正解：C、E
質問 # 85
A coffee machine manufacturer is equipping all of its coffee machines with 10T sensors. The 10T core application is writing measurements for each record to Amazon Timestream. The records have multiple dimensions and measures. The measures include multiple measure names and values.
An analysis application is running queries against the Timestream database and is focusing on data from the current week. A database specialist needs to optimize the query costs of the analysis application.
Which solution will meet these requirements?
- A. Avoid canceling any query after the query starts running.
- B. Ensure that queries contain whole records over the relevant time range.
- C. Use time range, measure name, and dimensions in the WHERE clause of the query.
- D. Implement exponential backoff in the application.
正解：C
解説：
Correct answer: B. Use time range, measure name, and dimensions in the WHERE Explanation from Amazon documents:
Amazon Timestream is a serverless time series database service that allows you to store and analyze time series data at any scale. To optimize the cost of queries, you should use the following best practices1:
Include only the measure and dimension names essential to query. Adding extraneous columns will increase data scans and therefore will also increase the query cost.
Include a time range in the WHERE clause of your query. For example, if you only need the last one hour of data in your dataset, include a time predicate such as time > ago (1h).
Include the measure names in the WHERE clause of the query when a query accesses a subset of measures in a table.
Option B follows these best practices, while option A does not. Option C is incorrect because canceling a query can save on cost if the query will not return the desired results1. Option D is irrelevant because exponential backoff is a technique to handle throttling errors, not to optimize query costs2.
質問 # 86
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. Preprovision additional capacity for the known peaks and then reduce the capacity after the event
- B. Allow burst capacity to handle the additional load
- C. Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic
- D. Ensure the table is always provisioned to meet peak needs
正解：A
解説：
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."
質問 # 87
A business's production database is hosted on a single-node Amazon RDS for MySQL DB instance. The database instance is hosted in a United States AWS Region.
A week before a significant sales event, a fresh database maintenance update is released. The maintenance update has been designated as necessary. The firm want to minimize the database instance's downtime and requests that a database expert make the database instance highly accessible until the sales event concludes.
Which solution will satisfy these criteria?
- A. Convert the DB instance into a Multi-AZ deployment. Apply the maintenance update.
- B. Create a read replica with the latest update. Initiate a failover before the sales event.
- C. Defer the maintenance update until the sales event is over.
- D. Create a read replica with the latest update. Transfer all read-only traffic to the read replica during the sales event.
正解：A
解説：
Explanation
https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/
質問 # 88
A company is launching a new Amazon RDS for MySQL Multi-AZ DB instance to be used as a data store for a custom-built application. After a series of tests with point-in-time recovery disabled, the company decides that it must have point-in-time recovery reenabled before using the DB instance to store production data.
What should a database specialist do so that point-in-time recovery can be successful?
- A. Set up a scheduled job to create manual DB instance snapshots.
- B. Modify the DB instance and enable audit logs to be pushed to Amazon CloudWatch Logs.
- C. Enable binary logging in the DB parameter group used by the DB instance.
- D. Modify the DB instance and configure a backup retention period
正解：D
解説：
You can restore a DB instance to a specific point in time (PITR), creating a new DB instance. To support PITR, your DB instances must have backup retention set to a nonzero value. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-backup-sqlserver.html
https://aws.amazon.com/blogs/database/setting-up-a-binlog-server-for-amazon-rds-mysql-and-mariadb-using-mariadb-maxscale/
"After you run the command, it's okay to enable backup retention on the RDS instance by using the AWS CLI or the console. Enabling backup retention also enables binary logging."
https://aws.amazon.com/blogs/storage/point-in-time-recovery-and-continuous-backup-for-amazon-rds-with-aws-backup/
質問 # 89
A company is running critical applications on AWS. Most of the application deployments use Amazon Aurora MySQL for the database stack. The company uses AWS CloudFormation to deploy the DB instances.
The company's application team recently implemented a CI/CD pipeline. A database engineer needs to integrate the database deployment CloudFormation stack with the newly built CllCD platform. Updates to the CloudFormation stack must not update existing production database resources.
Which CloudFormation stack policy action should the database engineer implement to meet these requirements?
- A. Use a Deny statement for the action on the production database resources.
- B. Use a Deny statement for the Update:Modify action on the production database resources.
- C. Use a Deny statement for the Update:Replace action on the production database resources.
- D. Use a Deny statement for the Update:Delete action on the production database resources.
正解：C
解説：
Explanation from Amazon documents:
A CloudFormation stack policy is a JSON document that defines the update actions that can be performed on designated resources in a CloudFormation stack. A stack policy can be used to prevent accidental updates or deletions of stack resources, such as a production database.
The Update:Replace action is an update action that replaces an existing resource with a new one during a stack update. This action can cause data loss or downtime for the resource. To prevent this action from affecting the production database resources, the database engineer should use a Deny statement for the Update:Replace action on the production database resources in the stack policy. This statement will override any Allow statements for the same action and resource, and protect the production database resources from being replaced during a stack update.
Therefore, option D is the correct stack policy action to meet the requirements. Option A is incorrect because the Update:Modify action is not a valid update action for a stack policy. The valid update actions are Update:Replace, Update:Skip, and Delete. Option B is incorrect because it does not specify a valid update action for the Deny statement. Option C is incorrect because the Update:Delete action is not a valid update action for a stack policy. The valid update actions are Update:Replace, Update:Skip, and Delete.
質問 # 90
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.)
- A. Encrypt the data with client-side encryption before transferring the data to Amazon RDS.
- B. Use AWS Database Migration Service (AWS DMS) to migrate from the on-premises source database to the RDS for SQL Server target database.
- C. Disable TDE. Create a database backup without encryption. Copy the backup to Amazon S3.
- D. Restore the backup to the RDS for SQL Server DB instance. Enable TDE for the RDS for SQL Server DB instance.
- E. 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.
正解：C、D
解説：
Explanation
https://aws.amazon.com/blogs/database/migrate-tde-enabled-sql-server-databases-to-amazon-rds-for-sql-server/
質問 # 91
A company has a reporting application that runs on an Amazon EC2 instance in an isolated developer account on AWS. The application needs to retrieve data during non-peak company hours from an Amazon Aurora PostgreSQL database that runs in the companys production account The companys security team requires that access to production resources complies with AWS best security practices A database administrator needs to provide the reporting application with access to the production database.
The company has already configured VPC peering between the production account and developer account The company has also updated the route tables in both accounts With the necessary entries to correctly set up VPC peering What must the database administrator do to finish providing connectivity to the reporting application?
- A. Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432_ Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on all TCP ports
- B. Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432. Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432.
- C. Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on all TCP ports. Add an inbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432_
- D. Add an outbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432. Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432.
正解：B
解説：
Explanation
The correct answer is A. Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432. Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432.
The explanation is as follows:
To allow the reporting application to access the production database, the database administrator needs to configure the security group rules for both the database and the EC2 instance. The security group rules must allow traffic between the peered VPCs on the port that the database uses, which is 5432 for PostgreSQL1.
Option A is correct because it adds an inbound rule to the database security group that allows access from the developer account VPC CIDR on port 5432. This means that the database can accept connections from the EC2 instance in the peered VPC. It also adds an outbound rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432. This means that the EC2 instance can initiate connections to the database in the peered VPC.
Option B is incorrect because it adds an outbound rule to the database security group, which is not necessary. The database does not need to initiate connections to the EC2 instance, only accept them. It also does not add an inbound rule to the EC2 security group, which is not required. The EC2 instance does not need to accept connections from the database, only initiate them.
Option C is incorrect because it adds an inbound rule to the database security group that allows access from the developer account VPC CIDR on all TCP ports. This is too permissive and violates the principle of least privilege2. It also adds an inbound rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432. This is unnecessary and does not help with connectivity.
Option D is incorrect because it adds an outbound rule to the EC2 security group that allows access to the production account VPC CIDR on all TCP ports. This is too permissive and violates the principle of least privilege2. It also does not add an outbound rule to the database security group, which is not needed.
References: 1: [Working with PostgreSQL and pgAdmin - Amazon Aurora] 2: [Security best practices in IAM
- AWS Identity and Access Management]
質問 # 92
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. Use the AWS Management Console to create an AWS Managed Microsoft AD. Create a trust relationship with the corporate AD.
- B. Modify the RDS SQL Server DB instance to use the directory for Windows authentication. Create appropriate new logins.
- C. Disable Transparent Data Encryption (TDE) on the RDS SQL Server DB instance.
- D. Stop the RDS SQL Server DB instance, modify it to use the directory for Windows authentication, and start it again. Create appropriate new logins.
- 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.
正解：A、B、E
解説：
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerWinAuth.html
質問 # 93
A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will enable connections logging.
Which combination of steps should the Database Specialist take to meet the logging and retention requirements? (Choose two.)
- A. Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180 days
- B. Update the log_connections parameter in the default parameter group
- C. Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to180 days
- D. Create a custom parameter group, update the log_connections parameter, and associate the parameterwith the DB instance
- E. Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file
正解：B、E
質問 # 94
On AWS, a business is developing a web application. The application needs that the database supports concurrent read and write activities in several AWS Regions. Additionally, the database must communicate data changes across Regions as they occur. The application must be highly available and have a latency of less than a few hundred milliseconds.
Which solution satisfies these criteria?
- A. Amazon DynamoDB global tables
- B. An Amazon Aurora global database
- C. An Amazon ElastiCache for Redis cluster with cluster mode enabled and multiple shards
- D. Amazon DynamoDB streams with AWS Lambda to replicate the data
正解：A
解説：
Aurora Global Databases provides a writer and a reader endpoints in the primary region but only a reader endpoints in other region. Although strongly consistent, it does not fulfill the requirements that "there are plenty of read / write activities" in all regions.
質問 # 95
A database specialist is designing the database for a software-as-a-service (SaaS) version of an employee information application. In the current architecture, the change history of employee records is stored in a single table in an Amazon RDS for Oracle database. Triggers on the employee table populate the history table with historical records.
This architecture has two major challenges. First, there is no way to guarantee that the records have not been changed in the history table. Second, queries on the history table are slow because of the large size of the table and the need to run the queries against a large subset of data in the table.
The database specialist must design a solution that prevents modification of the historical records. The solution also must maximize the speed of the queries.
Which solution will meet these requirements?
- A. Use Amazon Aurora PostgreSQL to store employee record history in a single table. Use Aurora Auto Scaling to provision more capacity.
- B. Write employee record history to Amazon Quantum Ledger Database (Amazon QLDB) for historical records and to an Amazon OpenSearch Service domain for queries.
- C. Build a solution that uses an Amazon Redshift cluster for historical records. Query the Redshift cluster directly as needed.
- D. Migrate the current solution to an Amazon DynamoDB table. Use DynamoDB Streams to keep track of changes. Use DynamoDB Accelerator (DAX) to improve query performance.
正解：B
解説：
Explanation from Amazon documents:
Amazon Quantum Ledger Database (Amazon QLDB) is a fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log of all your application changes.
Amazon QLDB tracks each and every application data change and maintains a complete and verifiable history of changes over time1. This makes it ideal for storing historical records that need to be tamper-proof and auditable. Amazon QLDB also supports PartiQL, a SQL-compatible query language that lets you query data using familiar SQL operators2.
Amazon OpenSearch Service (successor to Amazon Elasticsearch Service) is a fully managed service that makes it easy to deploy, operate, and scale OpenSearch, an open source search and analytics engine. Amazon OpenSearch Service lets you store, search, and analyze large volumes of data quickly and at low cost3. You can use Amazon OpenSearch Service to index and query your employee record history data stored in Amazon QLDB using the QLDB Streams feature. This way, you can leverage the powerful search and analytics capabilities of OpenSearch Service to run fast and flexible queries on your historical data.
Therefore, option B is the best solution that meets the requirements of preventing modification of the historical records and maximizing the speed of the queries. Option A is not suitable because DynamoDB is a key-value and document database that does not provide a ledger-like transaction log. Option C is not suitable because Aurora PostgreSQL is a relational database that does not guarantee immutability of the historical records.
Option D is not suitable because Redshift is a data warehouse that is optimized for analytical queries on large datasets, not for storing and querying individual records.
質問 # 96
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. Monitor the EngineCPUUtilization Amazon CloudWatch metric. Create an AWS Lambda function to delete keys on nodes when a threshold is reached.
- B. Reduce the TTL value for keys on the node.
- C. Test different values in the parameter group for the maxmemory-policy parameter to find the ideal value to use.
- D. Increase the TTL value for keys on the node.
- E. Increase the number of nodes.
- F. Choose a larger node type.
正解：B、C、F
解説：
Explanation
https://aws.amazon.com/premiumsupport/knowledge-center/oom-command-not-allowed-redis/
質問 # 97
A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made.
What should the database specialist do to meet these requirements? (Choose two.)
- A. Enable Enhanced Monitoring on the DB instance.
- B. Enable auditing of CONNECT and QUERY_DML events.
- C. Create an RDS event subscription to the audit event type.
- D. SSH to the DB instance and review the database logs.
- E. Publish the database logs to Amazon CloudWatch Logs.
正解：C、E
質問 # 98
Recently, an ecommerce business transferred one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition database instance. The corporation anticipates an increase in read traffic as a result of an approaching sale. To accommodate the projected read load, a database professional must establish a read replica of the database instance.
Which procedures should the database professional do prior to establishing the read replica? (Select two.)
- A. Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).
- B. Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
- C. Identify a potential downtime window and stop the application calls to the source DB instance.
- D. Modify the read replica parameter group setting and set the value to 1.
- E. Ensure that automatic backups are enabled for the source DB instance.
正解：B、E
解説：
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html
質問 # 99
A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon RDS events and determined a failover event occurred at that time. The failover process took around 15 seconds to complete.
What is the MOST likely cause of the 5-minute connection outage?
- A. After a database crash, Aurora needed to replay the redo log from the last database checkpoint
- B. The client-side application is caching the DNS data and its TTL is set too high
- C. There were no active Aurora Replicas in the Aurora DB cluster
- D. After failover, the Aurora DB cluster needs time to warm up before accepting client connections
正解：B
解説：
When your application tries to establish a connection after a failover, the new Aurora PostgreSQL writer will be a previous reader, which can be found using the Aurora read only endpoint before DNS updates have fully propagated. Setting the java DNS TTL to a low value helps cycle between reader nodes on subsequent connection attempts.
Amazon Aurora is designed to recover from a crash almost instantaneously and continue to serve your application data. Unlike other databases, after a crash Amazon Aurora does not need to replay the redo log from the last database checkpoint before making the database available for operations. Amazon Aurora performs crash recovery asynchronously on parallel threads, so your database is open and available immediately after a crash. Because the storage is organized in many small segments, each with its own redo log, the underlying storage can replay redo records on demand in parallel and asynchronously as part of a disk read after a crash. This approach reduces database restart times to less than 60 seconds in most cases
質問 # 100
......
正真正銘のベスト資料DBS-C01オンライン練習試験：https://www.jpntest.com/shiken/DBS-C01-mondaishu
365日更新し続けるDBS-C01最高の問題集はこちら：https://drive.google.com/open?id=1D_rWRAlExJzABMgradfHbVCSGURBYQ-M