Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 60 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 60
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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. CONNECT
B. QUERY_DCL
C. QUERY_DDL
D. QUERY_DML
E. TABLE
F. QUERY

Show Suggested Answer

Suggested Answer: ABC 🗳️

by alwaysAstudent at Nov. 9, 2021, 4:33 a.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

Submit Cancel

alwaysAstudent

Highly Voted 3 years, 7 months ago

Answer A,B,C Connect - logins / DCL - authorizations (grant,revoke), DDL - schema updates

upvoted 15 times

johnconnor

3 years, 6 months ago

you are right

upvoted 1 times

...

user0001

3 years, 3 months ago

B is wrong , they are not asking for grant and revoke

upvoted 1 times

jthuma

2 years, 5 months ago

I think they are...Grant Revoke are permission statements.

upvoted 2 times

...

Pranava_GCP

Most Recent 1 year, 9 months ago

Selected Answer: ABC

A. CONNECT B. QUERY_DCL C. QUERY_DDL

upvoted 2 times

...

IhorK

1 year, 10 months ago

Selected Answer: ABC

- CONNECT – Logs both successful and failed connections and also disconnections. This event includes user information. - QUERY_DCL – Similar to the QUERY event, but returns only data control language (DCL) queries (GRANT, REVOKE, and so on). - QUERY_DDL – Similar to the QUERY event, but returns only data definition language (DDL) queries (CREATE, ALTER, and so on). https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Auditing.html

upvoted 3 times

...

ninjalight25

2 years, 3 months ago

Selected Answer: ABD

The events that need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements are: A. CONNECT - to capture all log ins and log outs. B. QUERY_DDL - to capture permission changes and database schema changes. D. QUERY_DML - to capture data manipulation operations such as INSERT, UPDATE and DELETE.

upvoted 1 times

Isio05

1 year, 10 months ago

They're not asking about changes in data, thus DML is not needed. Instead DCL is required to track permission changes.

upvoted 1 times

...

novice_expert

3 years, 1 month ago

Selected Answer: ABC

A. CONNECT (for log ins and log outs, unsuccessful logins) B. QUERY_DCL (for grants - authorization modifications) C. QUERY_DDL (for schema changes) x D. QUERY_DML x E. TABLE x F. QUERY

upvoted 4 times

...