Parson Fortunes Ltd is an Asian-based department store operator with an extensive network of 131 stores, spanning approximately 4.1 million square meters of retail space across cities in India, China, Vietnam, Indonesia and Myanmar.
Parson built a VPC to host their entire enterprise infrastructure on cloud. Parson has large assets of data around 20 TB’s of structured data and 45 TB of unstructured data and is planning to host their data warehouse on AWS and unstructured data storage on S3. The files sent from their on premise data center are also hosted into S3 buckets. Parson IT team is well aware of the scalability, performance of AWS services capabilities. Parson hosts their web applications, databases and the data warehouse built on Redshift in VPC. The administrator wants to understand the system tables and views that support the team to understand the metadata of the Redshift architecture. Please advice. select 4 options.

Answer options:

A.STL tables are generated from logs that have been persisted to disk to provide a history of the system. These files reside on every node in the data warehouse cluster. The STL tables take the information from the logs and format them into usable tables for system administrators.
B. STV tables are virtual tables that contain snapshots of the current system data
C.STV tables are generated from logs that have been persisted to disk to provide a history of the system. These files reside on every node in the data warehouse cluster. The STL tables take the information from the logs and format them into usable tables for system administrators.
D.STL tables are virtual tables that contain snapshots of the current system data
E.System tables and views do not use the same consistency model as regular tables
F.System tables and views use the same consistency model as regular tables
G.System views that contain any reference to a transient STV table are called SVV viewsand references to STL tables are called SVL views.

Answer : A, B, E, G
Option A is correct -STL system tables are generated from Amazon Redshift log files to provide a history of the system.
These files reside on every node in the data warehouse cluster. The STL tables take the information from the logs and format them into usable tables for system administrators. To manage disk space, the STL log tables only retain approximately two to five days of log history, depending on log usage and available disk space. If you want to retain the log data, you will need to periodically copy it to other tables or unload it to Amazon S3. 
https://docs.aws.amazon.com/redshift/latest/dg/c_intro_STL_tables.html
Option B is correct -STV tables are actually virtual system tables that contain snapshots of the current system data. 
https://docs.aws.amazon.com/redshift/latest/dg/c_intro_STV_tables.html
Option C is incorrect -STV tables are actually virtual system tables that contain snapshots of the current system data. 
https://docs.aws.amazon.com/redshift/latest/dg/c_intro_STV_tables.html
Option D is incorrect -STL system tables are generated from Amazon Redshift log files to provide a history of the system.
These files reside on every node in the data warehouse cluster. The STL tables take the information from the logs and format them into usable tables for system administrators. To manage disk space, the STL log tables only retain approximately two to five days of log history, depending on log usage and available disk space. If you want to retain the log data, you will need to periodically copy it to other tables or unload it to Amazon S3. 
https://docs.aws.amazon.com/redshift/latest/dg/c_intro_STL_tables.html
Option E is correct - There are two types of system tables: STL and STV tables.
STL tables are generated from logs that have been persisted to disk to provide a history of the system. STV tables are virtual tables that contain snapshots of the current system data. They are based on transient in-memory data and are not persisted to disk-based logs or regular tables. System views that contain any reference to a transient STV table are called SVV views. Views containing only references to STL tables are called SVL views. System tables and views do not use the same consistency model as regular tables. It is important to be aware of this issue when querying them, especially for STV tables and SVV views 
https://docs.aws.amazon.com/redshift/latest/dg/c_types-of-system-tables-and-views.html
Option F is incorrect -There are two types of system tables: STL and STV tables.
STL tables are generated from logs that have been persisted to disk to provide a history of the system. STV tables are virtual tables that contain snapshots of the current system data. They are based on transient in-memory data and are not persisted to disk-based logs or regular tables. System views that contain any reference to a transient STV table are called SVV views. Views containing only references to STL tables are called SVL views. System tables and views do not use the same consistency model as regular tables. It is important to be aware of this issue when querying them, especially for STV tables and SVV views 
https://docs.aws.amazon.com/redshift/latest/dg/c_types-of-system-tables-and-views.html
Option G is correct -There are two types of system tables: STL and STV tables.
STL tables are generated from logs that have been persisted to disk to provide a history of the system. STV tables are virtual tables that contain snapshots of the current system data. They are based on transient in-memory data and are not persisted to disk-based logs or regular tables. System views that contain any reference to a transient STV table are called SVV views. Views containing only references to STL tables are called SVL views. System tables and views do not use the same consistency model as regular tables. It is important to be aware of this issue when querying them, especially for STV tables and SVV views 
https://docs.aws.amazon.com/redshift/latest/dg/c_types-of-system-tables-and-views.html