SnowPro Advanced: Data Engineer — Question 93

A Data Engineer needs to obtain details about data loading history for tables in a specific database and schema. The tables were loaded using Snowpipe in the last 24 hours.

How should the Engineer accomplish these tasks?

Answer options

• A. Use the USAGE privilege on the database and schema to use the copy history view in the information schema.
• B. Use the LOAD HISTORY view using the usage privilege on the database and schema, and any privilege on the table.
• C. Use the MONITOR privilege on the account and access the table details to use the copy history view in the information schema.
• D. Use the USAGE privilege on the database and schema, select the database and the schema, and access the table details to use the copy history tab.

Correct answer: B

Explanation

The correct answer is B because it specifies the need for both the USAGE privilege on the database and schema and any privilege on the table to access the LOAD HISTORY view, which provides pertinent data loading history. Options A, C, and D do not correctly address the necessary privileges or views to obtain the required information regarding the loading history.