Ultimate Guide to Prepare DEA-C01 Certification Exam for SnowPro Advanced in 2024 [Q67-Q86]

NEW QUESTION 67
A retail company uses Amazon Aurora PostgreSQL to process and store live transactional data.
The company uses an Amazon Redshift cluster for a data warehouse.
An extract, transform, and load (ETL) job runs every morning to update the Redshift cluster with new data from the PostgreSQL database. The company has grown rapidly and needs to cost optimize the Redshift cluster.
A data engineer needs to create a solution to archive historical data. The data engineer must be able to run analytics queries that effectively combine data from live transactional data in PostgreSQL, current data in Redshift, and archived historical data. The solution must keep only the most recent 15 months of data in Amazon Redshift to reduce costs.
Which combination of steps will meet these requirements? (Choose two.)

NEW QUESTION 68
A company is migrating on-premises workloads to AWS. The company wants to reduce overall operational overhead. The company also wants to explore serverless options.
The company’s current workloads use Apache Pig, Apache Oozie, Apache Spark, Apache Hbase, and Apache Flink. The on-premises workloads process petabytes of data in seconds. The company must maintain similar or better performance after the migration to AWS.
Which extract, transform, and load (ETL) service will meet these requirements?

NEW QUESTION 69
Select the Incorrect statement about External Functions in SnowFlake?

NEW QUESTION 70
A company is planning to migrate on-premises Apache Hadoop clusters to Amazon EMR. The company also needs to migrate a data catalog into a persistent storage solution.
The company currently stores the data catalog in an on-premises Apache Hive metastore on the Hadoop clusters. The company requires a serverless solution to migrate the data catalog.
Which solution will meet these requirements MOST cost-effectively?

NEW QUESTION 71
A data engineer creates an AWS Lambda function that an Amazon EventBridge event will invoke.
When the data engineer tries to invoke the Lambda function by using an EventBridge event, an AccessDeniedException message appears.
How should the data engineer resolve the exception?

NEW QUESTION 72
Regular views do not cache data, and therefore cannot improve performance by caching?

NEW QUESTION 73
What kind of Snowflake integration is required when defining an external function in Snowflake?

NEW QUESTION 74
Data Engineer, ran the below clustering depth analysis function:
select system$clustering_depth(‘TPCH_CUSTOMERS’, ‘(C1, C6)’, ‘C9 = 30’); on TPCH_CUSTOMERS table, will return which of the following?

NEW QUESTION 75
Select the correct usage statements with regards to SQL UDF?

NEW QUESTION 76
Search optimization works best to improve the performance of a query when the following condi-tions are true:[Select All that apply]

NEW QUESTION 77
Which methods will trigger an action that will evaluate a DataFrame? (Select TWO)

NEW QUESTION 78
A data engineer is configuring an AWS Glue job to read data from an Amazon S3 bucket. The data engineer has set up the necessary AWS Glue connection details and an associated IAM role. However, when the data engineer attempts to run the AWS Glue job, the data engineer receives an error message that indicates that there are problems with the Amazon S3 VPC gateway endpoint.
The data engineer must resolve the error and connect the AWS Glue job to the S3 bucket.
Which solution will meet this requirement?

NEW QUESTION 79
In one of your created Schema, you have been required to create Internal Stages, what are the In-correct considerations you can noticed from the below options? [Select All that Apply]

NEW QUESTION 80
Which two Account usage views can be used for auditing Dynamic data masking purpose?

NEW QUESTION 81
A company stores logs in an Amazon S3 bucket. When a data engineer attempts to access several log files, the data engineer discovers that some files have been unintentionally deleted.
The data engineer needs a solution that will prevent unintentional file deletion in the future.
Which solution will meet this requirement with the LEAST operational overhead?

NEW QUESTION 82
Bob, a Lead Data Engineer is looking out to get the function definition & queried below statement to check if this function is secure enough to use in his script or not.
select is_secure from information_schema.functions where function_name = ‘JOHNFUNCTION’; From the query output he is sure that, Function is secure UDF, what are the way provided by snow-flake to get the function definition of secure UDF?

NEW QUESTION 83
Which privilege are required on an object (i.e. user or role) with USERADMIN Role can modify the object properties?

NEW QUESTION 84
A company is using Snowpipe to bring in millions of rows every day of Change Data Capture (CDC) into a Snowflake staging table on a real-time basis The CDC needs to get processedand combined with other data in Snowflake and land in a final table as part of the full data pipeline.
How can a Data engineer MOST efficiently process the incoming CDC on an ongoing basis?

NEW QUESTION 85
A company maintains an Amazon Redshift provisioned cluster that the company uses for extract, transform, and load (ETL) operations to support critical analysis tasks. A sales team within the company maintains a Redshift cluster that the sales team uses for business intelligence (BI) tasks.
The sales team recently requested access to the data that is in the ETL Redshift cluster so the team can perform weekly summary analysis tasks. The sales team needs to join data from the ETL cluster with data that is in the sales team’s BI cluster.
The company needs a solution that will share the ETL cluster data with the sales team without interrupting the critical analysis tasks. The solution must minimize usage of the computing resources of the ETL cluster.
Which solution will meet these requirements?

NEW QUESTION 86
In a data engineering pipeline, a company is using multiple applications and teams to access a shared Amazon S3 bucket. To streamline access and simplify permissions management for these different entities, which S3 feature should the company utilize?