Snowflake DEA-C02 시험 개요:

Snowflake DEA-C02 시험 요강 주제:

최신 SnowPro Advanced DEA-C02 무료샘플문제

문제 #1
You have a table named 'ORDERS' with a column 'ORDER DETAILS' that contains JSON data'. You want to extract a specific nested value ('customer id') from this JSON data using a SQL UDE The JSON structure varies, and sometimes the 'customer id' field might be missing. You need to create a UDF that handles missing fields gracefully and returns NULL if 'customer id' is not found. Also, You are looking for a performant solution that is highly scalable. Which of the following SQL UDF definitions is most appropriate?

A.

B.

C.

D.

E.

문제 #2
You are tasked with creating a SQL UDF in Snowflake to mask sensitive customer data (email addresses) before it's used in a reporting dashboard. The masking should replace all characters before the '@' symbol with asterisks, preserving the domain part. For example, '[email protected]' should become ' @example.com'. Which of the following SQL UDF definitions correctly implements this masking logic, while minimizing the impact on Snowflake compute resources?

A. Option C
B. Option B
C. Option A
D. Option D
E. Option E

문제 #3
You are tasked with designing a solution to ingest a continuous stream of unstructured log data from various sources into Snowflake. The log data includes text, JSON, and XML formats. The goal is to efficiently store the data, allow for flexible querying, and minimize storage costs. Which of the following approaches would BEST address these requirements? (Select TWO)

A. Create separate tables for each log data format (text, JSON, XML).
B. Pre-process the log data to convert all formats into a standardized JSON format before ingestion.
C. Ingest all log data into a single VARIANT column in a Snowflake table.
D. Use Snowflake's external functions to parse the log data during query execution.
E. Ingest all data 'as is' into a raw staging table. Then create a Task that use Python UDF to parse data and save it to different tables as required

문제 #4
You are monitoring a Snowpipe pipeline that loads data from an external stage into a Snowflake table. You observe the following error messages in the PIPE ERRORS view: 'Invalid UTF-8 detected in string'. The data files on the stage are encoded in UTF-8. Which of the following actions, taken individually or in combination, are MOST likely to resolve this issue? (Select TWO)

A. Ensure the file format definition explicitly specifies 'ENCODING = 'UTF8".
B. Drop and recreate the external stage with 'TYPE = INTERNAL'.
C. Convert the problematic files to UTF-16 encoding before loading them into the stage.
D. Modify the COPY INTO statement to include the 'ON ERROR = 'SKIP_FILE" option.
E. Verify the data files on the stage are actually valid UTF-8 and contain no corrupted characters.

문제 #5
A financial services company stores sensitive customer data, including credit card numbers, in a Snowflake table called 'CUSTOMER DATA. You need to implement dynamic data masking on the 'CREDIT CARD NUMBER column. You want to ensure that only users with the FINANCE ADMIN' role can view the unmasked credit card numbers. All other users should see a masked version of the data'. Which of the following set of commands is the MOST efficient and secure way to achieve this?

A. Option C
B. Option B
C. Option A
D. Option D
E. Option E

질문과 대답: