- All Exams Instant Download
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...
Which of the following statements will accommodate this request?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?A . ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD; B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING; C. GRANT MODIFY...
If the user runs the same copy into command what will happen?
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer...
