DEA-C02 practice questions 61–70

1. Question 61 · 126 in bank

   Assuming that the session parameter USE_CACHED_RESULT is set to false, what are characteristics of Snowflake virtual warehouses in terms of the use of Snowpark?

   • ACreating a DataFrame from a table will start a virtual warehouse.
   • BCreating a DataFrame from a staged file with the read() method will start a virtual warehouse.
   • CTransforming a DataFrame with methods like replace() will start a virtual warehouse.
   • DCalling a Snowpark stored procedure to query the database with session.call() will start a virtual warehouse.

   Show answer

   Answer: D

   Next question

2. Question 62 · 126 in bank

   Database XYZ has the data_retention_time_in_days parameter set to 7 days and table XYZ.public.ABC has the data_retention_time_in_days set to 10 days. A Developer accidentally dropped the database containing this single table 8 days ago and just discovered the mistake. How can the table be recovered?

   • Aundrop database xyz;
   • Bcreate table abc_restore as select * from xyz.public.abc at (offset => -60*60*24*8);
   • Ccreate table abc_restore clone xyz.public.abc at (offset => -3600*24*8);
   • DCreate a Snowflake Support case to restore the database and table from Fail-safe.

   Show answer

   Answer: D

   Next question

3. Question 63 · 126 in bank

   Select 2

   A Data Engineer is building a set of reporting tables to analyze consumer requests by region for each of the Data Exchange offerings annually, as well as click-through rates for each listing. Which views are needed MINIMALLY as data sources?

   • ASNOWFLAKE.DATA_SHARING_USAGE.LISTING_EVENTS_DAILY
   • BSNOWFLAKE.DATA_SHARING_USAGE.LISTING_CONSUMPTION_DAILY
   • CSNOWFLAKE.DATA_SHARING_USAGE.LISTING_TELEMETRY_DAILY
   • DSNOWFLAKE.ACCOUNT_USAGE.DATA_TRANSFER_HISTORY

   Show answer

   Answer: BC

   Next question

4. Question 64 · 126 in bank

   The following code is executed in a Snowflake environment with the default settings:

   

   What will be the result of the select statement?

   • ASQL compilation error: Object 'CUSTOMER' does not exist or is not authorized.
   • BJohn
   • C1
   • D1John

   Show answer

   Answer: C

   Next question

5. Question 65 · 126 in bank

   A Data Engineer defines the following masking policy:

   

   The policy must be applied to the full_name column in the customer table:

   

   Which query will apply the masking policy on the full_name column?

   • AALTER TABLE customer MODIFY COLUMN full_name SET MASKING POLICY name policy;
   • BALTER TABLE customer MODIFY COLUMN full_name ADD MASKING POLICY name_policy;
   • CALTER TABLE customer MODIFY COLUMN first_name SET MASKING POLICY name_policy, last_name SET MASKING POLICY name_policy;
   • DALTER TABLE customer MODIFY COLUMN first_name ADD MASKING POLICY name_policy, last_name SET MASKING POLICY name_policy;

   Show answer

   Answer: C

   Next question

6. Question 66 · 126 in bank

   Select 2

   The following stored procedure has been created to load orders for a single date into a target table: create or replace procedure uspLoadOrdersByDate () returns string language javascript execute as owner as ' sqlCmd = `INSERT INTO ORDERS_BY_DATE_TGT SELECT * FROM ORDERS_BY_DATE WHERE O_ORDERDATE = $dateToProcess`; sqlStmt = snowflake.createStatement({sqlText: sqlCmd}); res = sqlStmt.execute(); res.next(); return res.GetColumnValue(1); '; Upon executing the following statements, the following error is returned: set dateToProcess = '2020-08-02'; call uspLoadOrdersByDate(); Execution error in store procedure USPLOADORDERSBYDATE: Use of session variable '$DATETOPROCESS' is not allowed in owners rights stored procedure At Statement.execute, line 4 position 14 Making what changes will allow the procedure to execute successfully? (Choose two.)

   • AChange the procedure to EXECUTE AS CALLER.
   • BCreate a scheduled task to execute the procedure each day, and set dateToProcess = CURRENT_DATE() as a session parameter at the task level.
   • CModify the body of the procedure to cast $dateToProcess to DATE within the WHERE clause of the INSERT statement.
   • DChange the procedure to accept $dateToProcess as an input parameter so that no session variables are used within the procedure itself.
   • ERename the session variable to upper case to allow the procedure to read from it.

   Show answer

   Answer: AD

   Next question

7. Question 67 · 126 in bank

   Select 3

   Which of the following grants are required for the role kafka_load_role_1 running the Snowflake Connector for Kafka, with the intent of loading data to Snowflake? (Choose three.) (Assume this role already exists and has usage access to the schema kafka_schema in database kafka_db, the target for data loading.)

   • Agrant create pipe on schema kafka_schema to role kafka_load_role_1;
   • Bgrant create stream on schema kafka_schema to role kafka_load_role_1;
   • Cgrant create stage on schema kafka_schema to role kafka_load_role_1;
   • Dgrant create table on schema kafka_schema to role kafka_load_role_1;
   • Egrant create task on schema kafka_schema to role kafka_load_role_1;
   • Fgrant create external table on schema kafka_schema to role kafka_load_role_1;

   Show answer

   Answer: ACD

   Next question

8. Question 68 · 126 in bank

   A Data Engineer creates a pipe called mypipe. What command needs to be run to verify that the pipe is configured correctly and is running?

   • Ashow pipes like 'mypipe'
   • Bselect system$pipe_status('public.mypipe')
   • Cdescribe pipe 'public.mypipe'
   • Dselect system$verify_pipe('public.mypipe')

   Show answer

   Answer: B

   Next question

9. Question 69 · 126 in bank

   A Data Engineer runs the following sequence: use role ACCOUNTADMIN; create role ROLE1; grant role ROLE1 to role ACCOUNTADMIN; grant create database on account to role ROLE1; use role ROLE1; create database DB1; use role ACCOUNTADMIN; drop role ROLE1; Who is the owner of database DB1?

   • AThe deleted ROLE1 remains the owner of the DB1 database.
   • BThe ACCOUNTADMIN becomes the owner of the DB1 database.
   • CROLE1, because the role cannot be dropped as long as it owns the DB1 database.
   • DDatabase DB1 has no owner.

   Show answer

   Answer: B

   Next question

10. Question 70 · 126 in bank

    What action could a Data Engineer take to increase the query performance of an external table?

    • AAdd a clustering key to the external table.
    • BEnable the search optimization service on the external table.
    • CCreate a materialized view on the external table.
    • DSet the USE_CACHED_RESULTS parameter to True for the external table.

    Show answer

    Answer: C

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DEA-C02 practice, question 61. 126 questions available.