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

What is a key feature of Snowflake architecture?

• A.Software updates are automatically applied on a quarterly basis
• B.Multi-cluster warehouses allow users to run a query that spans across multiple clusters
• C.Zero-copy cloning creates a mirror copy of a database that updates with the original
• D.Snowflake eliminates resource contention with its virtual warehouse implementation
• E.Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

What is a benefit of using system tags?

• A.To control data backup frequency
• B.To increase query execution speed
• C.To manage compute resources
• D.To support data governance

A size Small standard virtual warehouse running in auto-suspend mode is used for a production Business Intelligence (BI) reporting environment. The BI reports generate quickly in the early morning, but as the day progresses and there are more users, it takes longer to run the reports. How can this situation be addressed?

• A.Change the standard warehouse to a multi-cluster warehouse.
• B.Increase the size of the virtual warehouse.
• C.Disable the auto-suspend mode.
• D.Enable the query acceleration service.

What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?

• A.Hierarchical key model
• B.Key pair authentication
• C.Client-side encryption
• D.Tri-secret secure encryption

What will happen if multiple identical COPY INTO < table > statements, using the default settings, are executed in parallel on the same data file?

• A.The statements will fail with an error relating to reading the same file.
• B.The statements will duplicate the data in the table.
• C.The statements will overwrite the data in the table.
• D.The statements will load the data only once in the table.