- All Exams Instant Download
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...
What will happened when Different user queries the same stream after 1 hour?
When created, a stream logically takes an initial snapshot of every row in the source object and the contents of a stream change as DML statements execute on the source table. A Data Engineer, Sophie Created a view that queries the table and returns the CURRENT_USER and CURRENT_TIMESTAMP values for...
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...
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 System Function can be used by Data engineer to verify whether a stream contains changed data for a table?
Tasks may optionally use table streams to provide a convenient way to continuously process new or changed data. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table...
select system$clustering_depth('TPCH_CUSTOMERS', '(C1, C6)', 'C9 = 30'); on TPCH_CUSTOMERS table, will return which of the following?
Data Engineer, ran the below clustering depth analysis function: select system$clustering_depth('TPCH_CUSTOMERS', '(C1, C6)', 'C9 = 30'); on TPCH_CUSTOMERS table, will return which of the following?A . An error: this function does not accept lists of columns as a third parameter.B . An error: this function does not accept predicates ('C9...
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...
Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?
Tasks may optionally use table streams to provide a convenient way to continuously process new or changed data. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table...
at(timestamp => (select current_timestamp())); Select the Correct Query Execution Output option below:
at(timestamp => (select current_timestamp())); Select the Correct Query Execution Output option below:A . Developer missed to create stream on the source table which can further query to capture DML records.B . Select query will fail with error: 'SQL compilation error-Incorrect Keyword "Chang-es()" found'C . No Error reported, select command gives...
task_name=>'MYTASK'));
task_name=>'MYTASK'));View AnswerAnswer: D Explanation: To retrieve only tasks that are completed or still running, filter the query using WHERE query_id IS NOT NULL.
