- All Exams Instant Download
Which option he can choose to remove these files either during data loading or afterwards?
To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards? A. He...
He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?
Stuart, a Lead Data Engineer in MACRO Data Company created streams on set of External tables. He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?A . MAX_DATA_EXTENSION_TIME_IN_DAYSB . DATA_RETENTION_TIME_IN_DAYSC . DATA_EXTENSION_TIME_IN_DAYSD . None of...
If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?
Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?A . TRUEB . FALSEC . UPDATED . INSERTView AnswerAnswer: B Explanation: Stream Columns A stream stores an offset for the...
He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?
Stuart, a Lead Data Engineer in MACRO Data Company created streams on set of External tables. He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?A . MAX_DATA_EXTENSION_TIME_IN_DAYSB . DATA_RETENTION_TIME_IN_DAYSC . DATA_EXTENSION_TIME_IN_DAYSD . None of...
Which option he can choose to remove these files either during data loading or afterwards?
To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards? A. He...
Regular views do not cache data, and therefore cannot improve performance by caching?
Regular views do not cache data, and therefore cannot improve performance by caching?A . TRUEB . FALSEView AnswerAnswer: A Explanation: Regular views do not cache data, and therefore cannot improve performance by caching.
print(cur.sfqid)
print(cur.sfqid) B. When he used the Snowflake Connector for Python to execute a query, he can access the query ID through the pyqueryid attribute in the Cursor object. C. He needs to query history views to get the queryID as best practices. D. Using python connector, snowflake does not support...
The Above example indicates that the SF_DATA table is not well-clustered for which of following valid reasons?
The Above example indicates that the SF_DATA table is not well-clustered for which of following valid reasons?A . Zero (0) constant micro-partitions out of 1156 total micro-partitions.B . High average of overlapping micro-partitions.C . High average of overlap depth across micro-partitions.D . Most of the micro-partitions are grouped at the...
Which option he can choose to remove these files either during data loading or afterwards?
To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards? A. He...
Which option he can choose to remove these files either during data loading or afterwards?
To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards? A. He...
