{"id":8966,"date":"2020-01-18T03:12:12","date_gmt":"2020-01-18T03:12:12","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=8966"},"modified":"2021-11-13T10:44:07","modified_gmt":"2021-11-13T10:44:07","slug":"aws-interview-questions-and-answer-part-24","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/aws-interview-questions-and-answer-part-24\/","title":{"rendered":"AWS Interview Questions and Answer Part \u2013 24"},"content":{"rendered":"\n<p><strong>Database clients can connect to Redshift using ODBC and JDBC drivers for Postgres.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>True (Ans)<\/strong><\/li><li>False<\/li><\/ul>\n\n\n\n<p><strong>Cloudera Impala is included on EMR clusters by default.<\/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>EC2 stands for:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>External Cloud Connectivity<\/li><li><strong>Elastic Compute Cloud (Ans)<\/strong><\/li><li>Energy Conserving CPU<\/li><li>Enhanced Capacity, Squared<\/li><\/ul>\n\n\n\n<p><strong>How does DynamoDB display data rows of differing schema together?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>It displays common keys as distinct columns in a table, and the rest in an &#8220;Other&#8221; column<\/li><li><strong>It combines all keys from all rows as if they were common to each row (Ans)<\/strong><\/li><li>It omits any key absent from any row<\/li><li>It displays data in multiple frids, each with differing column headers<\/li><\/ul>\n\n\n\n<p><strong>Which of the following services is a component of the AWS Big Data Stack?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Redshift (Ans)<\/strong><\/li><li>VPC<\/li><li>Cloud Watch<\/li><li>Glacier<\/li><\/ul>\n\n\n\n<p><strong>Amazon offers a code library that allows developers to build their own Kinesis data connectors.<\/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>Designing Jaspersoft reports is done in a standalone desktop application.<\/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 is <em>not<\/em> directly supported as a Pipeline data source or destination?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Microsoft SQL Server on Relational Database Service (RDS) (Ans)<\/strong><\/li><li>DynamoDB<\/li><li>Redshift<\/li><li>MySQL on Relational Database Service (RDS)<\/li><\/ul>\n\n\n\n<p><strong>Which of the following Hadoop vendor&#8217;s distribution is supported on Elastic MapReduce?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Cloudera<\/li><li>Hortonworks<\/li><li><strong>MapR (Ans)<\/strong><\/li><li>Pivotal<\/li><\/ul>\n\n\n\n<p><strong>Which of the following Hadoop distribution components does Elastic MapReduce omit?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MapReduce<\/li><li><strong>Sqoop (Ans)<\/strong><\/li><li>Hive<\/li><li>Pig<\/li><\/ul>\n\n\n\n<p><strong>What is the name of Apache Pig&#8217;s programming language?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Pig Latin (Ans)<\/strong><\/li><li>PQL<\/li><li>PigML<\/li><li>Pig.js<\/li><\/ul>\n\n\n\n<p><strong>Amazon CloudFormation can be used to provision Japsersoft instances.<\/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>You can create a key pair in the AWS Management Console.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>True (Ans)<\/strong><\/li><li>False<\/li><\/ul>\n\n\n\n<p><strong>Saving a Pipeline causes a validation check to be run on it.<\/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>Files stored in S3 can be referenced by URL.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>True (Ans)<\/strong><\/li><li>False<\/li><\/ul>\n\n\n\n<p><strong>Kinesis has data connectors for all Amazon components except:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>MySQL Relational Database Service (RDS) (Ans)<\/strong><\/li><li>DynamoDB<\/li><li>Redshift<\/li><li>EMR<\/li><\/ul>\n\n\n\n<p><strong>The purpose of a DynamoDB secondary indexes is to:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Allow for fast searches on attributes beyond hash and range keys (Ans)<\/strong><\/li><li>Allow for querying data using SQL<\/li><li>Allow indexes to be added after table creation<\/li><li>Make data available on more nodes for distributed access<\/li><\/ul>\n\n\n\n<p><strong>Redshift uses relational database technology.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>True (Ans)<\/strong><\/li><li>False<\/li><\/ul>\n\n\n\n<p><strong>Which of the following is an effective method for monitoring running Data Pipeline jobs?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Run the pipeline in Eclipse<\/li><li>Set breakpoints in Pipeline script file<\/li><li>Set email alerts for activity nodes<\/li><li><strong>Ensure no steps in status page stay in WAITING_FOR_RUNNER or WAITING_ON_DEPENDENCIES state too long (Ans)<\/strong><\/li><\/ul>\n\n\n\n<p><strong>Which of the following is the largest enabler of the Big Data phenomenon?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Commercial software<\/li><li>Relational databases<\/li><li><strong>Significant reduction in storage costs (Ans)<\/strong><\/li><li>Specialized hardware appliances<\/li><\/ul>\n\n\n\n<p><strong>Which of the following does S3 Browser need to connect to your S3 account?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Public and private key pair<\/li><li><strong>Access key ID and secret access key (Ans)<\/strong><\/li><li>AWS username and password<\/li><li>Bucket name and folder name<\/li><\/ul>\n\n\n\n<p><strong>Impala provides interactive (non-batch) SQL query over data in:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>The Hadoop Distributed File System (HDFS) (Ans)<\/strong><\/li><li>Relational Database Service (RDS)<\/li><li>DynamoDB<\/li><li>Redshift<\/li><\/ul>\n\n\n<div class=\"epyt-gallery\" data-currpage=\"1\" id=\"epyt_gallery_74034\"><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_36224\"  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_74034\"  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>Database clients can connect to Redshift using ODBC and JDBC drivers for Postgres. True (Ans) False Cloudera Impala is included on EMR clusters by default. True False&#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5633],"tags":[],"class_list":["post-8966","post","type-post","status-publish","format-standard","hentry","category-aws"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/8966","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=8966"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/8966\/revisions"}],"predecessor-version":[{"id":25095,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/8966\/revisions\/25095"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=8966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=8966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=8966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}