DEA-C02 practice questions 71–80

1. Question 71 · 126 in bank

   When using a stored procedure in Snowflake, how many threads can the Snowflake API run concurrently?

   • A1
   • B8
   • CAn unlimited number
   • DThe number is dependent on the size of the virtual warehouse.

   Show answer

   Answer: A

   Next question

2. Question 72 · 126 in bank

   To meet governance requirements, a company needs to completely isolate its production environment from its development and testing environments. The solution must prevent zero-copy cloning from occurring. How can these requirements be met?

   • ACreate one account and ensure that strict process controls are in place including a strict Role-based Access Control (RBAC) strategy.
   • BCreate one account that includes one database for each business function. Within the database, use separate schemas to isolate production, development, and test environments.
   • CCreate one account that separates the production, development, and testing environments by database. Use Role-based Access Control (RBAC) to further isolate these environments based on roles/grants.
   • DCreate three separate accounts, one each for the production, development, and testing environments, and manage each account individually.

   Show answer

   Answer: D

   Next question

3. Question 73 · 126 in bank

   A Data Engineer would like to create a new empty table named CURRENT_STUDENT_COPY_DATA that has the same structure as the table CURRENT_STUDENT. Which statement should be used?

   • ACREATE TABLE current_student_copy_data COPY current_student;
   • BCREATE TABLE current_student_copy_data CLONE current_student COPY_DATA=false;
   • CCREATE TABLE current_student_copy_data CLONE current_student;
   • DCREATE TABLE current_student_copy_data LIKE current_student;

   Show answer

   Answer: D

   Next question

4. Question 74 · 126 in bank

   A Data Engineer has created table T1 with DATA_RETENTION_TIME_IN_DAYS set to 7. There is a default stream S1 on table T1. The parameter MAX_DATA_EXTENSION_TIME_IN_DAYS is set to 10 for table T1. Based on these parameters, at MINIMUM, how frequently do the contents of stream S1 need to be consumed so that the stream does not become stale?

   • AEvery 3 days
   • BEvery 7 days
   • CEvery 10 days
   • DEvery 30 days

   Show answer

   Answer: C

   Next question

5. Question 75 · 126 in bank

   The following FLATTEN command is run: select * from table(flatten(input => parse_json('{"first_name":"joe", "last_name": "smith" "location": {"state":"co", }}'), recursive => true )) f; How many rows will be returned?

   • A1 row
   • B2 rows
   • C3 rows
   • D4 rows

   Show answer

   Answer: D

   Next question

6. Question 76 · 126 in bank

   A Data Engineer made modifications to staged files and re-staged them. A pipe is running but the changed data is not appearing in the table. What step should the Engineer take in order to see the changed data without duplicating data?

   • ARun the CREATE or REPLACE PIPE syntax.
   • BRe-run the pipe by using the RELOAD PIPE syntax.
   • CRe-run the pipe by using the ONLY_CHANGES syntax.
   • DCreate new files with the changed data.

   Show answer

   Answer: D

   Next question

7. Question 77 · 126 in bank

   A Data Engineer is building a data pipeline to ingest incremental data from a data source using streams and tasks in Snowflake. A stream is created on a CUSTOMER_RAW table to track the new records and merge them into a CUSTOMER master table by way of a task that runs every hour. What will occur if the CUSTOMER_RAW table gets renamed to CUSTOMER_BASE after the task runs for three days?

   • AThe DESCRIBE STREAM for the stream will show the value of the STALE column as TRUE.
   • BThe renaming will cause no disruption to the existing data pipeline.
   • CThe DESCRIBE STREAM for the stream will show the value of the STALE column as FALSE.
   • DThe TASK_HISTORY for the subsequent run will show an error after the renaming operation.

   Show answer

   Answer: B

   Next question

8. Question 78 · 126 in bank

   Select 2

   What considerations should a Data Engineer make when leveraging the table function TASK_HISTORY? (Choose two.)

   • AQuerying TASK_HISTORY will return only in progress or completed task executions.
   • BFor the task of interest to be returned, it must have been triggered within the last 30 days.
   • CA user querying the table function must be the owner of the task or have elevated privileges.
   • DA RESULT_LIMIT parameter must be provided during execution because TASK_HISTORY is a table function.
   • EAny parameters used in the TASK_HISTORY table function will take precedent before SQL limiting functions.

   Show answer

   Answer: BC

   Next question

9. Question 79 · 126 in bank

   A table, mytable, is created using the following command in a schema called raw: create table mytable(col1 number, col2 date) data_retention_time_in_days=90; The DATA_RETENTION_TIME_IN_DAYS is set to 30 days for the raw schema. If the raw schema gets dropped today, for how many days will the data in mytable be accessible through Time Travel?

   • A0 days
   • B30 days
   • C90 days
   • D120 days

   Show answer

   Answer: B

   Next question

10. Question 80 · 126 in bank

    Select 2

    A Data Engineer is creating a pipe by executing the following statement: create or replace pipe mypipe auto_ingest=true as copy into mytable from @mystage; The Data Engineer adds a file data.csv.gz to the stage and it successfully loads into the table mytable. What will cause the file data.csv.gz to be loaded a second time? (Choose two.)

    • Acopy into mytable from @mystage;
    • Btruncate table mytable; alter pipe mypipe refresh;
    • Cdrop table mytable; create table mytable (coll string,...)
    • Dcreate or replace pipe mypipe auto_ingest=true as copy into mytable from @mystage; alter pipe mypipe refresh;
    • EThe file will automatically be reloaded a second time after eight days.

    Show answer

    Answer: CD

    Next question

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

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