- All Exams Instant Download
How often are encryption keys automatically rotated by Snowflake?
How often are encryption keys automatically rotated by Snowflake?A . 30 Days B. 60 Days C. 90 Days D. 365 DaysView AnswerAnswer: A Explanation: All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When...
Which of the following objects can be shared through secure data sharing?
Which of the following objects can be shared through secure data sharing?A . Masking policy B. Stored procedure C. Task D. External tableView AnswerAnswer: D Explanation: Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be...
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?A . Okta Verify B. Duo Mobile...
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
Which of the following compute resources or features are managed by Snowflake? (Select TWO).A . Execute a COPY command B. Updating data C. Snowpipe D. AUTOMATIC__CLUSTERING E. Scaling up a warehouseView AnswerAnswer: A,D
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)A . The ability to scale up warehouses B. The use of warehouse auto scaling C. The ability to resize warehouses D. Use of multi-clustered warehouses E. The use of warehouse indexingView AnswerAnswer: B,D
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Which data types does Snowflake support when querying semi-structured data? (Select TWO)A . VARIANT B. ARRAY C. VARCHAR D. XML E. BLOBView AnswerAnswer: A,B Explanation: https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY. The maximum length of...
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).A . Materialized views B. Sequences C. Procedures D. Tables E. Secure User Defined Functions (UDFs)View AnswerAnswer: D,E Explanation: Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts....
Which of the following can be executed/called with Snowpipe?
Which of the following can be executed/called with Snowpipe?A . A User Defined Function (UDF) B. A stored procedure C. A single copy_into statement D. A single insert__into statementView AnswerAnswer: C
Which command can be used to stage local files from which Snowflake interface?
Which command can be used to stage local files from which Snowflake interface?A . SnowSQL B. Snowflake classic web interface (Ul) C. Snowsight D. .NET driverView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/snowsql-use.html
What are the default Time Travel and Fail-safe retention periods for transient tables?
What are the default Time Travel and Fail-safe retention periods for transient tables?A . Time Travel - 1 day. Fail-safe - 1 day B. Time Travel - 0 days. Fail-safe - 1 day C. Time Travel - 1 day. Fail-safe - 0 days D. Transient tables are retained in neither...
