AWS Databases - AWS Certified Database
Specialty UPDATED ACTUAL Questions
and CORRECT Answers
What does it mean to be a database specialist? - CORRECT ANSWER✔✔- 1) Know what
database to use in a given scenario.
2) Know how to use that database, requiring both breadth and depth.
3) Breadth of Knowledge allows you to choose the best technology.
4) Depth of knowledge allows you to use that database in the best possible way. Allowing
you to set up secure and robust systems, Managed tasks, geographical restrictions, data size
constraints
5) Knowing what not to use in certain use cases
What are the database design constraints and requirements? - CORRECT ANSWER✔✔- 1)
Time - Knowing the time constraints and requirements - query performance SLA,
Backup/Restore, Uptime SLAs
2) Cost - components, incremental per unit, allocation of costs to which users, understanding
incremental resource costs. Accounting for costs and providing appropriate audit data is also
important, particularly in multitenant situations where you need to allocate cost back to
different users of your application. Cost and performance are closely tied together, and being
able to define that relationship helps you understand the incremental cost for adding
resources to boost performance, as well as the incremental cost for adding more data to your
database.
3) Security - encryption, credentials, access control, encryption keys. Security constraints are
nonnegotiable. Knowing what is and is not supported for your database can help you avoid a
partial implementation that has to be scrapped because the proper security wasn't considered
from the beginning.
Encryption is built into some services, while others need to be configured to enable that
feature. You'll also have different options when it comes to encryption keys and access
policies, all of which can affect the other constraints you're working with.
4) Complexity - ease of implementation and maintenance.
In meeting the other constraints, how complex is your solution? Is there anything you can do
to simplify the design or the number of services involved in your solution? For example,
,some backup operations can involve additional AWS services, while others happen
automatically within the database service itself. You may be able to increase performance, but
it could add a few more layers of complexity to your database implementation.
What is data management tasks? - CORRECT ANSWER✔✔- 1) Data ingestion - getting
data into the target system is a major task. Understand options, tools and constraints available
for the particular database setup. Refactoring is a database is a major task.
2) Backup/restore - major operational component and each service has options. Knowing the
backup requirements, is it a scheduled or manual backup. Should the backups be encrypted or
plain text?
How much time do you have for Backup and Restore? Can it be done with the database
online, or do you have to take the database offline? Having the proper data protection in place
can make or break a business when disaster strikes, so getting Backup and Restore set up
right is one of the most important tasks of your database implementation.
3) Automation - Consistent, reliable automation can help reduce the chance of introducing
errors into your solution when performing data management tasks manually. Other AWS
services, as well as native and third‑party tools, are available to help you automate data
management tasks. Data management decisions often affect the performance, cost, and
complexity of your solution. Be aware of how data management can help you bring those
constraints into the proper balance for your implementation.
The AWS Certified Database ‑ Specialty exam separates the content into the following five
domains: - CORRECT ANSWER✔✔- 1) workload‑specific database design
2) deployment and migration
3) management and operations
4) monitoring and troubleshooting
5) database security
What are the objectives of workload specific database design domain? - CORRECT
ANSWER✔✔- Select appropriate database services for specific types of data and workloads,
Determine strategies for disaster recovery and high availability.
Design database solutions for performance, compliance, and scalability.
Compare the costs of database solutions. These objectives get into knowing everything about
everything in order to select the appropriate database service or services to use based on the
, type of data involved and other implementation requirements, such as performance,
compliance, scalability, and cost. These objectives will help you know the breadth of services
and their different capabilities so you can design the best possible solution.
What are the objectives of deployment and migration domain? - CORRECT ANSWER✔✔-
This domain covers the following objectives: automate database solution deployments,
determine data preparation and migration strategies, execute and validate data migration.
Automation is an important way to reduce deployment time, increase repeatability, and
eliminate mistakes as you deploy database solutions. Using tools like CloudFormation can
help you develop robust automation with AWS database deployments. As systems first move
to the cloud or evolve within the cloud, you'll find that you need to perform a fair amount of
data preparation, migration, and validation, so understanding best practices and available
tools for those tasks is an important part of being a database specialist.
What are the objectives of management and operations domain? - CORRECT ANSWER✔✔-
This domain is all about keeping things up and running, as well as having the appropriate
backup and restore strategies in place when failures occur. Objectives for this domain are:
determine maintenance tasks and processes, determine backup and restore strategies, manage
the operational environment of a database solution.
What are the objectives of monitoring and troubleshooting domain? - CORRECT
ANSWER✔✔- This domain has the following objectives: determine monitoring and alerting
strategies, troubleshoot and resolve common database issues, optimize database performance.
Monitoring is a key part of your database solution. It's what allows you to measure
performance, spot slowdowns and anomalies, and alert the appropriate resources when things
go wrong. The objectives for this domain will help you be aware of common issues for each
database service, how to solve those issues, and different options for monitoring, alerting, and
optimization.
What are the objectives of database security domain? - CORRECT ANSWER✔✔- Security
needs to be built into your design and is too important to simply be an afterthought, thrown
together after everything else is working. The security objectives cover several areas,
including encrypt data at rest and in transit, evaluate auditing solutions, determine access
control and authentication mechanisms, recognize potential security vulnerabilities within
database solutions. Different database services have different options for encryption, auditing,
and access control, so you'll need to be aware of your options in order to meet any specific
security requirements you may have. You can use AWS databases to implement solutions that
are compliant with several financial, privacy, and government standards. Cloud does not
equal less secure. Another component of security is monitoring and detecting potential threats
and vulnerabilities, and AWS has several tools to make that easier for you.
Specialty UPDATED ACTUAL Questions
and CORRECT Answers
What does it mean to be a database specialist? - CORRECT ANSWER✔✔- 1) Know what
database to use in a given scenario.
2) Know how to use that database, requiring both breadth and depth.
3) Breadth of Knowledge allows you to choose the best technology.
4) Depth of knowledge allows you to use that database in the best possible way. Allowing
you to set up secure and robust systems, Managed tasks, geographical restrictions, data size
constraints
5) Knowing what not to use in certain use cases
What are the database design constraints and requirements? - CORRECT ANSWER✔✔- 1)
Time - Knowing the time constraints and requirements - query performance SLA,
Backup/Restore, Uptime SLAs
2) Cost - components, incremental per unit, allocation of costs to which users, understanding
incremental resource costs. Accounting for costs and providing appropriate audit data is also
important, particularly in multitenant situations where you need to allocate cost back to
different users of your application. Cost and performance are closely tied together, and being
able to define that relationship helps you understand the incremental cost for adding
resources to boost performance, as well as the incremental cost for adding more data to your
database.
3) Security - encryption, credentials, access control, encryption keys. Security constraints are
nonnegotiable. Knowing what is and is not supported for your database can help you avoid a
partial implementation that has to be scrapped because the proper security wasn't considered
from the beginning.
Encryption is built into some services, while others need to be configured to enable that
feature. You'll also have different options when it comes to encryption keys and access
policies, all of which can affect the other constraints you're working with.
4) Complexity - ease of implementation and maintenance.
In meeting the other constraints, how complex is your solution? Is there anything you can do
to simplify the design or the number of services involved in your solution? For example,
,some backup operations can involve additional AWS services, while others happen
automatically within the database service itself. You may be able to increase performance, but
it could add a few more layers of complexity to your database implementation.
What is data management tasks? - CORRECT ANSWER✔✔- 1) Data ingestion - getting
data into the target system is a major task. Understand options, tools and constraints available
for the particular database setup. Refactoring is a database is a major task.
2) Backup/restore - major operational component and each service has options. Knowing the
backup requirements, is it a scheduled or manual backup. Should the backups be encrypted or
plain text?
How much time do you have for Backup and Restore? Can it be done with the database
online, or do you have to take the database offline? Having the proper data protection in place
can make or break a business when disaster strikes, so getting Backup and Restore set up
right is one of the most important tasks of your database implementation.
3) Automation - Consistent, reliable automation can help reduce the chance of introducing
errors into your solution when performing data management tasks manually. Other AWS
services, as well as native and third‑party tools, are available to help you automate data
management tasks. Data management decisions often affect the performance, cost, and
complexity of your solution. Be aware of how data management can help you bring those
constraints into the proper balance for your implementation.
The AWS Certified Database ‑ Specialty exam separates the content into the following five
domains: - CORRECT ANSWER✔✔- 1) workload‑specific database design
2) deployment and migration
3) management and operations
4) monitoring and troubleshooting
5) database security
What are the objectives of workload specific database design domain? - CORRECT
ANSWER✔✔- Select appropriate database services for specific types of data and workloads,
Determine strategies for disaster recovery and high availability.
Design database solutions for performance, compliance, and scalability.
Compare the costs of database solutions. These objectives get into knowing everything about
everything in order to select the appropriate database service or services to use based on the
, type of data involved and other implementation requirements, such as performance,
compliance, scalability, and cost. These objectives will help you know the breadth of services
and their different capabilities so you can design the best possible solution.
What are the objectives of deployment and migration domain? - CORRECT ANSWER✔✔-
This domain covers the following objectives: automate database solution deployments,
determine data preparation and migration strategies, execute and validate data migration.
Automation is an important way to reduce deployment time, increase repeatability, and
eliminate mistakes as you deploy database solutions. Using tools like CloudFormation can
help you develop robust automation with AWS database deployments. As systems first move
to the cloud or evolve within the cloud, you'll find that you need to perform a fair amount of
data preparation, migration, and validation, so understanding best practices and available
tools for those tasks is an important part of being a database specialist.
What are the objectives of management and operations domain? - CORRECT ANSWER✔✔-
This domain is all about keeping things up and running, as well as having the appropriate
backup and restore strategies in place when failures occur. Objectives for this domain are:
determine maintenance tasks and processes, determine backup and restore strategies, manage
the operational environment of a database solution.
What are the objectives of monitoring and troubleshooting domain? - CORRECT
ANSWER✔✔- This domain has the following objectives: determine monitoring and alerting
strategies, troubleshoot and resolve common database issues, optimize database performance.
Monitoring is a key part of your database solution. It's what allows you to measure
performance, spot slowdowns and anomalies, and alert the appropriate resources when things
go wrong. The objectives for this domain will help you be aware of common issues for each
database service, how to solve those issues, and different options for monitoring, alerting, and
optimization.
What are the objectives of database security domain? - CORRECT ANSWER✔✔- Security
needs to be built into your design and is too important to simply be an afterthought, thrown
together after everything else is working. The security objectives cover several areas,
including encrypt data at rest and in transit, evaluate auditing solutions, determine access
control and authentication mechanisms, recognize potential security vulnerabilities within
database solutions. Different database services have different options for encryption, auditing,
and access control, so you'll need to be aware of your options in order to meet any specific
security requirements you may have. You can use AWS databases to implement solutions that
are compliant with several financial, privacy, and government standards. Cloud does not
equal less secure. Another component of security is monitoring and detecting potential threats
and vulnerabilities, and AWS has several tools to make that easier for you.
