ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 166 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 166
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company is migrating an IBM Informix database to a Multi-AZ deployment of Amazon RDS for SQL Server with Always On Availability Groups (AGs). SQL
Server Agent jobs on the Always On AG listener run at 5-minute intervals to synchronize data between the Informix database and the SQL Server database. Users experience hours of stale data after a successful failover to the secondary node with minimal latency.
What should a database specialist do to ensure that users see recent data after a failover?

  • A. Set TTL to less than 30 seconds for cached DNS values on the Always On AG listener.
  • B. Break up large transactions into multiple smaller transactions that complete in less than 5 minutes.
  • C. Set the databases on the secondary node to read-only mode.
  • D. Create the SQL Server Agent jobs on the secondary node from a script when the secondary node takes over after a failure.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by grekh001 at Dec. 2, 2021, 3:25 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
2025flakyt
Highly Voted 3 years, 4 months ago
A is the correct answer The question is how to refresh stale data
upvoted 13 times
...
chen0305_099
Most Recent 1 year, 8 months ago
Selected Answer: A
AAAAAAA
upvoted 1 times
...
marcelodba
1 year, 8 months ago
Selected Answer: D
A is wrong, MultiSubnetfailover is not the issue here.
upvoted 1 times
...
khun
2 years, 4 months ago
A. correct D. is obsolete. Amazon RDS for SQL Server now supports SQL Server Agent job replication Posted On: Apr 7, 2022 Amazon RDS for SQL Server now supports SQL Server Agent job replication. With this new feature, SQL Server Agent jobs created, modified, or deleted on the primary instance will be automatically synchronized to the secondary instance in a Multi-AZ configuration.
upvoted 3 times
...
Sab
2 years, 4 months ago
Selected Answer: A
A SQL Agent jobs can be replicated by turning on SQL Server Agent job replication EXECUTE msdb.dbo.rds_set_system_database_sync_objects @object_types = 'SQLAgentJob'; https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html
upvoted 4 times
...
rags1482
2 years, 6 months ago
Question prepared before the Job replication feature it seems, so now Answer D is no longer valid, and it should be A. https://aws.amazon.com/about-aws/whats-new/2022/04/amazon-rds-sql-server-sql-agent-job-replication/
upvoted 2 times
...
kush_sumit
2 years, 10 months ago
Selected Answer: D
C is wrong due to You can't configure the secondary DB instance to accept database read activity. Link: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html Section: Microsoft SQL Server Multi-AZ deployment limitations, notes, and recommendations
upvoted 1 times
...
kush_sumit
2 years, 10 months ago
D is correct answer C is wrong due to You can't configure the secondary DB instance to accept database read activity. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html Microsoft SQL Server Multi-AZ deployment limitations, notes, and recommendations:
upvoted 1 times
...
sachin
2 years, 10 months ago
D is the answer as JOB replication needs to be enabled explicitly.
upvoted 1 times
...
elf78
2 years, 10 months ago
Selected Answer: A
It's about refreshing stale data. @Jusfunda's comment has the correct link
upvoted 3 times
...
Jusfunda
2 years, 11 months ago
Selected Answer: A
Answer is A according to this link. https://docs.aws.amazon.com/prescriptive-guidance/latest/sql-server-ec2-best-practices/configure-availability-groups.html#:~:text=Set%20HostRecordTTL%20to%2060%20or%20less%20when%20using%20Always%20On%20availability%20groups
upvoted 3 times
...
novice_expert
3 years ago
Selected Answer: D
If you have SQL Server Agent jobs, recreate them on the secondary. Create the jobs first in the original primary, then fail over, and create the same jobs in the new primary.
upvoted 1 times
...
Shunpin
3 years, 4 months ago
Selected Answer: D
As grek mentioned URL.
upvoted 3 times
...
jove
3 years, 4 months ago
Selected Answer: D
I think the correct answer is D.. The SQL Server Agent jobs are used to synchronize data between the Informix and SQL Server databases and without those being created on secondary node the data won't be synchronized.
upvoted 3 times
user0001
3 years, 2 months ago
answer is D A is Wrong because it is more than 30 seconds , AG does not replicate agent on databases
upvoted 1 times
...
...
grekh001
3 years, 4 months ago
I think D https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html If you have SQL Server Agent jobs, recreate them on the secondary. You do so because these jobs are stored in the msdb database, and you can't replicate this database by using Database Mirroring (DBM) or Always On Availability Groups (AGs). Create the jobs first in the original primary, then fail over, and create the same jobs in the new primary.
upvoted 3 times
sachin
2 years, 10 months ago
This is mentioned in the URL you have shared above that JOB are replicated In Multi-AZ deployments, SQL Server Agent jobs are replicated from the primary host to the secondary host when the job replication feature is turned on. For more information, see Turning on SQL Server Agent job replication.
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago