COF-C01 無料問題集「Snowflake SnowPro Core Certification」

（A）The number of users who accessed the Warehouse.

（B）The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.

（C）The number of queries that ran using the Warehouse.

（D）The size of the Warehouse and the number of clusters that ran within a given time period.

（A）They roll up and release approximately monthly, but customers can request early release application

（B）During a release, new customer requests/queries/connections transparently move over to the newer version

（C）A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

（D）They happen approximately weekly

（A）False

（B）True

（A）1 day

（B）45 days

（C）7 days

（D）90 days

（A）Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

（B）Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

（C）If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

（D）Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

（A）1 day

（B）1 minute

（C）1 second

（D）1 hour

（A）False

（B）True

（A）The size of the data required for each query

（B）The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

（C）The tool that s executing the query

（D）The complexity of each query

（A）False

（B）True

（A）Tasks are created at the Application level and can only be created by the Account Admin role.

（B）The global privilege create task is required to create a new task.

（C）Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

（D）The role must have access to the target schema and the create task privilege on the schema itself.