AWS support engineer interview for database administrators

Free AWS Associate exam dumps . Enter your email address:

Delivered by FeedBurner

1) What is the difference between primary key and unique key?
Primary key uniquely identifies a row. Unique keys are created in columns that will the unique row values. Primary key is unique and not null however unique key can have null values
2) Why are you considering AWS while you have current job as DBA?
This is a very common interpersonal question. You can answer whatever you think of as the answer. But provide an answer that discusses advantage of cloud over on-perm systems. Also, mention that databases in future will be 100% hosted in cloud
3) Why AWS instead of oracle cloud or azure environment?
If your current database profile is oracle DBA, SQL Server DBA the companies that have designed, developed, marketed your databases have their properitor platform for hosting the databases in cloud. To choose AWS over the other vendors major reason is that AWS is a decade old firm , growing extremely fast, stable that is much needed for sustainability of enterprise businesses. They cant choose a vendor for price reasons and waste money on migration projects later
4) What is cloud computing?
This is a very common question that will be part of not only cloud dba but also other cloud support roles. Cloud computing in plain terms is migration of your data center to be taken care of by Amazon
5) What are the many different AWS services supporting databases?
AWS RDS the relational database service supports many databases like mysql, postgresql, oracle, sql server and many more. Amazon dynamodb is popular nosql database. Amazon aurora comes in mysql as well as postgressql flavors that is developed, currently heavily marketed by amazon
6) What is DMS?
The data migration service is a GUI from amazon that supports migration of current databases onto AWS cloud Aurora database. Interestingly feasibility , problems that could be encountered during migration including packages, objects that could be impacted post-upgrade will be listed while making use of DMS. This tool is used for migration of databases

Free AWS Associate exam dumps . Enter your email address:

Delivered by FeedBurner

AWS Certified Associate Exams On Sale



AWS certified developer – associate dumps

Free AWS Associate exam dumps . Enter your email address:

Delivered by FeedBurner

1. Your project makes use of dynamodb. Users purchase product. Your table has four columns on many different id namely user_id, products_id,department_id,order_id. There are lots of users in the system currently registered to test this product on trial basis. There are only 3 products to start with. Which one can be primary key?
a) user_id
b) product_id
c) order_id
d) department_id
Answer: a
Explanation : While designating primary key always note that there should be many to few relationships

2. Which operation in dynamodb lets you support atomic counters?
a) IncrementItem
b) MoreItem
c) UpdateItem
d) UploadItem
Answer: c
3) You are making use of dynamodb for your products table. The application is so busy that provisioned throughput settings made has been exceeded. What will happen next?
a) It is subject to failure
b) table needs to be recreated
c) It is subject to request throttling
d) None of the above
Answer: c
4) While making use of dynamodb you have chosen provisioned throughput settings. Do you commit to pay one-time fees well in advance?
a) Yes
b) No
Answer: b
5) You have reserved capacity in dynamodb. Do you need to pay one-time fee well in advance?
a) Yes
b) No
Answer: a
6) You newly created an IAM user in AWS. What is the default level of access granted to this newly created IAM user?
a) All access
b) No access
c) Partial access
d) Role based access
Answer: b
7) You have hosted your website in S3. You have uploaded index.html. You get 403 forbidden error. What is the reasom?
a) index.ht l is corrupt
b) index.html cant function without hello.html
c) index.html should be given proper access permission to fix the issue
d) None of the above
Answer: c
8) Your project makes use of S3 to store file. If you attempt to write a new key to S3, you are able to retrieve any object immediately afterwards. Also, any newly created object or files are visible immediately, without any delay. What is the reason behind this?
a) S3 buckets in all Regions provide read-after-write consistency for PUTS of new objects
b) S3 buckets in all Regions provide eventual consistency for PUTS of new objects
c) S3 buckets in all Regions provide write-after-write consistency for PUTS of new objects
d) S3 buckets in all Regions provide write-after-read consistency for PUTS of new objects
Answer: a
9) Do amazon S3 buckets in usa regions alone provide eventual consistency for overwrite PUTS and DELETES?
a) Yes
b) No
Answer: b
Explanation: This is partially true. As per Amazon S3 documentation eventual consistency for overwrite PUTS and DELETES is available in all regions

Free AWS Associate exam dumps . Enter your email address:

Delivered by FeedBurner

AWS certified sysops administrator free practice exam

Free AWS Associate exam dumps . Enter your email address:

Delivered by FeedBurner

1) What are the different types of EMR nodes?
a) core nodes
b) task nodes
c) block nodes
d) map nodes
Answer: a,b
2) You have bigdata interactive analysis project. Can you make use of spark?
a) Yes
b) No
Answer: b
3) Can you control the encryption keys and cryptographic operations performed by the Hardware security module using cloudhsM?
a) Yes
b) No
Answer: a
4) Is data in-transit between nodes is encrypted in AWS hadoop environment?
a) yes using hadoop encrypted shuffle
b) yes using cloudHSM
c) Yes using on-perm HSM
d) None
Answer: a
5) IS it true that you can have read replicas of read replicas?
a) true
b) false
Answer: a
6) You are working in business continuity project typically disaster recovery configuration design. Do you know what does RTO mean?
a) Recovery Time Objective
b) Read Time objective
c) Remote time objective
d) Redo time objective
Answer: a
7) You project makes use of mysql, php application. You have configure read replicas. What is the maximum number of read replicas that you can have in place?
a) 1
b) 3
c) 5
d) 7
Answer : c
8) You have configured read replicas. Can read replica’s have multiple availability zone for redundancy?
a) Yes
b) No
Answer: b
9) What does ICMP protocol translate to?
a) Information Control Message Protocol
b) Internet Control Message Protocol
c) Internal Control Message Protocol
d) Intuit Control Message Protocol
Answer : b
10) Which ELB metric does provide details on count of the total number of requests that are queued for a registered instance?
a) SurgeQueueLength
b) SetQueueLength
c) SumQueueLength
d) PendingQueueLength
Answer : a
11) You have been asked to copy amazon machine image across regions? Can you accomplish that?
a) Yes
b) No
Answer: a
Explanation: It is possible to copy AMI within as well as across AWS region. This is possible using AWS management console, AWS CLI or SDKs
12) You are utilizing tools like AWS management console to copy AMI across regions. Which action is internally made use of for this purpose?
a) CopyImage
b) MoveImage
c) MigrateImage
d) DumpImage
Answer: a
13) What types of AMI’s can be copied as part of CopyImage action?
a) EBS-backed AMI’s
b) instance store-backed AMI’s
c) Both a and b
d) None of the above
Answer: c
14) You have an AMI with encrypted snapshot. Will you be able to copy that using CopyImage action?
a) Yes
b) No
Answer: a
15) What are the virtualization types supported by Linux AMIs?
a) paravirtual
b) hardware virtual machine
c) software virtual machine
d) Firmware virtual machine
Answer: a,b
16) You have a HVM. How will you boot this AMI?
a) Executing the master boot record of the root block device of the image
b) Executing the master boot record of the EBS
c) Both a and b
d) None of the above
Answer: a
17) You are connecting to AWS using AWS CLI. For this do you need to create an IAM user?
a) Yes
b) No
Answer : a
18) You create an amazon S3 bucket. You upload a file called file1. Upload second file called file2. Now, you enable versioning. You upload file1 and file2 again. What will be the version id of file1 and file2 uploaded in first attempt before versioning is enabled?
a) zero
b) one
c) null
d) two
Answer : c
Explanation : An object uploaded prior to versioning will have version id as null
19) Does amazon S3 support SOAP?
a) Yes
b) No
Answer : b
Explanation : SOAP support is available over https. It is not available over http also amazon s3 new features dont support SOAP
20) You are trying to create a new bucket in amazon S3 and end up getting 409 conflict error. What is the reason behind this?
a) You dont have access permissions to create bucket
b) You dont have space allocated to create buckets
c) Bucket name already exists
d) Baddigest owing to wrong specification of MD-5
Answer: c
21) What is the best practice recommendation while making use of IAM role?
a) Create an IAM role that has specific access to AWS service. Grant access to the specified AWS service via the role
b) Grant access to service directly
c) Create IAM role for users
d) None of the above
Answer: a
22) How does amazon elastic cache improve system performance?
a) Information retrieved from in-memory system instead of disk-based traditional systems
b) Information retrieved from SSD
c) Information retrieved from flash drive
d) Information retrieved from RAID
Answer: a
23) You are in process of creating AMI. Which API call is internally triggered during this process?
a) CreateImage
b) RegisterImage
c) ami-store-image
d) ami-deploy image
Answer: b
24) You have been asked to configure an access policy that allows anonymous access to a message queue. How will you accomplish this?
a) via AWS CLI
b) Via IAM policies
c) Via roles
d) None of the above
Answer: b
25) You are making using of AWs simple queue service. How many message queues can you create in SQS?
a) 200
b) 2000
c) unlimited
d) 2
Answer: c
Explanation: There is no limited on the number of message queues that can be created in SQS
26) What is the maximum visibility timeout in SQS?
a) 24 hours
b) 36 hours
c) 12 hours
d) 72 hours
Answer: c
Explanation: Maximum visibility timeout for amazon SQS message is 12 hours

Free AWS Associate exam dumps . Enter your email address:

Delivered by FeedBurner