{"id":8733,"date":"2020-01-15T04:58:46","date_gmt":"2020-01-15T04:58:46","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=8733"},"modified":"2021-11-13T11:39:56","modified_gmt":"2021-11-13T11:39:56","slug":"aws-interview-questions-and-answer-part-16","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/aws-interview-questions-and-answer-part-16\/","title":{"rendered":"AWS Interview Questions and Answer Part \u2013 16"},"content":{"rendered":"\n<p><strong>Elastic Block Storage is limited in size and won&#8217;t auto scale with your storage needs.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>False<\/li><li><strong>True (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>Compared to a relational database&#8217;s data model\u2026<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>A DynamoDB attribute is like a row, and item is like a column<\/li><li>None of these<\/li><li>A DynamoDB key is like a column, and item is like a row<\/li><li><strong>A DynamoDB attribute is like a column, and item is like a row (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>A local secondary index can be created at any time, unlike a global secondary index.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>True<\/li><li><strong>False  (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>You cannot use an Amazon-provided license for an Oracle Enterprise Edition.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>False<\/li><li><strong>True (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>What is an example of a native capability of DynamoDB?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>All of these (Ans)<\/strong><\/li><li>SSD storage<\/li><li>Multiple data consistency options<\/li><li>Built-in data replication<\/li><\/ul>\n\n\n\n<p><strong>What question does NOT factor into your decisions when creating a new RDS instance?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Number of manual snapshots you will take (Ans)<\/strong><\/li><li>Region to create the database in<\/li><li>How much storage you need<\/li><li>Which database engine to use<\/li><\/ul>\n\n\n\n<p><strong>Redshift customers have to pay data transfer costs when loading the warehouse.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>False (Ans)<\/strong><\/li><li>True<\/li><\/ul>\n\n\n\n<p><strong>Why should a read replica use the same (or better) instance class as the source database?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>None of these<\/li><li>Because instance size is immutable and can&#8217;t be changed later<\/li><li>To avoid falling behind on synchronization (Ans)<\/li><li>Because RDS requires it when configuring a read replica<\/li><\/ul>\n\n\n\n<p><strong>Why should you use multiple files in S3 to import data?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>So Redshift can allocate the biggest files to the largest nodes<\/li><li><strong>Get better throughput by putting all the node slices to work (Ans)<\/strong><\/li><li>All of these<\/li><li>The cost of importing data goes down<\/li><\/ul>\n\n\n\n<p><strong>Why would you add a read replica to an RDS database?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Have an alternate database to insert records<\/li><li><strong>Scale performance of a high traffic database (Ans)<\/strong><\/li><li>Establish an automatic failover database in case of AZ outage<\/li><\/ul>\n\n\n\n<p><strong>Which of the following are native Redshift capabilities?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Up to petabytes of storage<\/li><li>Encryption at rest<\/li><li>Parallel query processing<\/li><li><strong>All of these (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>Both query and scan requests support parallel execution via segments.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>False (Ans)<\/strong><\/li><li>True<\/li><\/ul>\n\n\n\n<p><strong>What is the name of the setting that controls placement of data among the nodes?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Sort key<\/li><li>Primary key<\/li><li><strong>Data distribution key (Ans)<\/strong><\/li><li>Index key<\/li><\/ul>\n\n\n\n<p><strong>What happens when you ask for an attribute that wasn&#8217;t projected into a local secondary index?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>DynamoDB throws an exception<\/li><li><strong>The data is retrieved from the source table (Ans)<\/strong><\/li><li>Empty data is returned<\/li><li>DynamoDB copies the data into the index and then returns it<\/li><\/ul>\n\n\n\n<p><strong>Which of the following are supported RDS database engines?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL<\/li><li><strong>All of these (Ans)<\/strong><\/li><li>Microsoft SQL Server<\/li><li>Oracle<\/li><\/ul>\n\n\n\n<p><strong>Which command lets you validate data without actually importing it?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>VALIDATE<\/li><li>SKIP<\/li><li>STAGE<\/li><li><strong>NOLOAD (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>Read replicas cannot be promoted to standalone RDS database instances.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>True<\/li><li><strong>False (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>Which of the following databases is based on PostgreSQL?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Amazon DynamoDB<\/li><li>Amazon RDS<\/li><li>All of these<\/li><li><strong>Amazon Redshift (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>Throughput units are set during table creation time and cannot be changed.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>True<\/li><li><strong>False (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>How does DynamoDB decide on the number of partitions to create for your table?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Based on the &#8220;partition count&#8221; parameter set during table creation<\/li><li>Based on throughput units chosen<\/li><li>Based on data storage<\/li><li><strong>Based on data storage or throughput units chosen (Ans)<\/strong><\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><\/li><\/ul>\n\n\n<div class=\"epyt-gallery\" data-currpage=\"1\" id=\"epyt_gallery_83758\"><figure class=\"wp-block-embed wp-block-embed-youtube is-type-video is-provider-youtube epyt-figure\"><div class=\"wp-block-embed__wrapper\"><iframe loading=\"lazy\"  id=\"_ytid_14246\"  width=\"760\" height=\"427\"  data-origwidth=\"760\" data-origheight=\"427\" src=\"https:\/\/www.youtube.com\/embed\/?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=1&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;disablekb=0&#038;\" class=\"__youtube_prefs__  no-lazyload\" title=\"YouTube player\"  data-epytgalleryid=\"epyt_gallery_83758\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><\/div><\/figure><div class=\"epyt-gallery-list\"><div>Sorry, there was a YouTube error.<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Elastic Block Storage is limited in size and won&#8217;t auto scale with your storage needs. False True (Ans) Compared to a relational database&#8217;s data model\u2026 A DynamoDB attribute is like a row, and item is like a column None of these A DynamoDB key is like a column, and item is like a row A&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[5633],"tags":[],"class_list":["post-8733","post","type-post","status-publish","format-standard","hentry","category-aws"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/8733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=8733"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/8733\/revisions"}],"predecessor-version":[{"id":25134,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/8733\/revisions\/25134"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=8733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=8733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=8733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}