Udemy Snowpro Core Certification -
Practice Questions Test 5 with Complete
Solutions
Which of the following semi-structured file formats are supported by Snowflake? - ANSWER - -
XML
- Parquret
- JSON
The load metadata for a table expires after how many days? - ANSWER - 64
t/f Is snowpipe serverless? - ANSWER - True
Which of the following statements are true for Snowpipe? - ANSWER - - Snowpipe uses
servless compute resources managed by Snowflake
- The resource for snowpipe are automatically scaled up and down by snowflake
Which of the following can be used to download data from an external stage to an on-premises
system? - ANSWER - Cloud Provider Utilities
Snowflake provides which of the following methods of data loading? - ANSWER - - Continuous
- Bulk
Under which circumstances will the query result cache fulfill the query result? - ANSWER - - The
role executing the query matches the role that generated the previous results
- The query results cache was generated or used less than 24 hours ago
- The micro partitions for the tables in the query have not changed
True or False: Cluster keys should be changed only during off-peak hours to avoid blocking
DML statements. - ANSWER - False
Practice Questions Test 5 with Complete
Solutions
Which of the following semi-structured file formats are supported by Snowflake? - ANSWER - -
XML
- Parquret
- JSON
The load metadata for a table expires after how many days? - ANSWER - 64
t/f Is snowpipe serverless? - ANSWER - True
Which of the following statements are true for Snowpipe? - ANSWER - - Snowpipe uses
servless compute resources managed by Snowflake
- The resource for snowpipe are automatically scaled up and down by snowflake
Which of the following can be used to download data from an external stage to an on-premises
system? - ANSWER - Cloud Provider Utilities
Snowflake provides which of the following methods of data loading? - ANSWER - - Continuous
- Bulk
Under which circumstances will the query result cache fulfill the query result? - ANSWER - - The
role executing the query matches the role that generated the previous results
- The query results cache was generated or used less than 24 hours ago
- The micro partitions for the tables in the query have not changed
True or False: Cluster keys should be changed only during off-peak hours to avoid blocking
DML statements. - ANSWER - False
