ExamGecko
Question list
Search
Search

Question 143 - SnowPro Core discussion

Report
Export

Which of the following objects are contained within a schema? (Choose two.)

A.
Role
Answers
A.
Role
B.
Stream
Answers
B.
Stream
C.
Warehouse
Answers
C.
Warehouse
D.
External table
Answers
D.
External table
E.
User
Answers
E.
User
F.
Share
Answers
F.
Share
Suggested answer: B, D

Explanation:

In Snowflake, a schema is a logical grouping of database objects, which can include streams and external tables. A stream is an object that allows users to query data that has changed in specified tables or views, and an external table is a table that references data stored outside of Snowflake. Roles, warehouses, users, and shares are not contained within a schema.

Reference:SHOW OBJECTS,Database, Schema, & Share DDL

asked 23/09/2024
William Hyde
40 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first