最新的高品質 DEA-C02 考試練習題庫

Snowflake DEA-C02 考試概覽:

Snowflake DEA-C02 考試大綱主題:

最新的 SnowPro Advanced DEA-C02 免費考試真題：

1. You are designing a data warehouse for an e-commerce company. One of the requirements is to provide fast analytics on order fulfillment times by region. You have two tables: 'ORDERS: Contains order information, including ID, 'ORDER DATE, 'REGION ID, and 'FULFILLMENT DATE. 'REGIONS': Contains region information, including 'REGION ID' and Due to the large size of the 'ORDERS' table and the complexity of calculating fulfillment times, you decide to use materialized views.
Which of the following combinations of materialized view definition and Snowflake features would BEST optimize query performance and minimize data staleness for this scenario? Choose two options.

A) Use Snowflake's search optimization service on the 'ORDERS' table instead of creating a materialized view.
B) Create a materialized view that joins 'ORDERS and 'REGIONS', calculates the difference between 'FULFILLMENT DATE' and 'ORDER DATE as , and groups by REGION_NAME. Cluster the view by ' REGION_NAME.
C) Partition the 'ORDERS' table by 'ORDER_DATE and create a materialized view that calculates 'FULFILLMENT_TIME grouped by REGION_NAME , clustering by 'ORDER DATE'
D) Create a materialized view that joins 'ORDERS and 'REGIONS', calculates 'FULFILLMENT TIME', and groups by 'REGION NAME'. Do not specify a clustering key.
E) create a materialized view that joins 'ORDERS' and 'REGIONS', calculates 'FULFILLMENT_TIME' grouped by 'REGION_NAME, and cluster by 'REGION NAM Configure incremental data refreshes.

2. You are tasked with building a data pipeline to process image metadata stored in JSON format from a series of URLs. The JSON structure contains fields such as 'image_url', 'resolution', 'camera_model', and 'location' (latitude and longitude). Your goal is to create a Snowflake table that stores this metadata along with a thumbnail of each image. Given the constraints that you want to avoid downloading and storing the images directly in Snowflake, and that Snowflake's native functions for image processing are limited, which of the following approaches would be most efficient and scalable?

A) Create a Snowflake view that selects from a table containing the metadata URLs, using 'SYSTEM$URL GET to fetch the metadata. For each image URL found in the metadata, use a JavaScript UDF to generate a thumbnail. Embed the thumbnail into a VARCHAR column as a Base64 encoded string.
B) Store just the 'image_url' in snowflake. Develop a separate application using any programming language to pre generate the thumbnails and host those at publicly accessible URLs. Within Snowflake, create a view to generate the links for image and thumbnail using 'CONCAT.
C) Create a Snowflake external table that points to an external stage which holds the JSON metadata files. Develop a spark process to fetch image URL, create thumbnails and store as base64 encoded strings in an external stage, create a view using the external table and generated thumbnails data
D) Create a Snowflake stored procedure that iterates through each URL, downloads the JSON metadata using 'SYSTEM$URL_GET, extracts the image URL from the metadata, downloads the image using 'SYSTEM$URL_GET , generates a thumbnail using SQL scalar functions, and stores the metadata and thumbnail in a Snowflake table.
E) Create a Python-based external function that fetches the JSON metadata and image from their respective URLs. The external function uses libraries like PIL (Pillow) to generate a thumbnail of the image and returns the metadata along with the thumbnail's Base64 encoded string within a JSON object.

3. You are tasked with building a data pipeline using Snowpark to process sensor data from IoT devices. The data arrives in near real-time as JSON payloads, and you need to transform and load it into a Snowflake table named 'SENSOR DATA'. The transformation logic involves extracting specific fields, converting data types, and filtering out records based on a timestamp. Consider performance optimization for large data volumes. Which of the following approaches, in combination, would be MOST efficient for this scenario?

A) Creating an external table pointing to the JSON data in cloud storage and using Snowpark DataFrames to read the external table, apply transformations, and load the result into 'SENSOR DATA'.
B) Using a Snowpark Python UDF to parse JSON and perform transformations, loading the result into a temporary table, and then merging into 'SENSOR DATA'.
C) Employing Snowpipe to ingest the raw JSON data into a VARIANT column in a staging table, followed by a Snowpark DataFrame operation using 'functions.get' to extract and transform the data, and finally loading into 'SENSOR DATA'
D) Leveraging Snowflake's native JSON parsing functions within a SQL transformation step implemented as a Snowpark DataFrame operation, combined with a Snowpipe for initial data ingestion into a staging table.
E) Using a stored procedure written in Java to parse the JSON data and insert directly into the "SENSOR DATA' table.

4. You have implemented a masking policy on the 'EMAIL' column of a 'USERS' table. The policy masks the email address for all users except those with the 'SUPPORT' role. You now need to grant the 'SELECT' privilege on this table to a new role, 'ANALYST. You want to ensure that the masking policy continues to work as expected for the 'ANALYST' role. Which of the following SQL statements should you execute?

A)

B)

C)

D)

E)

5. A data engineer is tasked with processing a large dataset of customer orders using Snowpark Python. The dataset contains a column stored as a string in 'YYYY-MM-DD HH:MI:SS' format. They need to create a new DataFrame with only the orders placed in the month of January 2023. Which of the following code snippets achieves this most efficiently, considering potential data volume and query performance?

A)

B)

C)

D)

E)

問題與答案：