최신Snowflake SnowPro Advanced: Data Engineer (DEA-C02) - DEA-C02무료샘플문제
문제1
You are using Snowpark Python to transform a DataFrame 'df_orderS containing order data'. You need to filter the DataFrame to include only orders with a total amount greater than $1000 and placed within the last 30 days. Assume the DataFrame has columns 'order_id', 'order_date' (timestamp), and 'total_amount' (numeric). Which of the following code snippets is the MOST efficient and correct way to achieve this filtering using Snowpark?
You are using Snowpark Python to transform a DataFrame 'df_orderS containing order data'. You need to filter the DataFrame to include only orders with a total amount greater than $1000 and placed within the last 30 days. Assume the DataFrame has columns 'order_id', 'order_date' (timestamp), and 'total_amount' (numeric). Which of the following code snippets is the MOST efficient and correct way to achieve this filtering using Snowpark?
정답: E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제2
Consider the following Snowflake UDTF definition written in Python:
Which of the following statements are TRUE regarding the deployment and usage of this UDTF?
Consider the following Snowflake UDTF definition written in Python:
Which of the following statements are TRUE regarding the deployment and usage of this UDTF?
정답: B,D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제3
A data engineering team has created a Snowflake Listing to share their company's sales data'. They want to allow consumers to access the Listing programmatically. The consumers need to know when new versions of the Listing are available. What is the MOST efficient method for consumers to be notified about new Listing versions without continuously polling Snowflake?
A data engineering team has created a Snowflake Listing to share their company's sales data'. They want to allow consumers to access the Listing programmatically. The consumers need to know when new versions of the Listing are available. What is the MOST efficient method for consumers to be notified about new Listing versions without continuously polling Snowflake?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제4
You need to create a development environment from a production schema called 'PRODUCTION SCHEMA. You decide to clone the schema'. Which of the following statements are correct regarding the impact of cloning a schema in Snowflake? (Select all that apply)
You need to create a development environment from a production schema called 'PRODUCTION SCHEMA. You decide to clone the schema'. Which of the following statements are correct regarding the impact of cloning a schema in Snowflake? (Select all that apply)
정답: A,D,E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
You are responsible for ensuring data consistency across multiple Snowflake tables involved in a financial reporting system. You've noticed discrepancies in aggregate calculations between a 'TRANSACTIONS" table and a summary table 'MONTHLY REPORTS'. The 'TRANSACTIONS' table is frequently updated via streams and tasks. Which combination of the following strategies would be MOST effective in identifying and resolving these inconsistencies in near real-time?
You are responsible for ensuring data consistency across multiple Snowflake tables involved in a financial reporting system. You've noticed discrepancies in aggregate calculations between a 'TRANSACTIONS" table and a summary table 'MONTHLY REPORTS'. The 'TRANSACTIONS' table is frequently updated via streams and tasks. Which combination of the following strategies would be MOST effective in identifying and resolving these inconsistencies in near real-time?
정답: A,B,E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제6
You are a data engineer responsible for data governance in a Snowflake environment. Your company has implemented data classification using tags to identify sensitive data'. The compliance team has requested a report detailing all tables and columns that contain PII data, specifically including the tag name, tag value, the fully qualified name of the table, and the column name. You have the necessary privileges to access the Snowflake metadata views. Which of the following queries would provide the MOST comprehensive and accurate report, considering performance and ease of understanding?
You are a data engineer responsible for data governance in a Snowflake environment. Your company has implemented data classification using tags to identify sensitive data'. The compliance team has requested a report detailing all tables and columns that contain PII data, specifically including the tag name, tag value, the fully qualified name of the table, and the column name. You have the necessary privileges to access the Snowflake metadata views. Which of the following queries would provide the MOST comprehensive and accurate report, considering performance and ease of understanding?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제7
You are tasked with building a User-Defined Aggregate Function (UDAF) in Snowflake to calculate the weighted average of product prices. The weight is determined by the quantity sold for each product. You have the following table: 'SALES (product_id INTEGER, price quantity INTEGER)'. Which of the following UDAF definitions would correctly calculate the weighted average?
You are tasked with building a User-Defined Aggregate Function (UDAF) in Snowflake to calculate the weighted average of product prices. The weight is determined by the quantity sold for each product. You have the following table: 'SALES (product_id INTEGER, price quantity INTEGER)'. Which of the following UDAF definitions would correctly calculate the weighted average?
정답: E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제8
You are tasked with creating a resilient data ingestion pipeline using Snowpipe and external tables on AWS S3. The data consists of JSON files, some of which may occasionally contain invalid JSON structures (e.g., missing closing brackets, incorrect data types). You want to ensure that even if some files are corrupted, the valid data is still ingested into your target Snowflake table, and the corrupted files are logged for later investigation. Which of the following steps would BEST achieve this?
You are tasked with creating a resilient data ingestion pipeline using Snowpipe and external tables on AWS S3. The data consists of JSON files, some of which may occasionally contain invalid JSON structures (e.g., missing closing brackets, incorrect data types). You want to ensure that even if some files are corrupted, the valid data is still ingested into your target Snowflake table, and the corrupted files are logged for later investigation. Which of the following steps would BEST achieve this?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제9
You are tasked with creating an external function in Snowflake that calls a REST API. The API requires a bearer token for authentication, and the function needs to handle potential network errors and API rate limiting. Which of the following code snippets demonstrates the BEST practices for defining and securing this external function, including error handling?
You are tasked with creating an external function in Snowflake that calls a REST API. The API requires a bearer token for authentication, and the function needs to handle potential network errors and API rate limiting. Which of the following code snippets demonstrates the BEST practices for defining and securing this external function, including error handling?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제10
You are designing a data pipeline in Snowflake to process IoT sensor data'. The data arrives in JSON format, and you need to extract specific nested fields using a Snowpark UDF for performance reasons. Which of the following statements are true regarding best practices and limitations when working with complex JSON data and Snowpark UDFs (Python or Scala)? (Select all that apply)
You are designing a data pipeline in Snowflake to process IoT sensor data'. The data arrives in JSON format, and you need to extract specific nested fields using a Snowpark UDF for performance reasons. Which of the following statements are true regarding best practices and limitations when working with complex JSON data and Snowpark UDFs (Python or Scala)? (Select all that apply)
정답: C,D,E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제11
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?
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?
정답: C,E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제12
You are building a data pipeline to ingest clickstream data into Snowflake. The raw data is landed in a stage and you are using a Stream on this stage to track new files. The data is then transformed and loaded into a target table 'CLICKSTREAM DATA. However, you notice that sometimes the same files are being processed multiple times, leading to duplicate records in 'CLICKSTREAM DATA. You are using the 'SYSTEM$STREAM HAS DATA' function to check if the stream has data before processing. What are the possible reasons this might be happening, and how can you prevent it? (Select all that apply)
You are building a data pipeline to ingest clickstream data into Snowflake. The raw data is landed in a stage and you are using a Stream on this stage to track new files. The data is then transformed and loaded into a target table 'CLICKSTREAM DATA. However, you notice that sometimes the same files are being processed multiple times, leading to duplicate records in 'CLICKSTREAM DATA. You are using the 'SYSTEM$STREAM HAS DATA' function to check if the stream has data before processing. What are the possible reasons this might be happening, and how can you prevent it? (Select all that apply)
정답: A,B,C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제13
You have implemented a masking policy on the 'SSN' column of the 'EMPLOYEES' table. You now need to suspend the masking policy temporarily for a specific batch job that requires access to the unmasked data'. What is the recommended way to achieve this without dropping the masking policy or altering the user's role?
You have implemented a masking policy on the 'SSN' column of the 'EMPLOYEES' table. You now need to suspend the masking policy temporarily for a specific batch job that requires access to the unmasked data'. What is the recommended way to achieve this without dropping the masking policy or altering the user's role?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제14
You are designing a data protection strategy for a Snowflake database. You need to implement dynamic data masking on the 'CREDIT CARD' column in the 'TRANSACTIONS' table. The requirement is that users with the 'FINANCE ADMIN' role should see the full credit card number, while all other users should see only the last four digits. You have the following masking policy:
What is the next step to apply this masking policy to the 'CREDIT CARD' column?
You are designing a data protection strategy for a Snowflake database. You need to implement dynamic data masking on the 'CREDIT CARD' column in the 'TRANSACTIONS' table. The requirement is that users with the 'FINANCE ADMIN' role should see the full credit card number, while all other users should see only the last four digits. You have the following masking policy:
What is the next step to apply this masking policy to the 'CREDIT CARD' column?
정답: E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제15
You are implementing a data share between two Snowflake accounts. The provider account wants to grant the consumer account access to a function that returns anonymized customer data based on a complex algorithm. The provider wants to ensure that the consumer cannot see the underlying implementation details of the anonymization algorithm. Which of the following approaches can achieve this goal? (Select TWO)
You are implementing a data share between two Snowflake accounts. The provider account wants to grant the consumer account access to a function that returns anonymized customer data based on a complex algorithm. The provider wants to ensure that the consumer cannot see the underlying implementation details of the anonymization algorithm. Which of the following approaches can achieve this goal? (Select TWO)
정답: D,E
설명: (ITDumpsKR 회원만 볼 수 있음)