CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. SnowPro Advanced Data Engineer

Free SnowPro Advanced Data Engineer Exam Braindumps (page: 3)

Page 2 of 18
PDF with 105 Questions

Given the table sales which has a clustering key of column CLOSED_DATE which table function will return the average clustering depth for the SALES_REPRESENTATIVE column for the North American region?









Answer(s): B

Explanation:

The table function SYSTEM$CLUSTERING_DEPTH returns the average clustering depth for a specified column or set of columns in a table. The function takes two arguments: the table name and the column name(s). In this case, the table name is sales and the column name is SALES_REPRESENTATIVE. The function also supports a WHERE clause to filter the rows for which the clustering depth is calculated. In this case, the WHERE clause is REGION = `North America'. Therefore, the function call in Option B will return the desired result.



What is the purpose of the BUILD_FILE_URL function in Snowflake?

  1. It generates an encrypted URL foe accessing a file in a stage.
  2. It generates a staged URL for accessing a file in a stage.
  3. It generates a permanent URL for accessing files in a stage.
  4. It generates a temporary URL for accessing a file in a stage.

Answer(s): B

Explanation:

The BUILD_FILE_URL function in Snowflake generates a temporary URL for accessing a file in a stage. The function takes two arguments: the stage name and the file path. The generated URL is valid for 24 hours and can be used to download or view the file contents. The other options are incorrect because they do not describe the purpose of the BUILD_FILE_URL function.



A Data Engineer has developed a dashboard that will issue the same SQL select clause to Snowflake every 12 hours.
---will Snowflake use the persisted query results from the result cache provided that the underlying data has not changed^

  1. 12 hours
  2. 24 hours
  3. 14 days
  4. 31 days

Answer(s): C

Explanation:

Snowflake uses the result cache to store the results of queries that have been executed recently. The result cache is maintained at the account level and is shared across all sessions and users. The result cache is invalidated when any changes are made to the tables or views referenced by the query. Snowflake also has a retention policy for the result cache, which determines how long the results are kept in the cache before they are purged. The default retention period for the result cache is 24 hours, but it can be changed at the account, user, or session level. However, there is a maximum retention period of 14 days for the result cache, which cannot be exceeded. Therefore, if the underlying data has not changed, Snowflake will use the persisted query results from the result cache for up to 14 days.



A Data Engineer ran a stored procedure containing various transactions During the execution, the session abruptly disconnected preventing one transaction from committing or rolling hark. The transaction was left in a detached state and created a lock on resources

...must the Engineer take to immediately run a new transaction?

  1. Call the system function SYSTEM$ABORT_TRANSACTION.
  2. Call the system function SYSTEM$CANCEL_TRANSACTION.
  3. Set the LOCK_TIMEOUT to FALSE in the stored procedure
  4. Set the transaction abort on error to true in the stored procedure.

Answer(s): A

Explanation:

The system function SYSTEM$ABORT_TRANSACTION can be used to abort a detached transaction that was left in an open state due to a session disconnect or termination. The function takes one argument: the transaction ID of the detached transaction. The function will abort the transaction and release any locks held by it. The other options are incorrect because they do not address the issue of a detached transaction. The system function SYSTEM$CANCEL_TRANSACTION can be used to cancel a running transaction, but not a detached one. The LOCK_TIMEOUT parameter can be used to set a timeout period for acquiring locks on resources, but it does not affect existing locks. The TRANSACTION_ABORT_ON_ERROR parameter can be used to control whether a transaction should abort or continue when an error occurs, but it does not affect detached transactions.






Post your Comments and Discuss Snowflake SnowPro Advanced Data Engineer exam with other Community members:

SnowPro Advanced Data Engineer Exam Discussions & Posts