- All Exams Instant Download
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...
John, Data Engineer, do have technical requirements to refresh the External tables Metadata periodically or in auto mode, which approach John can take to meet this technical specification?
John, Data Engineer, do have technical requirements to refresh the External tables Metadata periodically or in auto mode, which approach John can take to meet this technical specification?A . John can use AUTO_REFRESH parameter if the underlying External Cloud host sup-ports this for External tables.B . He can create a...
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...
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...
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...
Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?
Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and...
Which one is not the limitation he must be aware of before using MVs in their use case?
Data Engineer identified use case where he decided to use materialized view for query performance. Which one is not the limitation he must be aware of before using MVs in their use case?A . Truncating a materialized view is not supported.B . Time Travel is not currently supported on materialized...
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.
Which of the following security and governance tools/technologies are known to provide native connectivity to Snowflake? [Select 2]
Which of the following security and governance tools/technologies are known to provide native connectivity to Snowflake? [Select 2]A . ALTRB . BaffleC . BIG SquidD . DataikuE . ZeplView AnswerAnswer: A, B Explanation: Security and governance tools ensure sensitive data maintained by an organization is protected from inappropriate access and...
