- All Exams Instant Download
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 warehousesB . The use of warehouse auto scalingC . The ability to resize warehousesD . Use of multi-clustered warehousesE . The use of warehouse indexingView AnswerAnswer: B, D Explanation: Snowflake’s architecture...
The fail-safe retention period is how many days?
The fail-safe retention period is how many days?A . 1 dayB . 7 daysC . 45 daysD . 90 daysView AnswerAnswer: B Explanation: Fail-safe is a feature in Snowflake that provides an additional layer of data protection. After the Time Travel retention period ends, Fail-safe offers a non-configurable 7-day period...
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?A . STATEMENT_TIMEOUT__IN__SECONDSB . STATEMENT_QUEUED_TIMEOUT_IN_SECONDSC . MAX_CONCURRENCY__LEVELD . QUERY_TIMEOUT_IN_SECONDSView AnswerAnswer: B Explanation: The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get...
What is the default character set used when loading CSV files into Snowflake?
What is the default character set used when loading CSV files into Snowflake?A . UTF-8B . UTF-16C . ISO S859-1D . ANSI_X3.AView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for% 20loading. For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the...
Which cache type is used to cache data output from SQL queries?
Which cache type is used to cache data output from SQL queries?A . Metadata cacheB . Result cacheC . Remote cacheD . Local file cacheView AnswerAnswer: B Explanation: The Result cache is used in Snowflake to cache the data output from SQL queries. This feature is designed to improve performance...
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).A . Compute Credits = 50 Credits Cloud Services = 10B . Compute Credits = 80 Credits Cloud Services = 5C . Compute Credits = 10 Credits Cloud Services = 9D . Compute Credits = 120 Credits...
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 stagesB . Incremental backupsC . Time TravelD . Zero-copy clonesE . Fail-safeView AnswerAnswer: C, E Explanation: Snowflake’s Continuous Data Protection (CDP) encompasses a set of features that help protect data stored in Snowflake against human...
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)A . ROLESB . POLICY_REFERENCESC . QUERY_HISTORYD . RESOURCE_MONIT ORSE . ACCESS_HISTORYView AnswerAnswer: B, E Explanation: To evaluate the details of dynamic data masking, the POLICY_REFERENCES and ACCESS_HISTORY views in the account_usage schema are used. The...
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.A . TrueB . FalseView AnswerAnswer: B Explanation: The ACCOUNTADMIN role is the most powerful role in Snowflake and should be limited to a select number of users within an...
What is a best practice after creating a custom role?
What is a best practice after creating a custom role?A . Create the custom role using the SYSADMIN role.B . Assign the custom role to the SYSADMIN roleC . Assign the custom role to the PUBLIC roleD . Add__CUSTOM to all custom role namesView AnswerAnswer: B Explanation: Assigning the custom...
