Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Snowflake SnowPro Advanced Data Engineer

Snowflake SnowPro Advanced Data Engineer Exam Practice Questions (P. 5)

  • Full Access (65 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
Which output is provided by both the SYSTEM$CLUSTERING_DEPTH function and the SYSTEM$CLUSTERING_INFORMATION function?
  1. A
    average_depth
  2. B
    notes
  3. C
    average_overlaps
  4. D
    total_partition_count

Correct Answer:
A
chatbot-img GPT-4o - Answer
The correct answer is indeed A, "average_depth." Both the SYSTEM$CLUSTERING_DEPTH and SYSTEM$CLUSTERING_INFORMATION functions in Snowflake provide the "average_depth" output. This metric is crucial for understanding the distribution and depth of data clustering within Snowflake tables, aiding in efficient querying and data management practices.

Question #22
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?
  1. A
    Use Snowpipe to ingest the files that land in an external stage into a Snowflake table.
  2. B
    Use a COPY INTO command to ingest the PDF files in an external stage into a Snowflake table with a VARIANT column.
  3. C
    Create an external table on the PDF files that are stored in a stage and parse the data into structured data.
  4. D
    Create a Java User-Defined Function (UDF) that leverages Java-based PDF parser libraries to parse PDF data into structured data.

Correct Answer:
D

Question #23
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?
  1. A
    Wait until the metadata expires and then reload the file using Snowpipe.
  2. B
    Modify the file by adding a blank row to the bottom and re-stage the file.
  3. C
    Set the FORCE=TRUE option in the Snowpipe COPY INTO command.
  4. D
    Recreate the pipe by using the CREATE OR REPLACE PIPE command.

Correct Answer:
C

Question #24
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?
  1. A
    TRANSACTIONS_STM will keep working as expected.
  2. B
    TRANSACTIONS_STM will be stale and will need to be re-created.
  3. C
    TRANSACTIONS_STM will be automatically renamed TRANSACTIONS_RAW_STM.
  4. D
    Reading from the TRANSACTIONS_STM stream will succeed for some time after the expected STALE_TIME.

Correct Answer:
B

Question #25
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.)
  1. A
    Add a LIMIT to the ORDER BY if possible
  2. B
    Use a multi-cluster virtual warehouse with the scaling policy set to standard
  3. C
    Move the query to a larger virtual warehouse
  4. D
    Create indexes to ensure sorted access to data
  5. E
    Increase the MAX_CLUSTER_COUNT

Correct Answer:
AC

Previous Questions Next Questions

All Pages