SnowPro Advanced: Architect Free Practice Exam Questions

176 real SnowPro Advanced: Architect exam questions with answers and AI explanations. Snowflake certification prep — page 7 of 18.

  1. Question 67: How can the Snowflake context functions be used to help determine whether a user is authorized to see data that has column-level security enforced? (Choose two…
  2. Question 68: A company has a Snowflake environment running in AWS us-west-2 (Oregon). The company needs to share data privately with a customer who is running their Snowfla…
  3. Question 69: A Snowflake Architect created a new data share and would like to verify that only specific records in secure views are visible within the data share by the con…
  4. Question 70: What is a characteristic of Role-Based Access Control (RBAC) as used in Snowflake?
  5. Question 71: A group of Data Analysts have been granted the role ANALYST_ROLE. They need a Snowflake database where they can create and modify tables, views, and other obje…
  6. Question 72: Which columns can be included in an external table schema? (Choose three.)
  7. Question 73: How can the Snowpipe REST API be used to keep a log of data load history?
  8. Question 74: A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical…
  9. Question 75: Data is being imported and stored as JSON in a VARIANT column. Query performance was fine, but most recently, poor query performance has been reported. What co…
  10. Question 76: Which SQL ALTER command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?