- All Exams Instant Download
What features does Snowflake Time Travel enable?
What features does Snowflake Time Travel enable?A . Querying data-related objects that were created within the past 365 days B. Restoring data-related objects that have been deleted within the past 90 days C. Conducting point-in-time analysis for Bl reporting D. Analyzing data usage/manipulation over all periods of timeView AnswerAnswer: B...
Which of the following describes external functions in Snowflake?
Which of the following describes external functions in Snowflake?A . They are a type of User-defined Function (UDF). B. They contain their own SQL code. C. They call code that is stored inside of Snowflake. D. They can return multiple rows for each row receivedView AnswerAnswer: A Explanation: External functions...
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 is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?A . Standard B. Premium C. Enterprise D. Business CriticalView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/privatelink-azure.html
Will data cached in a warehouse be lost when the warehouse is resized?
Will data cached in a warehouse be lost when the warehouse is resized?A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits. B. Yes. because the compute resource is replaced in its entirety with a new compute resource. C. No. because the...
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: Query result cache is all about fetching the data from cloud services layer and saving the cost by not running...
True or False: Fail-safe can be disabled within a Snowflake account.
True or False: Fail-safe can be disabled within a Snowflake account.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach....
When unloading to a stage, which of the following is a recommended practice or approach?
When unloading to a stage, which of the following is a recommended practice or approach?A . Set SINGLE: = true for larger files B. Use OBJECT_CONSTRUCT ( * ) when using Parquet C. Avoid the use of the CAST function D. Define an individual file formatView AnswerAnswer: D
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...
