- All Exams Instant Download
Which stage type can be altered and dropped?
Which stage type can be altered and dropped?A . Database stage B. External stage C. Table stage D. User stageView AnswerAnswer: C Explanation: https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages
User-level network policies can be created by which of the following roles? (Select TWO).
User-level network policies can be created by which of the following roles? (Select TWO).A . ROLEADMIN B. ACCOUNTADMIN C. SYSADMIN D. SECURITYADMIN E. USERADMINView AnswerAnswer: BD Explanation: By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can...
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).A . Internal stages B. Incremental backups C. Time Travel D. Zero-copy clones E. Fail-safeView AnswerAnswer: C,E Explanation: Time travel and fail safe are the two continuous data protection features support the recovery of data automatically. Snowflake provides...
According to recommended best practice, what should be done to reduce the Queue volume?
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).A . Use multi-clustered warehousing to scale out...
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?A . Pipes B. Streams C. Tasks D. ProceduresView AnswerAnswer: B Explanation: https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20 each%20change.
What feature can be used to reorganize a very large table on one or more columns?
What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitions B. Clustering keys C. Key partitions D. Clustered partitionsView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)A . Customer-managed encryption keys through Tri-Secret Secure B. Automatic encryption of all data C. Up to 90 days of data recovery through Time Travel D. Object-level access control E. Column-level security to apply data masking policies...
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
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: You can experiment the same with snowflake UI.
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?A . An FTP server with TLS encryption B. An HTTPS server with WebDAV C. A Google Cloud storage bucket D. A Windows server file share on AzureView AnswerAnswer: C
