- All Exams Instant Download
Loading data using snowpipe REST API is supported for external stage only
Loading data using snowpipe REST API is supported for external stage onlyA . TRUEB . FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:
Which Snowflake data modeling approach is designed for BI queries?
Which Snowflake data modeling approach is designed for BI queries?A . 3 NFB . Star schemaC . Data VaultD . Snowflake schemaView AnswerAnswer: B
What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?
A company’s client application supports multiple authentication methods, and is using Okta. What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?A . 1) OAuth (either Snowflake OAuth or External OAuth) 2) External browser 3) Okta native authentication 4) Key Pair Authentication, mostly used...
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)A . SYSTEM$CLUSTERING_INFORMATION B. SYSTEM$CLUSTERING_USAGE C. SYSTEM$CLUSTERING_DEPTH D. SYSTEM$CLUSTERING_KEYS E. SYSTEM$CLUSTERING_PERCENTView AnswerAnswer: A,C
Snowflake has row level security
Snowflake has row level securityA . TRUE B. FALSEView AnswerAnswer: A Explanation: The below is an old Explanation: -------------- Currently row level security is not available in Snowflake. There is a work around to achieve this using views and permissions. New Explanation: ------- Snowflake has introduced row level security now....
With default settings, how long will a query run on snowflake
With default settings, how long will a query run on snowflakeA . Snowflake will cancel the query if it runs more than 48 hours B. Snowflake will cancel the query if it runs more than 24 hours C. Snowflake will cancel the query if the warehouse runs out of memory...
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?A . External table B. Materialized view C. Search optimization D. Result cacheView AnswerAnswer: B
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)A . They can include ORDER BY clauses. B. They cannot include nested subqueries. C. They can include context functions, such as CURRENT_TIME(). D. They can support MIN and MAX aggregates. E. They can support inner joins,...
What is required to allow data sharing between these two companies?
Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A. What is required to allow data sharing between these two companies? A. Create a pipeline to write shared data to a cloud storage location in the...
At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?
At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?A . Global B. Database C. Schema D. TableView AnswerAnswer: D
