Question 4:
ConsumersHalt (CH) is an Indian department collection chain. There are 63 branches across 32 towns in India, with clothing, accessories, bags, shoes, jewelry, scents, faces, health and exquisiteness products, home furnishing and decor products. CH runs their existing operations and analytics infrastructure out of AWS which includes S3, EC2, Auto Scaling, CDN and also Redshift. The Redshift platform is being used for advanced analytics, real time analytics and being actively used for past 2 years. Suddenly performance issues are occurring in the application and administrator being a superuser needs to provide a list of reports in terms of current and historical performance of the cluster. What types of tables/views can help access the performance related info for diagnosis. Select 3 options.
Answer options:
A.STL system tables are generated from Amazon Redshift log files to provide a history of the system. They serve logging. B.STL tables are actually virtual system tables that contain snapshots of the current system data. They serve snapshots. C.STV system tables are generated from Amazon Redshift log files to provide a history of the system. They serve logging. D.STV tables are actually virtual system tables that contain snapshots of the current system data. They serve snapshots. E.System views contain full data found in several of the STL and STV system tables. F.The system catalogs store schema metadata, such as information about tables and columns.