At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?
Options:
A.
Account
B.
Database
C.
Schema
D.
Table
Answer:
A
Explanation:
Explanation:
The MIN_DATA_RETENTION_TIME_IN_DAYS parameter is set at the Account level in Snowflake. This parameter specifies the minimum number of days Snowflake retains the historical data for time travel, which allows users to access and query data as it existed at previous points in time.
Here's how to understand and adjust this parameter:
Purpose of MIN_DATA_RETENTION_TIME_IN_DAYS: This parameter is crucial for managing data lifecycle and compliance requirements within Snowflake. It determines the minimum time frame for which you can perform operations like restoring deleted objects or accessing historical versions of data.
Setting the Parameter: Only account administrators can set or modify this parameter. It is done at the account level, impacting all databases and schemas within the account. The setting can be adjusted based on the organization's data retention policy.
Adjusting the Parameter:
SHOW PARAMETERS LIKE 'MIN_DATA_RETENTION_TIME_IN_DAYS';
ALTER ACCOUNT SET MIN_DATA_RETENTION_TIME_IN_DAYS = ;
Reference: [Reference: For more details on data retention and time travel in Snowflake, refer to the official documentation: https://docs.snowflake.com/en/sql-reference/account-usage/storage-usage.html#data-retention-time-travel, , ]
Question 181
Which task is supported by the use of Access History in Snowflake?
Options:
A.
Data backups
B.
Cost monitoring
C.
Compliance auditing
D.
Performance optimization
Answer:
C
Explanation:
Explanation:
Access History in Snowflake is primarily utilized for compliance auditing. The Access History feature provides detailed logs that track data access and modifications, including queries that read from or write to database objects. This information is crucial for organizations to meet regulatory requirements and to perform audits related to data access and usage.
Role of Access History: Access History logs are designed to help organizations understand who accessed what data and when. This is particularly important for compliance with various regulations that require detailed auditing capabilities.
How Access History Supports Compliance Auditing:
Reference: [Reference: For more information on how Access History supports compliance auditing, refer to the Snowflake documentation on Access History: https://docs.snowflake.com/en/sql-reference/account-usage/access_history.html, , ]