- All Exams Instant Download
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...
Please select what Alex is doing wrong here?
group by m.item_id; Step 3: After 1 hour, he decided to temporarily suspend the use (and maintenance) of the DataReportMV materialized view for cost saving purpose. alter materialized view DataReportMV suspend; Please select what Alex is doing wrong here?A . A materialized view, DataReportMV does not support Join operations, so...
Mark the Incorrect Statements with respect to types of streams supported by Snowflake?
Mark the Incorrect Statements with respect to types of streams supported by Snowflake?A . Standard streams cannot retrieve update data for geospatial data.B . An append-only stream returns the appended rows only and therefore can be much more performant than a standard stream for extract, load, transform (ELT).C . Insert-only...
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...
Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK … RESUME)?
Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK … RESUME)?A . SYSTEM$TASK_DEPENDENTSB . SYSTEM$TASK_DEPENDENTS_ENABLEC . SYSTEM$TASK_DEPENDENTS_RESUMED . SYSTEM$TASK_RECURSIVE_ENABLEView AnswerAnswer: C Explanation: In Snowflake, to recursively resume all tasks in a chain of tasks, the...
What are the Correct Statements to configure Partition metadata refresh in case of External Tables?
Snowflake computes and adds partitions based on the defined partition column expressions when an external table metadata is refreshed. What are the Correct Statements to configure Partition metadata refresh in case of External Tables?A . By default, the metadata is refreshed automatically when the object is created.B . The object...
Data Engineer is performing below steps in sequence while working on Stream s1 created on table t1.
Data Engineer is performing below steps in sequence while working on Stream s1 created on table t1. Step 1: Begin transaction. Step 2: Query stream s1 on table t1. Step 3: Update rows in table t1. Step 4: Query stream s1. Step 5: Commit transaction. Step 6: Begin transaction. Step...
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...
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 one of the following does not shows key similarities and differences between tables, regular views, cached query results, and materialized views while choosing any of them by David?
David, a Lead Data engineer with XYZ company looking out to improve query performance & other benefits while working with Tables, Regular Views, MVs and Cached Results. Which one of the following does not shows key similarities and differences between tables, regular views, cached query results, and materialized views while...
