COF-R02 無料問題集「Snowflake SnowPro Core Recertification」

（A）Database Stage

（B）Table Stage

（C）Internal Named Stage

（D）External Named Stage

（E）Schema Stage

（F）User Stage

（A）Data expires from Time Travel

（B）Data expires from Fail-safe

（C）Data is truncated from a table

（D）Data is deleted from a table

（A）Produce the largest files possible, reducing the overall number of files to process.

（B）Use auto-ingest Snowpipes to load large files in a serverless model.

（C）Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

（D）Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

（A）A named Snowflake object that includes all the information required to share a database

（B）A uniquely identified Snowflake account within a business entity

（C）A logical grouping of objects that belongs to multiple databases

（D）A logical grouping of objects that belongs to a single database

（A）Standard

（B）Business Critical

（C）Enterprise

（D）Virtual Private Snowflake

（A）To share data in Snowflake with external parties

（B）To call code that executes outside of Snowflake

（C）To run a function in another Snowflake database

（D）To ingest data from on-premises data sources

（A）The ability to resize warehouses

（B）Use of multi-clustered warehouses

（C）The ability to scale up warehouses

（D）The use of warehouse auto scaling

（E）The use of warehouse indexing

（A）AVRO

（B）XML

（C）CSV

（D）Parquet

（E）JSON

（F）ORC

（A）Use the standard warehouse scaling policy

（B）Set the minimum and maximum clusters to autoscale

（C）Configure the warehouse to a size larger than generally required

（D）Use the economy warehouse scaling policy

（A）10-99 MB

（B）8-16 MB

（C）100-250 MB

（D）16-24 MB

（A）Columns can be joined with an existing table

（B）Columns can be reordered

（C）Columns can be aggregated

（D）Data can be loaded without the need to spin up a virtual warehouse

（E）Columns can be omitted

（A）Federated authentication

（B）SCIM

（C）OCSP authentication

（D）TLS 1.2

（E）OAuth

（F）Key-pair authentication

（A）False

（B）True

（A）Secure User-Defined Functions (UDFs)

（B）Tables

（C）Stored Procedures

（D）Schemas

（E）Roles

（F）Secure Views

（A）Serverless query engine

（B）Multi-cluster shared data

（C）Shared-nothing

（D）Shared-disk

（A）A task allows a user to execute a set of SQL commands on a predefined schedule.

（B）A task can be called using a CALL statement to run a set of predefined SQL commands.

（C）A task can be executed using a SELECT statement to run a predefined SQL command.

（D）A task allows a user to execute a single SQL statement/command using a predefined schedule.