AWS Interview Questions and Answer Part – 24

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 (Ans)

EC2 stands for:

• External Cloud Connectivity
• Elastic Compute Cloud (Ans)
• Energy Conserving CPU
• Enhanced Capacity, Squared

How does DynamoDB display data rows of differing schema together?

• It displays common keys as distinct columns in a table, and the rest in an “Other” column
• It combines all keys from all rows as if they were common to each row (Ans)
• It omits any key absent from any row
• It displays data in multiple frids, each with differing column headers

Which of the following services is a component of the AWS Big Data Stack?

• Redshift (Ans)
• VPC
• Cloud Watch
• Glacier

Amazon offers a code library that allows developers to build their own Kinesis data connectors.

• False
• True (Ans)

Designing Jaspersoft reports is done in a standalone desktop application.

• True
• False (Ans)

Which of the following is not directly supported as a Pipeline data source or destination?

• Microsoft SQL Server on Relational Database Service (RDS) (Ans)
• DynamoDB
• Redshift
• MySQL on Relational Database Service (RDS)

Which of the following Hadoop vendor’s distribution is supported on Elastic MapReduce?

• Cloudera
• Hortonworks
• MapR (Ans)
• Pivotal

Which of the following Hadoop distribution components does Elastic MapReduce omit?

• MapReduce
• Sqoop (Ans)
• Hive
• Pig

What is the name of Apache Pig’s programming language?

• Pig Latin (Ans)
• PQL
• PigML
• Pig.js

Amazon CloudFormation can be used to provision Japsersoft instances.

• False
• True (Ans)

You can create a key pair in the AWS Management Console.

• True (Ans)
• False

Saving a Pipeline causes a validation check to be run on it.

• False
• True (Ans)

Files stored in S3 can be referenced by URL.

• True (Ans)
• False

Kinesis has data connectors for all Amazon components except:

• MySQL Relational Database Service (RDS) (Ans)
• DynamoDB
• Redshift
• EMR

The purpose of a DynamoDB secondary indexes is to:

• Allow for fast searches on attributes beyond hash and range keys (Ans)
• Allow for querying data using SQL
• Allow indexes to be added after table creation
• Make data available on more nodes for distributed access

Redshift uses relational database technology.

• True (Ans)
• False

Which of the following is an effective method for monitoring running Data Pipeline jobs?

• Run the pipeline in Eclipse
• Set breakpoints in Pipeline script file
• Set email alerts for activity nodes
• Ensure no steps in status page stay in WAITING_FOR_RUNNER or WAITING_ON_DEPENDENCIES state too long (Ans)

Which of the following is the largest enabler of the Big Data phenomenon?

• Commercial software
• Relational databases
• Significant reduction in storage costs (Ans)
• Specialized hardware appliances

Which of the following does S3 Browser need to connect to your S3 account?

• Public and private key pair
• Access key ID and secret access key (Ans)
• AWS username and password
• Bucket name and folder name

Impala provides interactive (non-batch) SQL query over data in:

• The Hadoop Distributed File System (HDFS) (Ans)
• Relational Database Service (RDS)
• DynamoDB
• Redshift

Rajesh Kumar

I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I have worked at Cotocus. I share tech blog at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow , and SEO strategies at Wizbrand.

Do you want to learn Quantum Computing?

Please find my social handles as below;

Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at WIZBRAND

Rajesh Kumar DailyLogs