- All Exams Instant Download
How Robert in this case, Resume this stale pipe?
Robert, A Data Engineer, found that Pipe become stale as it was paused for longer than the limited retention period for event messages received for the pipe (14 days by default) & also the previous pipe owner transfers the ownership of this pipe to Robert role while the pipe was...
Mark the Correct Statements:
Mark the Correct Statements: Statement 1. Snowflake’s zero-copy cloning feature provides a convenient way to quickly take a “snapshot” of any table, schema, or database. Statement 2. Data Engineer can use zero-copy cloning feature for creating instant backups that do not incur any additional costs (until changes are made to...
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?A . TRUEB . FALSEView AnswerAnswer: A Explanation: The CREATE EXTERNAL TABLE syntax for manually added partitions is...
The smaller the average depth, the better clustered the table is with regards to the specified column?
The smaller the average depth, the better clustered the table is with regards to the specified column?A . TRUEB . FALSEView AnswerAnswer: A
But he wants to view all errors in the files along with Load status, how he can check all errors?
Marko, a Data Engineer is using Snowpipe for data loading in micro batches for one of the Finance Data workloads. There are set of files he attempted to load into the snowflake table using Snow-pipe. While monitoring he found that there are set of files has multiple issue, He queried...
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...
Mark the correct Statements with respect to Secure views & its creation in the SnowFlake Account?
Mark the correct Statements with respect to Secure views & its creation in the SnowFlake Account? A. For a secure view, internal optimizations can indirectly expose data & the view definition is visible to other users. B. Secure views should not be used for views that are defined solely for...
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...
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...
Search optimization works best to improve the performance of a query when the following conditions are true: [Select All that apply]
Search optimization works best to improve the performance of a query when the following conditions are true: [Select All that apply]A . The table is not clustered.B . The table is frequently queried on columns other than the primary cluster key.C . Search Query uses Equality predicates (for example, <column_name>...
