ExamGecko
Question list
Search
Search

Question 394 - SnowPro Core discussion

Report
Export

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

A.
CREATE TABLE <table_name> LIKE TABLE_A;
Answers
A.
CREATE TABLE <table_name> LIKE TABLE_A;
B.
CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
Answers
B.
CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
C.
CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
Answers
C.
CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
D.
CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;
Answers
D.
CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;
Suggested answer: C

Explanation:

When a tag object is assigned to a table, using the statementCREATE TABLE <table_name> AS SELECT * FROM TABLE_Awill automatically assign the TABLE_A tag to the newly created table2.

asked 23/09/2024
Alejandro Ramirez Cuesta
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first