You are designing a data pipeline in Snowflake where raw data is ingested into a staging schema, transformed, and then loaded into a production schema. You want to ensure that only authorized users ca

You are designing a data pipeline in Snowflake where raw data is ingested into a staging schema, transformed, and then loaded into a production schema. You want to ensure that only authorized users can access the data in the production schema, and that data analysts can only query the data but not modify it. You have two roles: `DATA ENGINEER (responsible for loading and transforming data) and 'DATA ANALYST (responsible for querying data). Which of the following sets of grants provide the MOST secure and appropriate access control for this scenario? Assume that 'PRODUCTION DB' and 'STAGING DB' databases already exist.