nerdexam
Snowflake

COF-C02 · Question #285

Which objects together comprise a namespace in Snowflake? (Select TWO).

The correct answer is B. Database C. Schema. In Snowflake, a namespace is the combination of a Database (B) and a Schema (C). The namespace defines the context for resolving unqualified object names. When you run USE DATABASE mydb and USE SCHEMA myschema, all subsequent object references without a fully qualified name are…

Snowflake Cloud Data Platform Features and Architecture

Question

Which objects together comprise a namespace in Snowflake? (Select TWO).

Options

  • AAccount
  • BDatabase
  • CSchema
  • DTable
  • EVirtual warehouse

How the community answered

(31 responses)
  • A
    3% (1)
  • B
    87% (27)
  • D
    3% (1)
  • E
    6% (2)

Explanation

In Snowflake, a namespace is the combination of a Database (B) and a Schema (C). The namespace defines the context for resolving unqualified object names. When you run USE DATABASE mydb and USE SCHEMA myschema, all subsequent object references without a fully qualified name are resolved within that database.schema namespace. Accounts, tables, and warehouses are not part of the namespace definition.

Topics

#Snowflake object hierarchy#Namespace#Database#Schema

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice