DEA-C02 practice questions 21–30

1. Question 21 · 126 in bank

   Which output is provided by both the SYSTEM$CLUSTERING_DEPTH function and the SYSTEM$CLUSTERING_INFORMATION function?

   • Aaverage_depth
   • Bnotes
   • Caverage_overlaps
   • Dtotal_partition_count

   Show answer

   Answer: A

   Next question

2. Question 22 · 126 in bank

   A Data Engineer needs to ingest invoice data in PDF format into Snowflake so that the data can be queried and used in a forecasting solution. What is the recommended way to ingest this data?

   • AUse Snowpipe to ingest the files that land in an external stage into a Snowflake table.
   • BUse a COPY INTO command to ingest the PDF files in an external stage into a Snowflake table with a VARIANT column.
   • CCreate an external table on the PDF files that are stored in a stage and parse the data into structured data.
   • DCreate a Java User-Defined Function (UDF) that leverages Java-based PDF parser libraries to parse PDF data into structured data.

   Show answer

   Answer: D

   Next question

3. Question 23 · 126 in bank

   A table is loaded using Snowpipe and truncated afterwards. Later, a Data Engineer finds that the table needs to be reloaded, but the metadata of the pipe will not allow the same files to be loaded again. How can this issue be solved using the LEAST amount of operational overhead?

   • AWait until the metadata expires and then reload the file using Snowpipe.
   • BModify the file by adding a blank row to the bottom and re-stage the file.
   • CSet the FORCE=TRUE option in the Snowpipe COPY INTO command.
   • DRecreate the pipe by using the CREATE OR REPLACE PIPE command.

   Show answer

   Answer: D

   Next question

4. Question 24 · 126 in bank

   A stream called TRANSACTIONS_STM is created on top of a TRANSACTIONS table in a continuous pipeline running in Snowflake. After a couple of months, the TRANSACTIONS table is renamed TRANSACTIONS_RAW to comply with new naming standards. What will happen to the TRANSACTIONS_STM object?

   • ATRANSACTIONS_STM will keep working as expected.
   • BTRANSACTIONS_STM will be stale and will need to be re-created.
   • CTRANSACTIONS_STM will be automatically renamed TRANSACTIONS_RAW_STM.
   • DReading from the TRANSACTIONS_STM stream will succeed for some time after the expected STALE_TIME.

   Show answer

   Answer: A

   Next question

5. Question 25 · 126 in bank

   Select 2

   A Data Engineer is evaluating the performance of a query in a development environment.

   

   

   Based on the Query Profile, what are some performance tuning options the Engineer can use? (Choose two.)

   • AAdd a LIMIT to the ORDER BY if possible
   • BUse a multi-cluster virtual warehouse with the scaling policy set to standard
   • CMove the query to a larger virtual warehouse
   • DCreate indexes to ensure sorted access to data
   • EIncrease the MAX_CLUSTER_COUNT

   Show answer

   Answer: AC

   Next question

6. Question 26 · 126 in bank

   Select 2

   Which methods will trigger an action that will evaluate a DataFrame? (Choose two.)

   • ADataFrame.random_split()
   • BDataFrame.collect()
   • CDataFrame.select()
   • DDataFrame.col()
   • EDataFrame.show()

   Show answer

   Answer: BE

   Next question

7. Question 27 · 126 in bank

   Select 3

   Which Snowflake objects does the Snowflake Kafka connector use? (Choose three.)

   • APipe
   • BServerless task
   • CInternal user stage
   • DInternal table stage
   • EInternal named stage
   • FStorage integration

   Show answer

   Answer: ADE

   Next question

8. Question 28 · 126 in bank

   A Data Engineer has created table t1 with one column c1 with datatype VARIANT: create or replace table t1 (c1 variant); The Engineer has loaded the following JSON data set, which has information about 4 laptop models, into the table.

   

   The Engineer now wants to query that data set so that results are shown as normal structured data. The result should be 4 rows and 4 columns, without the double quotes surrounding the data elements in the JSON data. The result should be similar to the use case where the data was selected from a normal relational table t2, where t2 has string data type columns model_id, model, manufacturer, and model_name, and is queried with the SQL clause select * from t2; Which select command will produce the correct results?

   • A//IMG//
   • B//IMG//
   • C//IMG//
   • D//IMG//

   Show answer

   Answer: B

   Next question

9. Question 29 · 126 in bank

   What is a characteristic of the use of external tokenization?

   • ASecure data sharing can be used with external tokenization.
   • BExternal tokenization cannot be used with database replication.
   • CPre-loading of unmasked data is supported with external tokenization.
   • DExternal tokenization allows the preservation of analytical values after de-identification.

   Show answer

   Answer: D

   Next question

10. Question 30 · 126 in bank

    Select 3

    A Data Engineer is implementing a near real-time ingestion pipeline to load data into Snowflake using the Snowflake Kafka connector. There will be three Kafka topics created. Which Snowflake objects are created automatically when the Kafka connector starts? (Choose three.)

    • ATables
    • BTasks
    • CPipes
    • DInternal stages
    • EExternal stages
    • FMaterialized views

    Show answer

    Answer: ACD

    Next question

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

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