Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam DEA-C01 Topic 1 Question 32 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 32
Topic #: 1
[All DEA-C01 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

This option is the best way to ensure that Snowpipe is performant while minimizing costs. By splitting the files before loading them, the Data Engineer can reduce the size of each file and increase the parallelism of loading. By setting the SIZE_LIMIT option to 250 MB, the Data Engineer can specify the maximum file size that can be loaded by Snowpipe, which can prevent performance degradation or errors due to large files. The other options are not optimal because:

Increasing the size of the virtual warehouse used by Snowpipe will increase the performance but also increase the costs, as larger warehouses consume more credits per hour.

Changing the file compression size and increasing the frequency of the Snowpipe loads will not have much impact on performance or costs, as Snowpipe already supports various compression formats and automatically loads files as soon as they are detected in the stage.

Decreasing the buffer size to trigger delivery of files sized between 100 to 250 MB in Kinesis Firehose will not affect Snowpipe performance or costs, as Snowpipe does not depend on Kinesis Firehose buffer size but rather on its own SIZE_LIMIT option.


Contribute your Thoughts:

Tyra
5 days ago
But wouldn't setting transaction abort on error to true prevent similar issues in the future?
upvoted 0 times
...
Tommy
7 days ago
I disagree, I believe setting LOCK_TIMEOUT to FALSE would be a better option.
upvoted 0 times
...
Tyra
11 days ago
I think the Engineer should call SYSTEM$CANCEL_TRANSACTION.
upvoted 0 times
...

Save Cancel