ILM – InformationLifecycle Management — Learn free

Self-check

Questions 1–10 of 10

1. What is Information Lifecycle Management (ILM)?
Question 1A. A method for encrypting data at each stage of processingB. The process of optimising data storage by automatically tiering data to different locations based on its age, access frequency and required read/write speedsC. A framework for training data analystsD. A backup rotation scheduleE. A standard for naming database columns
2. How is the data lifecycle classified based on usage in ILM?
Question 2A. Primary, secondary and tertiaryB. Raw, refined and reportedC. Hot, warm and cold, possibly extended to dead for deleted dataD. Bronze, silver and goldE. Structured, semi-structured and unstructured
3. In on-premise storage tiering, which tier uses SSDs to store frequently accessed hot data?
Question 3A. Tier 3B. Tier 2C. The archive tierD. Tier 1E. The external tier
4. What kind of data is stored in Tier 3 (external storage) of a database appliance?
Question 4A. Frequently used indexesB. The current year's transactionsC. Recently modified partitionsD. Session-specific temporary resultsE. Cold data for long-term retention, such as old backups or compliance archives
5. In the sales transaction table example, what happens to transactions older than seven years?
Question 5A. They can be deleted based on defined data retention policiesB. They are moved to Tier 1 for auditingC. They are compressed and kept in Tier 2D. They are copied to a materialised viewE. They are re-partitioned by month
6. At what level can ILM be applied to very large tables for finer-grained control?
Question 6A. The column levelB. The partition levelC. The row levelD. The schema levelE. The user level
7. How do SaaS cloud data platforms such as Snowflake, Databricks and BigQuery handle storage tiering?
Question 7A. They require the DBA to script tier movements manuallyB. They do not support tiering at allC. They manage the underlying storage automatically and use tiered storage implicitly behind the scenesD. They store all data in the most expensive tierE. They require data to be exported before archiving
8. How does Apache Iceberg relate to storage tiering?
Question 8A. It directly manages tiers within its own file formatB. It replaces cloud storage entirelyC. It prevents files from being moved between tiersD. It does not manage tiers itself but works with storage systems that offer tiering, for example through storage tags such as those on Amazon S3E. It only supports a single hot tier
9. Which Amazon S3 tier automatically monitors access and migrates data between frequent, infrequent and rarely accessed tiers?
Question 9A. S3 StandardB. S3 One Zone-IAC. S3 Glacier Deep ArchiveD. S3 Standard-IAE. S3 Intelligent-Tiering
10. Which Amazon S3 tiers provide the lowest storage costs but retrieval times ranging from minutes to hours?
Question 10A. The S3 Glacier tiers (Instant Retrieval, Flexible Retrieval and Deep Archive)B. S3 StandardC. S3 Intelligent-TieringD. S3 Standard-IAE. S3 One Zone-IA