DEA-C02 practice questions 41–50

1. Question 41 · 126 in bank

   A Data Engineer has written a stored procedure that will run with caller's rights. The Engineer has granted ROLEA the right to use this stored procedure. What is a characteristic of the stored procedure being called using ROLEA?

   • AThe stored procedure must run with caller's rights; it cannot be converted later to run with owner's rights.
   • BIf the stored procedure accesses an object that ROLEA does not have access to, the stored procedure will fail.
   • CThe stored procedure will run in the context (database and schema) where the owner created the stored procedure.
   • DROLEA will not be able to see the source code for the stored procedure, even though the role has usage privileges on the stored procedure.

   Show answer

   Answer: B

   Next question

2. Question 42 · 126 in bank

   What is a characteristic of the use of binding variables in JavaScript stored procedures in Snowflake?

   • AAll types of JavaScript variables can be bound.
   • BAll Snowflake first-class objects can be bound.
   • COnly JavaScript variables of type number, string, and SfDate can be bound.
   • DUsers are restricted from binding JavaScript variables because they create SQL injection attack vulnerabilities.

   Show answer

   Answer: C

   Next question

3. Question 43 · 126 in bank

   Which use case would be BEST suited for the search optimization service?

   • AAnalysts who need to perform aggregates over high-cardinality columns.
   • BBusiness users who need fast response times using highly selective filters.
   • CData Scientists who seek specific JOIN statements with large volumes of data.
   • DData Engineers who create clustered tables with frequent reads against clustering keys.

   Show answer

   Answer: B

   Next question

4. Question 44 · 126 in bank

   What is a characteristic of the operations of streams in Snowflake?

   • AWhenever a stream is queried, the offset is automatically advanced.
   • BWhen a stream is used to update a target table, the offset is advanced to the current time.
   • CQuerying a stream returns all change records and table rows from the current offset to the current time.
   • DEach committed and uncommitted transaction on the source table automatically puts a change record in the stream.

   Show answer

   Answer: B

   Next question

5. Question 45 · 126 in bank

   At what isolation level are Snowflake streams?

   • ASnapshot
   • BRepeatable read
   • CRead committed
   • DRead uncommitted

   Show answer

   Answer: B

   Next question

6. Question 46 · 126 in bank

   What kind of Snowflake integration is required when defining an external function in Snowflake?

   • AAPI integration
   • BHTTP integration
   • CNotification integration
   • DSecurity integration

   Show answer

   Answer: A

   Next question

7. Question 47 · 126 in bank

   Select 2

   A Data Engineer is writing a Python script using the Snowflake Connector for Python. The Engineer will use the snowflake.connector.connect function to connect to Snowflake. The requirements are: Raise an exception if the specified database, schema, or warehouse does not exist Improve download performance - Which parameters of the connect function should be used? (Choose two.)

   • Aauthenticator
   • Barrow_number_to_decimal
   • Cclient_prefetch_threads
   • Dclient_session_keep_alive
   • Evalidate_default_parameters

   Show answer

   Answer: CE

   Next question

8. Question 48 · 126 in bank

   A Data Engineer wants to centralize grant management to maximize security. A user needs OWNERSHIP on a table in a new schema. However, this user should not have the ability to make grant decisions. What is the correct way to do this?

   • AGrant OWNERSHIP to the user on the table.
   • BRevoke grant decisions from the user on the table.
   • CRevoke grant decisions from the user on the schema.
   • DAdd the WITH MANAGED ACCESS parameter on the schema.

   Show answer

   Answer: D

   Next question

9. Question 49 · 126 in bank

   A CSV file, around 1 TB in size, is generated daily on an on-premise server. A corresponding table, internal stage, and file format have already been created in Snowflake to facilitate the data loading process. How can the process of bringing the CSV file into Snowflake be automated using the LEAST amount of operational overhead?

   • ACreate a task in Snowflake that executes once a day and runs a COPY INTO statement that references the internal stage. The internal stage will read the files directly from the on-premise server and copy the newest file into the table from the on-premise server to the Snowflake table.
   • BOn the on-premise server, schedule a SQL file to run using SnowSQL that executes a PUT to push a specific file to the internal stage. Create a task that executes once a day in Snowflake and runs a COPY INTO statement that references the internal stage. Schedule the task to start after the file lands in the internal stage.
   • COn the on-premise server, schedule a SQL file to run using SnowSQL that executes a PUT to push a specific file to the internal stage. Create a pipe that runs a COPY INTO statement that references the internal stage. Snowpipe auto-ingest will automatically load the file from the internal stage when the new file lands in the internal stage.
   • DOn the on-premise server, schedule a Python file that uses the Snowpark Python library. The Python script will read the CSV data into a DataFrame and generate an INSERT INTO statement that will directly load into the table. The script will bypass the need to move a file into an internal stage.

   Show answer

   Answer: B

   Next question

10. Question 50 · 126 in bank

    Select 3

    What are characteristics of Snowpark Python packages? (Choose three.)

    • AThird-party packages can be registered as a dependency to the Snowpark session using the session.import() method.
    • BPython packages can access any external endpoints.
    • CPython packages can only be loaded in a local environment.
    • DThird-party supported Python packages are locked down to prevent hitting.
    • EThe SQL command DESCRIBE FUNCTION will list the imported Python packages of the Python User-Defined Function (UDF).
    • FQuerying information_schema.packages will provide a list of supported Python packages and versions.

    Show answer

    Answer: AEF

    Next question

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

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