A company is planning to load data into a Redshift table from multiple files in an S3 bucket. They want to verify that the data was loaded correctly. How can they verify this?

Answer options:

A.Check the Cloudwatch log metrics to check if the data was loaded properly
B.Query the STL_LOAD_COMMITS table
C.Check the Cloudtrail log metrics to check if the data was loaded properly
D.Use the Analyze command

Answer – B
The AWS Documentation mentions the following
#######
Verifying That the Data Was Loaded Correctly
After the load operation is complete, query the STL_LOAD_COMMITS system table to verify that the expected files were loaded. You should execute the COPY command and load verification within the same transaction so that if there is problem with the load you can roll back the entire transaction.
The following query returns entries for loading the tables in the TICKIT database:
#######
Option A is incorrect since here metrics about the cluster itself will be recorded and the not the data load process
Option C is incorrect since here the API activity for the service will be recorded and the not the data load process
Option D is incorrect since this is used to update the statistical metadata that the query planner uses to build and choose optimal plan
For more information on verifying whether the data was loaded properly, please refer to the below URL
https://docs.aws.amazon.com/redshift/latest/dg/verifying-that-data-loaded-correctly.html