A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A database
specialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Server
backup file is approximately 120 GB in size. The application can be down for an extended period of time to complete the
migration. Connectivity between the onpremises environment and AWS can be initiated from on-premises only.
How can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?
B
Explanation:
Reference: https://www.sqlshack.com/aws-rds-sql-server-migration-using-native-backups/
A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas
for a highly intensive, business-critical application. The Aurora DB cluster has one medium-sized primary instance, one
large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.
In the event of a primary failure, what will occur?
A
Explanation:
Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-ug.pdf
A company is going through a security audit. The audit team has identified cleartext master user password in the AWS
CloudFormation templates for Amazon RDS for MySQL DB instances. The audit team has flagged this as a security risk to
the database team.
What should a database specialist do to mitigate this risk?
C
None
A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple
database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following
error message from Aurora:
ERROR: cloud not write block 7507718 of temporary file: No space left on device
What is the cause of this error and what should the Database Specialist do to resolve this issue?
C
Explanation:
Reference: https://serverfault.com/questions/109828/how-can-i-tune-postgres-to-avoid-this-error
A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most
recent minor version available. Noticing that there is a new minor version available, the database specialist has issues an
AWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the Aurora
DB cluster indicates that no update to the Aurora version has been made.
What might account for this? (Choose two.)
C D
None
A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains
some tables with sensitive data. A Database Specialist needs to control the access privileges at the table level.
How can the Database Specialist meet these requirements?
C
Explanation:
Reference: https://aws.amazon.com/blogs/database/managing-postgresql-users-and-roles/
A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system.
New compliance requirements specify that the database must be encrypted at rest.
Which action will meet these requirements?
C
Explanation:
Reference: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html
An ecommerce company uses Amazon DynamoDB as the backend for its payments system. A new regulation requires the
company to log all data access requests for financial audits. For this purpose, the company plans to use AWS logging and
save logs to Amazon S3 How can a database specialist activate logging on the database?
D
Explanation:
Reference: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/best-practices-security-detective.html
The Development team recently executed a database script containing several data definition language (DDL) and data
manipulation language (DML) statements on an Amazon Aurora MySQL DB cluster. The release accidentally deleted
thousands of rows from an important table and broke some application functionality. This was discovered 4 hours after the
release. Upon investigation, a Database Specialist tracked the issue to a DELETE command in the script with an incorrect
WHERE clause filtering the wrong set of rows.
The Aurora DB cluster has Backtrack enabled with an 8-hour backtrack window. The Database Administrator also took a
manual snapshot of the DB cluster before the release started. The database needs to be returned to the correct state as
quickly as possible to resume full application functionality. Data loss must be minimal. How can the Database Specialist
accomplish this?
D
None
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database,
including database shutdown, deletion, creation, and backup.
The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these
requirements. The data could be used by other systems within the company.
Which solution will meet these requirements with minimal effort?
C
None
An ecommerce company recently migrated one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise
Edition DB instance. The company expects a spike in read traffic due to an upcoming sale. A database specialist must
create a read replica of the DB instance to serve the anticipated read traffic.
Which actions should the database specialist take before creating the read replica? (Choose two.)
B D
None
The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A
Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the
Security team to use for monitoring and alerting. The Security team is required to perform real-time alerting and monitoring
outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution. Which approach will
meet these requirements?
B
Explanation:
Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-ug.pdf (525)
A company uses Amazon Aurora MySQL as the primary database engine for many of its applications. A database specialist
must create a dashboard to provide the company with information about user connections to databases. According to
compliance requirements, the company must retain all connection logs for at least 7 years.
Which solution will meet these requirements MOST cost-effectively?
C
Explanation:
Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/DBActivityStreams.html
A database specialist has a fleet of Amazon RDS DB instances that use the default DB parameter group. The database
specialist needs to associate a custom parameter group with some of the DB instances.
After the database specialist makes this change, when will the instances be assigned to this new parameter group?
C
Explanation:
To apply the latest parameter changes to that DB instance, manually reboot the DB instance.
Reference: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html
A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table uses
provisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has
restored the latest backup to a new table.
To prepare the new table with identical settings, which steps should be performed? (Choose two.)
A E
Explanation:
Reference:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.ReadWriteCapacityMode.html