CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. SnowPro Advanced Data Engineer

Free SnowPro Advanced Data Engineer Exam Braindumps (page: 19)

Page 19 of 37
PDF with 141 Questions

A company receives a daily file that contains customer data in .xls format. The company stores the file in Amazon S3. The daily file is approximately 2 GB in size.
A data engineer concatenates the column in the file that contains customer first names and the column that contains customer last names. The data engineer needs to determine the number of distinct customers in the file.
Which solution will meet this requirement with the LEAST operational effort?

  1. Create and run an Apache Spark job in an AWS Glue notebook. Configure the job to read the S3 file and calculate the number of distinct customers.
  2. Create an AWS Glue crawler to create an AWS Glue Data Catalog of the S3 file. Run SQL queries from Amazon Athena to calculate the number of distinct customers.
  3. Create and run an Apache Spark job in Amazon EMR Serverless to calculate the number of distinct customers.
  4. Use AWS Glue DataBrew to create a recipe that uses the COUNT_DISTINCT aggregate function to calculate the number of distinct customers.

Answer(s): D



A healthcare company uses Amazon Kinesis Data Streams to stream real-time health data from wearable devices, hospital equipment, and patient records.
A data engineer needs to find a solution to process the streaming data. The data engineer needs to store the data in an Amazon Redshift Serverless warehouse. The solution must support near real-time analytics of the streaming data and the previous day's data.
Which solution will meet these requirements with the LEAST operational overhead?

  1. Load data into Amazon Kinesis Data Firehose. Load the data into Amazon Redshift.
  2. Use the streaming ingestion feature of Amazon Redshift.
  3. Load the data into Amazon S3. Use the COPY command to load the data into Amazon Redshift.
  4. Use the Amazon Aurora zero-ETL integration with Amazon Redshift.

Answer(s): B



A data engineer needs to use an Amazon QuickSight dashboard that is based on Amazon Athena queries on data that is stored in an Amazon S3 bucket. When the data engineer connects to the QuickSight dashboard, the data engineer receives an error message that indicates insufficient permissions.
Which factors could cause to the permissions-related errors? (Choose two.)

  1. There is no connection between QuickSight and Athena.
  2. The Athena tables are not cataloged.
  3. QuickSight does not have access to the S3 bucket.
  4. QuickSight does not have access to decrypt S3 data.
  5. There is no IAM role assigned to QuickSight.

Answer(s): C,D



A company stores datasets in JSON format and .csv format in an Amazon S3 bucket. The company has Amazon RDS for Microsoft SQL Server databases, Amazon DynamoDB tables that are in provisioned capacity mode, and an Amazon Redshift cluster. A data engineering team must develop a solution that will give data scientists the ability to query all data sources by using syntax similar to SQL.
Which solution will meet these requirements with the LEAST operational overhead?

  1. Use AWS Glue to crawl the data sources. Store metadata in the AWS Glue Data Catalog. Use Amazon Athena to query the data. Use SQL for structured data sources. Use PartiQL for data that is stored in JSON format.
  2. Use AWS Glue to crawl the data sources. Store metadata in the AWS Glue Data Catalog. Use Redshift Spectrum to query the data. Use SQL for structured data sources. Use PartiQL for data that is stored in JSON format.
  3. Use AWS Glue to crawl the data sources. Store metadata in the AWS Glue Data Catalog. Use AWS Glue jobs to transform data that is in JSON format to Apache Parquet or .csv format. Store the transformed data in an S3 bucket. Use Amazon Athena to query the original and transformed data from the S3 bucket.
  4. Use AWS Lake Formation to create a data lake. Use Lake Formation jobs to transform the data from all data sources to Apache Parquet format. Store the transformed data in an S3 bucket. Use Amazon Athena or Redshift Spectrum to query the data.

Answer(s): A



Page 19 of 37



Post your Comments and Discuss Snowflake SnowPro Advanced Data Engineer exam with other Community members:

swathi commented on December 18, 2024
it is good compared to other sites
Anonymous
upvote

n commented on December 18, 2024
challenging
Anonymous
upvote

vallepu Ankamma commented on December 18, 2024
useful for the exam
Anonymous
upvote

ADJOA commented on December 17, 2024
good resources
Anonymous
upvote

VALLEPU ANKAMMA commented on December 17, 2024
These questions are very useful for exam
Anonymous
upvote

Jagadeeswara Reddy Sirigireddy commented on December 17, 2024
Looking for Terraform Associate exam dumps.
Anonymous
upvote

Austin commented on December 17, 2024
OK ok When the VM becomes infected with data encrypting ransomware, you decide to recover the VM's files. Which of the following is TRUE in this scenario?
INDIA
upvote

KEMISO ABEBE BEKERE commented on December 17, 2024
GRE FREE CERTIFICATE TEST
Anonymous
upvote

Krishna commented on December 16, 2024
It's very helpful for exam
AUSTRALIA
upvote

nana commented on December 16, 2024
good information for practice
Anonymous
upvote

Nice commented on December 16, 2024
Nice nice nice
Anonymous
upvote

Jonas commented on December 16, 2024
Interesting
Anonymous
upvote

Gosia commented on December 16, 2024
Hi, did you have the same questions on exams?
POLAND
upvote

tom commented on December 16, 2024
it is very good
HONG KONG
upvote

sk commented on December 16, 2024
very usefull
Anonymous
upvote

harsha commented on December 16, 2024
a good way to practice
Anonymous
upvote

Rarebreed commented on December 16, 2024
These Dumps are super duper awesome. I passed my exams from these dumps on 14Th December 2024
NIGERIA
upvote

RJ commented on December 16, 2024
Preparing exam
UNITED STATES
upvote

CY commented on December 15, 2024
quite simple
HONG KONG
upvote

Kamala Swarnalatha commented on December 15, 2024
Good to use
Anonymous
upvote

kamala commented on December 15, 2024
Good to use this
Anonymous
upvote

BabeGirl commented on December 15, 2024
great stuff
Anonymous
upvote

Ousman commented on December 15, 2024
i am going to pass in this month
Anonymous
upvote

Roshan Thakur commented on December 15, 2024
Its very useful.
UNITED STATES
upvote

joe commented on December 15, 2024
dump still valid?
UNITED STATES
upvote

Priti commented on December 14, 2024
Answers seems to be correct
SINGAPORE
upvote

megha commented on December 14, 2024
pls give download file for dumps
Anonymous
upvote

Priti commented on December 14, 2024
Good questions
SINGAPORE
upvote

Priti commented on December 14, 2024
Good article
SINGAPORE
upvote

R Jeswanth commented on December 14, 2024
Hi This is Jai
AUSTRALIA
upvote

Anonymous commented on December 14, 2024
Good set or practice
Anonymous
upvote

??? commented on December 14, 2024
great collection of test questions. very effective to pass the exam
BANGLADESH
upvote

summer commented on December 13, 2024
nice questions
Anonymous
upvote

DIvesh commented on December 13, 2024
Good way to practice
JAPAN
upvote