- All Exams Instant Download
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.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...
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.A . True B. FalseView AnswerAnswer: A
Which interfaces can be used to create and/or manage Virtual Warehouses?
Which interfaces can be used to create and/or manage Virtual Warehouses?A . The Snowflake Web Interface (UI) B. SQL commands C. Data integration tools D. All of the aboveView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answersA . SnowSQL B. ODBC C. R D. HIVEView AnswerAnswer: A,B Explanation: Reference: https://docs.snowflake.com/en/user-guide/connecting.html
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answersA . Their default role should be set to SYSTEMADMIN (the lower of the two) B. They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those...
When is the result set cache no longer available? (Select TWO)
When is the result set cache no longer available? (Select TWO)A . When another warehouse is used to execute the query B. When another user executes the query C. When the underlying data has changed D. When the warehouse used to execute the query is suspended E. When it has...
What SQL command would be used to view all roles that were granted to user.1?
What SQL command would be used to view all roles that were granted to user.1?A . show grants to user USER1; B. show grants of user USER1; C. describe user USER1; D. show grants on user USER1;View AnswerAnswer: A
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 statements will provide this access?
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access? A) B) C) D) A. Option A B. Option B C. Option C D. Option DView AnswerAnswer: A
