Question 1

What can "Economies of scale" refer to?

Accepted Answer

Prices of individual items get lower with a higher buying volume.

Answer

Prices of individual items get higher with a higher buying volume.

Answer

Prices of individual items get lower with a lower buying volume.

Answer

All of those.

Question 2

AWS Athena runs the following open-source distributed SQL query engine under the hood

Accepted Answer

Trino

Answer

Hive

Answer

Pig

Answer

Hadoop MapReduce

Question 3

Athena may also be used to query data sources other than S3 (e.g., databases)

Accepted Answer

true

Answer

false

Question 4

The possibility to use the AWS APIs programmatically is an additional paid feature. By default, users can only use AWS via the web browser ("AWS Console").

Accepted Answer

false

Answer

true

Question 5

After an EC2 instance has been created on AWS, it's CPU and RAM specifications cannot be changed any more.

Accepted Answer

false

Answer

true

Question 6

Why can the use of columnar file formats in big data frameworks / big data query engines (such as Athena) speed up query execution?

Accepted Answer

If a query does not use "SELECT *", projections of the query can be satisfied without reading the entire file. It also allows to apply compression algorithms individually per column.

Answer

If a query does not use "SELECT *", projections of the query can be satisfied without reading the entire file. Columnar file formats do not use compression so that the amount of CPU work to read the data is reduced.

Answer

If a query uses "SELECT *", projections of the query can be satisfied without reading the entire file. It also allows to apply compression algorithms individually per column.

Question 7

A Glue crawler refers to [...]

Accepted Answer

a mechanism to perform automated schema detection for data that is stored on S3. Table definitions created by a Glue crawler can later also be adapted manually.

Answer

a mechanism to perform automated schema detection for data that is stored on S3. Table definitions created by a Glue crawler cannot be changed manually, as otherwise subsequent updates will fail.

Answer

a mechanism to perform automated schema detection for data that is stored on S3. It suggests column data types which users can then manually use in their "CREATE TABLE" statements.

Answer

a mechanism to suggest the usage of predicate pushdown or projection pushdown for Athena queries.

Question 8

With the "pay-per-use" model in cloud computing, you

Accepted Answer

Trade Capital Expense for Operational Expense

Answer

Double your Capital Expense

Answer

Trade Operational Expense for Capital Expense

Answer

Usually don't have a change in Capital Expense or Operational Expense

Question 9

Select the mechanism that cannot be used to implement an ETL workflow on AWS.

Accepted Answer

S3 Select

Answer

Ray jobs

Answer

EMR serverless jobs

Answer

Athena CTAS (Create Table As Select)

Question 10

The cloud computing model "Platform as a Service" can roughly be paraphrased by

Accepted Answer

“You just bring your code, and the cloud service provider runs it.”

Answer

“You have control over the entire platform, from virtual machines, to virtual load balancers and virtual networks.”

Answer

"You just bring your data to be stored, and the cloud service provider handles and manages all the storage infrastructure underneith (e.g., AWS S3)"

Answer

"The cloud service provider provides you with a ready-made platform where you can log in and install your software (e,g., a ready-made Linux OS with a fully configured web server installed, etc.)"

Related quizzes

Related quizzes