Free Snowflake DEA-C02 Exam Dumps Questions & Answers

You have a table 'SALES DATA' in your production environment. You want to create a development environment using cloning, but only want to include data up to a specific point in time to minimize storage costs and potential exposure of recent, sensitive data'. You know there were significant changes to the 'SALES DATA' table structure on '2024-01-15'. Your goal is to create a clone that only includes the structure as of '2024-01-14'. Which Snowflake command is MOST appropriate for this scenario?

• A. 
• B. 
• C. 
• D. 
• E. 

You have a base table 'ORDERS' with columns 'ORDER ID, 'CUSTOMER D', 'ORDER DATE, and 'ORDER AMOUNT'. You need to create a view that aggregates the total order amount per customer per month. However, for data governance purposes, you need to ensure that the view only shows data for the last 3 months. What is the MOST efficient and secure way to create this view in Snowflake?

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

You are tasked with optimizing a Snowpipe Streaming pipeline that ingests data from Kafka into a Snowflake table named 'ORDERS' You notice that while the Kafka topic has high throughput, the data ingestion into Snowflake is lagging. The pipe definition is as follows: "sql CREATE OR REPLACE PIPE ORDERS_PIPEAS COPY INTO ORDERS FROM @KAFKA STAGE FILE_FORMAT = (TYPE = JSON); Which of the following actions, taken individually, would be MOST effective in improving the ingestion rate, assuming sufficient compute resources are available in your Snowflake virtual warehouse?

• A.  Implement batching within the Kafka producer to send larger messages.
• B.  Increase the number of Kafka partitions and ensure Snowflake has enough compute to consume them in parallel using Snowpipe Streaming.
• C.  Tune the parameter in the file format definition to a smaller value.
• D.  Increase the size of the virtual warehouse associated with the Snowflake account.
• E.  Enable auto-ingest for the Snowpipe.

You are tasked with implementing a data loading process for a table 'CUSTOMER DATA' in Snowflake. The source data is in Parquet format on Azure Blob Storage and contains personally identifiable information (PII). You must ensure that the data is loaded securely, masked during the loading process, and that only authorized users can access the unmasked data after the load. Assume you have already created a stage pointing to the Azure Blob Storage. Which of the following steps should you take to achieve this?

• A.  Load the data without masking. Implement dynamic data masking policies on the table's PII columns using Snowflake's Enterprise edition features. Use a 'COPY' command with ERROR = CONTINUE
• B.  Use a 'COPY command with the 'ENCRYPTION = (TYPE = 'AZURE CSE', KEY = option to encrypt the data during load. Implement role-based access control to restrict access to the table.
• C.  Use a 'COPY command with the 'TRANSFORM' clause and JavaScript UDFs to mask the PII data during the load process. Implement masking policies on the 'CUSTOMER DATA' table to restrict access to the unmasked data.
• D.  Use a 'COPY command with 'ON ERROR = SKIP FILE'. Use a Task to monitor load failures and trigger alerts.
• E.  Load the data directly into a 'VARIANT column. Use a SQL transformation with 'FLATTEN' and masking policies on the extracted columns.

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?

• A.  Set the 'DISABLE MASKING' session parameter to 'TRUE' for the batch job session. This will temporarily disable all masking policies.
• B.  Create a temporary view on the 'EMPLOYEES' table without the 'SSN' column, grant access to the view for the batch job, and drop the view after the job is complete.
• C.  Create a new role with 'ACCOUNTADMIN' privileges, assign this role to the batch job process during the execution, and then revert back to the original role after the job is done.
• D.  Grant the 'APPLY MASKING POLICY privilege to the user running the batch job, allowing them to bypass the masking policy.
• E.