Exam SOL-C01 Topic 2 Question 16 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 16
Topic #: 2

A Snowflake environment has two databases, 'DEV DB' and 'PROD DB'. A table 'EMPLOYEES' exists in both databases with identical schemas. A developer needs to create a view in 'DEV DB' that references the 'EMPLOYEES' table in 'PROD DB' to perform cross-database joins. Which of the following SQL statements will successfully create this view in 'DEV DB'?

A. CREATE VIEW DEV DB.PUBLIC.EMPLOYEE VIEW AS SELECT FROM PROD
DB.PUBLIC.EMPLOYEES; B. CREATE VIEW DEV DB.PUBLIC.EMPLOYEE VIEW AS SELECT FROM PROD
DB.PUBLIC.EMPLOYEES WITH READ ONLY; C. CREATE OR REPLACE VIEW DEV DB.PUBLIC.EMPLOYEE VIEW AS SELECT FROM PROD DB.PUBLIC.EMPLOYEES; D. CREATE OR REPLACE VIEW DEV DB.PUBLIC.EMPLOYEE VIEW AS SELECT FROM PROD DB.PUBLIC.EMPLOYEES WITH SECURE; E. CREATE SECURE VIEW DEV DB.PUBLIC.EMPLOYEE VIEW AS SELECT FROM PRODDB.PUBLIC.EMPLOYEES;

Suggested Answer: C,E Vote an answer

To create a view that references objects in other databases, you should fully qualify the object names in the 'SELECT statement. Both options create the view referencing the PROD DB. Option C uses `CREATE OR REPLACE VIEW and option E uses `CREATE SECURE VIEW' which are correct and commonly used options for this scenerio. 'WITH READ ONLY' is not a supported clause for creating views in Snowflake. 'CREATE SECURE VIEW' creates a secure view which is recommended to protect the underlying objects' definition.

by Julia at Mar 23, 2026, 01:36 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business