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

（A）False

（B）True

（A）XML

（B）JSON

（C）Delimited (CSV, TSV, etc.)

（D）ORC

（E）Avro

（A）Assign the custom role to the PUBLIC role

（B）Create the custom role using the SYSADMIN role.

（C）Assign the custom role to the SYSADMIN role

（D）Add__CUSTOM to all custom role names

（A）To eliminate or reduce Queuing of concurrent queries

（B）To allow the warehouse to resize automatically

（C）To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

（D）To create separate data warehouses to increase query optimization

（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）USERADMIN

（B）SECURITYADMIN

（C）SYSADMIN

（D）ACCOUNTADMIN

（E）ROLEADMIN

（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）Configure the Maximum Clusters setting to "Auto-Scale"

（B）Set the Minimum Clusters and Maximum Clusters settings to the same value

（C）Set the Warehouse type to "Auto"

（D）Set the Minimum Clusters and Maximum Clusters settings to the different values

（A）Standard

（B）Vendor

（C）Consumer

（D）Personalized

（E）Reader

（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）SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())

（B）SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS;

（C）SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;

（D）SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY;

（A）Growth of storage and compute are tightly coupled together

（B）Multiple compute clusters can access stored data without contention

（C）Storage expands without the requirement to add more compute

（D）Compute can be scaled up or down without the requirement to add more storage

（A）Database

（B）User

（C）Schema

（D）Tables

（E）Account

（F）Role

（A）The columns most actively used in the select filters.

（B）The columns with very high cardinality.

（C）The columns with many different values.

（D）The columns that are queried in the select clause.

（A）Adobe

（B）Power Bl

（C）Data Robot

（D）Informatica

（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）ALTER TABLE AS SELECT FROM STREAM

（B）INSERT INTO TABLE SELECT FROM STREAM

（C）UPDATE TABLE FROM STREAM

（D）BEGIN COMMIT

（E）SELECT FROM STREAM

（A）Yes, because a table owner has full control and can unset masking policies.

（B）No, because ownership of a table does not include the ability to change masking policies

（C）No, because masking policies must always reference specific access roles.

（D）Yes, because masking policies only apply to cloned tables.

（A）Micro-partitions cannot overlap in their range of values

（B）Rows are automatically stored in sorted order within micro-partitions

（C）Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

（D）Micro-partitions are immutable objects that support the use of Time Travel.

（E）Micro-partitions can be defined on a schema-by-schema basis

（A）Search Optimization Service

（B）Automatic Clustering

（C）Range Partitioning

（D）Horizontal Partitioning