COF-C03 試験問題を無料オンラインアクセス

What is a directory table in Snowflake?

• A.A Snowflake table specifically designed for storing unstructured files
• B.A separate database object that is used to store file-level metadata
• C.A database object with grantable privileges for unstructured data tasks
• D.An object layered on a stage that is used to store file-level metadata

What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

• A.The provisioning of additional compute resources will be in effect when the warehouse is next resumed.
• B.The warehouse will remain suspended but new resources will be added to the query acceleration service.
• C.The provisioning of new compute resources for the warehouse will begin immediately.
• D.The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

Which option can be used to define column data types when unloading data into Parquet-formatted files?

• A.SINGLE = TRUE
• B.EMPTY_FIELD_AS_NULL = FALSE
• C.CAST or the :: operator in the COPY INTO statement
• D.BINARY_AS_TEXT = TRUE

Which common query problems are identified by the Query Profile? (Select TWO.)

• A.Object does not exist or not authorized
• B.Ambiguous column names
• C.Syntax error
• D.Queries too large to fit in memory
• E.Inefficient pruning

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

• A.An error will occur, as stored objects cannot be cloned.
• B.The stored procedures and views will refer to tables in the source database.
• C.An error will occur, as views with qualified references cannot be cloned.
• D.The cloned views and the stored procedures will reference the cloned tables in the cloned database.