- All Exams Instant Download
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...
Partition columns optimize query performance by pruning out the data files that do not need to be scanned (i.e. partitioning the external table).
Partition columns optimize query performance by pruning out the data files that do not need to be scanned (i.e. partitioning the external table). Which pseudocolumn of External table evaluate as an expression that parses the path and/or filename information.A . METADATA$ROW_NUMBERB . METADATA$COLUMNNAMEC . METADATA$FILEPATHD . METADATA$FILENAMEView AnswerAnswer: C Explanation:...
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...
Snowflake does not provide which of following set of SQL functions to support retrieving information about tasks?
Snowflake does not provide which of following set of SQL functions to support retrieving information about tasks?A . SYSTEM$CURRENT_USER_TASK_NAMEB . TASK_HISTORYC . TASK_DEPENDENTSD . TASK_QUERY_HISTORYE . SYSTEM$TASK_DEPENDENTS_ENABLEView AnswerAnswer: C Explanation: SYSTEM$CURRENT_USER_TASK_NAME Returns the name of the task currently executing when invoked from the statement or stored procedure defined by the...
Which column provides information when the stream became stale or may become stale if not consumed?
Which column provides information when the stream became stale or may become stale if not consumed?A . STREAM_STALE_PERIODB . STALE_PERIOD_AFTERC . STALE_STREAM_PERIODD . STALE_AFTERView AnswerAnswer: D Explanation: execute SHOW STREAMS command. Column Name: STALE_AFTER Timestamp when the stream became stale or may become stale if not consumed. The value is...
To advance the offset of a stream to the current table version without consuming the change data in a DML operation, which of the following operations can be done by Data Engineer? [Select 2]
To advance the offset of a stream to the current table version without consuming the change data in a DML operation, which of the following operations can be done by Data Engineer? [Select 2]A . using the CREATE OR REPLACE STREAM syntax, Recreate the STREAMB . Insert the current change...
Which Best techniques she should consider here?
Melissa, Senior Data Engineer, looking out to optimize query performance for one of the Critical Control Dashboard, she found that most of the searches by the users on the control dashboards are based on Equality search on all the underlying columns mostly. Which Best techniques she should consider here?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...
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...
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...
