Font size
WorksheetsClass 9. Data Manipulation
Total questions: 53
Worksheet time: 27mins
What is the purpose of a data lake?
To store data in a structured and cleaned format only
To collect and store massive amounts of structured and unstructured data from any number of places
To duplicate data for backup purposes
To perform online transaction processing
Which AWS service allows you to create a data lake?
AWS Transfer Family
AWS Data Firehose
AWS Lake Formation
AWS Glue
What operations can AWS Glue perform?
Online Analytical Processing (OLAP) only
Extract, Transform, Load (ETL) operations
Data deduplication
Data visualization
Can a data lake store all your data as is, without the need for structuring or cleaning?
No, it must be structured and cleaned
Yes, but it must be deduplicated
Yes, it can store all your data as is
No, it can only store structured data
What is AWS Glue based on?
The AWS proprietary framework
The Apache Spark big data framework
The Hadoop ecosystem
The AWS Kinesis framework
What is the process of collecting data from various sources and pulling it into your data lake known as?
Transformation
Analytics
Ingestion
Cataloging
Which AWS service is NOT mentioned as a source from which AWS Lake Formation can import data?
AWS Glue
AWS CloudFront
AWS CloudTrail
AWS S3
What does AWS Glue Data Catalog store?
Data lake configuration settings
Metadata about the data lake
Physical data files
User access logs
What is the purpose of the FindMatches ML transform in AWS Lake Formation?
To classify data according to sensitivity
To visualize data patterns
To deduplicate data
To import data from on-premises databases
Which of the following is NOT a function of analytics as described in the text?
Querying data
Visualizing data
Deduplicating data
Performing statistical functions on data
Which AWS service is used for querying and analyzing data in a data lake and is mentioned in the Analytics section?
AWS Glue
Amazon Athena
Amazon RedShift
AWS CloudTrail
What is the main difference between a data lake and a data warehouse according to the note in the image?
A) A data warehouse stores unstructured data, while a data lake stores structured data.
B) A data warehouse stores structured data in a relational OLAP database, while a data lake stores unstructured data in flat files.
C) A data lake and a data warehouse are the same.
D) A data warehouse uses AWS Lake Formation, while a data lake uses S3.
Which protocols does AWS Transfer Family support for transferring data into and out of S3 and EFS?
A) HTTP, HTTPS, and FTP
B) FTP, SFTP, and FTPS
C) SMTP, IMAP, and POP3
D) NFS, SMB, and iSCSI
What are the authentication options available for AWS Transfer Family?
A) Only integration with third-party identity providers
B) Only local authentication
C) Local authentication or integration with third-party identity providers such as Active Directory
D) OAuth and SAML 2.0
What services does AWS offer for different types of streaming data under the Kinesis suite?
A) Kinesis Data Streams, Kinesis Video Streams, and Kinesis Data Firehose
B) Kinesis Data Analytics, Kinesis Data Firehose, and Kinesis Data Streams
C) Kinesis Data Firehose, Kinesis Data Lake, and Kinesis Video Streams
D) Kinesis Data Warehouse, Kinesis Data Streams, and Kinesis Data Firehose
Which of the following is NOT a popular use case for Kinesis Video Streams?
A) Computer vision applications, such as image recognition
B) Streaming video
C) Two-way videoconferencing
D) Real-time data analytics
What model does Kinesis Video Streams use?
Consumer-producer model
Producer-consumer model
Client-server model
Peer-to-peer model
What is the role of a producer in Kinesis Video Streams?
It processes the video stream for playback.
It feeds data into a Kinesis stream.
It indexes the stream using timestamps.
It retrieves data from the stream for real-time feedback.
For how long does Kinesis Video Streams store a video stream by default?
7 days
24 hours
48 hours
30 days
Which AWS service can be used as a consumer to pull data from a Kinesis video stream for processing?
Amazon EC2
Amazon S3
Amazon Kinesis Agent
Amazon DynamoDB
What protocols does Kinesis Video Streams support for video playback?
HTTPS Live Streams (HLS) and Dynamic Adaptive Streaming Over HTTP (DASH)
Real-Time Messaging Protocol (RTMP) and Web Real-Time Communication (WebRTC)
Simple Object Access Protocol (SOAP) and Representational State Transfer (REST)
File Transfer Protocol (FTP) and Secure Shell (SSH)
What types of data can Kinesis Data Streams rapidly ingest and store? (Select all that apply)
Application logs
Stock trades
Social media feeds
All of the above
How does Kinesis Data Streams differ from Kinesis Video Streams in terms of indexing?
Kinesis Data Streams uses timestamps while Kinesis Video Streams uses partition keys.
Kinesis Data Streams uses partition keys and sequence numbers while Kinesis Video Streams uses timestamps.
Kinesis Data Streams does not index data at all.
Kinesis Video Streams does not index data at all.
What can you use to send data directly from your application into a Kinesis stream?
Amazon Kinesis Video Streams
Amazon EC2
Amazon Kinesis Agent
Kinesis Producer Library (KPL)
What is the process called when multiple consumers can read from a stream concurrently in Kinesis Data Streams?
Multi-read
Concurrent-read
Fan-out
Stream-share
What is the maximum data rate of a shard in Kinesis Data Streams for read transactions?
1 MB per second
2 MB per second
500 KB per second
1.5 MB per second
How many records per second can you push up to for writes in Kinesis Data Streams?
500 records per second
1,000 records per second
2,000 records per second
5,000 records per second
What AWS service is typically used to allow an application component to pass small, short-lived messages to other components?
Kinesis Data Firehose
Kinesis Data Streams
Simple Queue Service (SQS)
Simple Notification Service (SNS)
What is the main difference between Kinesis Data Streams and Kinesis Data Firehose?
Kinesis Data Streams is designed for durable storage and playback of large data streams, while Kinesis Data Firehose is not.
Kinesis Data Firehose can ingest streaming data and transform it before sending it to a destination, while Kinesis Data Streams cannot.
Kinesis Data Streams can buffer data before delivering it to its destination, while Kinesis Data Firehose cannot.
Kinesis Data Firehose uses a producer-consumer model, while Kinesis Data Streams uses a one-to-many model.
What model does Kinesis Data Streams use?
One-to-one
One-to-many
Many-to-one
Many-to-many
What is the role of the application that reads data from a Kinesis stream?
Producer
Consumer
Broker
Transformer
Which AWS service is tightly integrated with managed AWS services and third-party applications and is generally more appropriate for streaming data to services such as Redshift, S3, or Splunk?
Simple Queue Service
Kinesis Video Streams
Kinesis Data Streams
Kinesis Data Firehose
What is the maximum retention period for data in the Simple Queue Service according to Table 9.1?
24 hours
7 days
14 days
No limit
Which Kinesis service is the usual better choice for streaming data to a custom application?
Simple Queue Service
Kinesis Video Streams
Kinesis Data Streams
Kinesis Data Firehose
According to the Exam Essentials, for what type of data is Kinesis Video Streams most appropriate?
Any time-encoded data, including video, audio, and radar images
Sequences of any binary data
Time-indexed data that does not need to be transformed
Data that needs to be transformed and delivered to a specific destination
Which Kinesis service allows data transformation and delivers streaming data to a specific destination?
Simple Queue Service
Kinesis Video Streams
Kinesis Data Streams
Kinesis Data Firehose
What are valid use cases for transforming data when importing it into a data lake? (Select three.)
Imposing consistent timestamps
Removing corrupted data
Creating a schema
Removing duplicate data
Visualizing data
What AWS Data Lake transform detects duplicate data?
MatchFinder
FindMatches ML
Elastic MapReduce
Spark
What’s the most efficient way to import data from an on-premises SQL database into an AWS Data Lake?
Dump the database into an S3 bucket and then import the data into the data lake.
Import the data into RDS and then into the data lake.
Use the Glue Connector.
Use the JDBC connector.
What protocols does AWS Transfer Family support? (Choose two.)
SFTP
SMB
FTP
CIFS
HTTPS
What technology does AWS Glue use to search large data sets and perform data transformation?
Amazon Athena
Apache Spark
Apache Elephant Stack
AWS Data Lake
Which of the following can AWS Data Lake import from? (Choose two.)
EBS
ELB
CloudFront
IAM
CloudWatch
Which of the following is not an appropriate use of AWS Glue?
Searching data
Ingesting real-time streaming data
Preparing data for analysis
Transforming data
You’re developing an application to predict future weather patterns based on RADAR images. Which of the following Kinesis services is the best choice to support this application?
Kinesis Data Streams
Kinesis Video Streams
Kinesis Data Firehose
Kinesis ML
You’re streaming image data to Kinesis Data Streams and need to retain the data for 30 days. How can you do this? (Choose two.)
Create a Kinesis Data Firehose delivery stream.
Increase the stream retention period to 14 days.
Specify an S3 bucket as the destination.
Specify CloudWatch Logs as the destination.
Which of the following Kinesis services requires you to specify a destination for the stream?
Kinesis Video Streams
Kinesis Data Streams
Kinesis Data Firehose
Kinesis Data Warehouse
You’re running an on-premises application that frequently writes to a log file. You want to stream this log file to a Kinesis Data Stream. How can you accomplish this with the least effort?
Use the CloudWatch Logs Agent.
Use the Amazon Kinesis Agent.
Write a script that uses the Kinesis Producer Library.
Move the application to an EC2 instance.
When deciding whether to use SQS or Kinesis Data Streams to ingest data, which of the following should you take into account?
The frequency of data
The total amount of data
The number of consumers that need to receive the data
The order of data
You want to send streaming log data into Amazon Redshift. Which of the following services should you use? (Choose two.)
SQS with a standard queue
Kinesis Data Streams
Kinesis Data Firehose
SQS with a FIFO queue
Which of the following is not an appropriate use case for Kinesis?
Stock feeds
Facial recognition
Static website hosting
Videoconferencing
You need to push 2 MB per second through a Kinesis Data Stream. How many shards do you need to configure?
1
2
4
8
Multiple consumers are receiving a Kinesis Data Stream at a total rate of 3 MB per second. You plan to add more consumers and need the stream to support reads of at least 5 MB per second. How many shards do you need to add?
1
2
3
4
Which of the following does Kinesis Data Firehose not support?
Videoconferencing
Transforming video metadata
Converting CSV to JSON
Redshift
