- All Exams Instant Download
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.
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...
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...
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...
Steven created the task, what additional privileges required by Steven on the task so that he can suspend or resume the tasks?
Steven created the task, what additional privileges required by Steven on the task so that he can suspend or resume the tasks?A . Steven is already owner of the task; he can execute the task & suspend/resume the task without any additional privileges.B . In addition to the task owner,...
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...
