COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 6 of 14.
- Question #251Data Loading and Unloading
What is the recommended way to change the existing file format type in my format from CSV to JSON?
File FormatsDDLALTER FILE FORMATData Loading - Question #252Performance Concepts
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Micro-partitionsQuery optimizationPruningPerformance tuning - Question #253Data Loading and Unloading
Which command is used to unload files from an internal or external stage to a local file system?
GET commandData UnloadingStagesLocal filesystem - Question #254Account Access and Security
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
MFADuo SecurityAuthenticationAccount Security - Question #255Performance Management
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
Virtual WarehousesMulti-cluster WarehousesAuto-scalingQuery Queuing - Question #256Performance Management
Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
Virtual Warehouse PerformanceQuery QueuingINFORMATION_SCHEMAPerformance Monitoring - Question #257Data Transformations
A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?
SQL Set OperatorsINTERSECTQuerying DataData Comparison - Question #258Performance Management
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
ClusteringPerformance OptimizationMicro-partitionsQuery Performance - Question #259Snowflake Cloud Data Platform Features and Architecture
Which of the following describes the Snowflake Cloud Services layer?
Snowflake ArchitectureCloud Services LayerPlatform Components - Question #260Account Access and Security
What does Snowflake recommend regarding database object ownership? (Select TWO).
Role-based access control (RBAC)Object ownershipSnowflake rolesBest practices - Question #261Performance Management
If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?
Multi-cluster warehousesEconomy scaling policyWarehouse scalingQuery queuing - Question #262Account Access and Security
What happens when a database is cloned?
CloningZero-Copy CloningPrivilegesAccess Control - Question #263Snowflake Cloud Data Platform Features and Architecture
Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)
Semi-structured dataData typesVARIANTOBJECT - Question #264Storage and Data Protection
Snowflake's hierarchical key mode includes which keys? (Select TWO).
encryption keyskey hierarchydata at rest encryptiondata security - Question #265Data Loading and Unloading
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
Bulk LoadingData IngestionCOPY CommandCloud Storage - Question #266Account Access and Security
What role is required to use Partner Connect?
Partner ConnectAccount rolesAdministrationIntegration - Question #267Account Access and Security
How does a scoped URL expire?
Scoped URLFile AccessQuery Result CacheSecurity - Question #268Data Governance
Which features make up Snowflake's column level security? (Select TWO).
Column-level securityDynamic Data MaskingExternal TokenizationData Security - Question #269Snowflake Cloud Data Platform Features and Architecture
What is the difference between a stored procedure and a User-Defined Function (UDF)?
Stored ProceduresUser-Defined Functions (UDFs)Database OperationsProcedural Logic - Question #270Performance Management
When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
Virtual WarehouseAuto-suspendPerformanceLatency - Question #271Data Loading and Unloading
How does Snowflake handle the bulk unloading of data into single or multiple files?
Data UnloadingCOPY INTOFile NamingExternal Stages - Question #272Data Loading and Unloading
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
Data loadingFile format precedenceCOPY INTO statementData ingestion - Question #273Snowflake Cloud Data Platform Features and Architecture
Which statement accurately describes a characteristic of a materialized view?
Materialized ViewsQuery OptimizationData Freshness - Question #274Snowflake Cloud Data Platform Features and Architecture
Which stream type can be used for tracking the records in external tables?
External StreamsStreamsExternal TablesChange Data Capture - Question #275Performance Management
What can a Snowflake user do in the Activity section in Snowsight?
SnowsightActivity sectionQuery performanceMonitoring - Question #276Storage and Data Protection
Which Snowflake URL type is used by directory tables?
Directory tablesScoped URLsExternal stagesData access - Question #277Data Governance
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Snowflake TagsAllowed ValuesTag PropertiesData Governance - Question #278Performance Management
What does Snowflake's search optimization service support?
Search Optimization ServicePerformance TuningQuery PerformanceService Limitations - Question #279Performance Management
What action can a user take to address query concurrency issues?
Query ConcurrencyVirtual WarehousesMulti-cluster WarehousesPerformance Optimization - Question #280Data Loading and Unloading
How long can a data consumer who has a pre-signed URL access data files using Snowflake?
Pre-signed URLsData accessExpiration time - Question #281Performance Management
Which pages are included in the Activity area of Snowsight? (Select TWO).
Snowsight UIActivity areaQuery HistoryAutomatic Clustering - Question #282Data Loading and Unloading
Which kind of Snowflake table stores file-level metadata for each file in a stage?
Directory tablesStagesMetadataFile management - Question #283Data Transformations
Which parameter prevents streams on tables from becoming stale?
StreamsData StalenessData RetentionTable Parameters - Question #284Account Access and Security
A user needs to create a materialized view in the schema MYDB.MYSCHEM
Materialized ViewsAccess ControlPrivilegesSchema Permissions - Question #285Snowflake Cloud Data Platform Features and Architecture
Which objects together comprise a namespace in Snowflake? (Select TWO).
Snowflake object hierarchyNamespaceDatabaseSchema - Question #286Performance Management
Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data. How does Snowflake recommen...
Virtual WarehousesWorkload IsolationPerformance OptimizationConcurrency - Question #287Data Governance
How long does Snowflake retain information in the ACCESS HISTORY view?
ACCESS HISTORY viewData retentionAuditingData governance - Question #288Snowflake Cloud Data Platform Features and Architecture
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
ViewsTemporary TablesObject Resolution - Question #289Snowflake Cloud Data Platform Features and Architecture
What is used to diagnose and troubleshoot network connections to Snowflake?
SnowCDNetwork ConnectivityTroubleshootingSnowflake Utilities - Question #290Snowflake Cloud Data Platform Features and Architecture
Which REST API can be used with unstructured data?
REST APIUnstructured DataSnowflake APIFiles API - Question #291Data Loading and Unloading
What column type does a Kafka connector store formatted information in a single column?
Kafka ConnectorSemi-structured dataVARIANT data typeData Ingestion - Question #292Data Loading and Unloading
When unloading data to an external stage, what is the MAXIMUM file size supported?
Data UnloadingExternal StageFile Size Limit - Question #293Account Access and Security
By definition, a secure view is exposed only to users with what privilege?
Secure ViewsAccess ControlPrivilegesSecurity - Question #294Performance Management
What is a characteristic of the Snowflake Query Profile?
Query ProfileQuery PerformancePerformance TuningQuery Execution - Question #295Performance Management
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
Query ProfilePerformance TuningMemory SpillingTroubleshooting - Question #296Storage and Data Protection
What is the MAXIMUM Time Travel retention period for a transient table?
Time TravelTransient TablesData Retention - Question #297Data Loading and Unloading
Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
Snowflake StagesDirectory TablesFile ManagementData Loading - Question #298Data Protection and Data Sharing
Which Snowflake edition enables data sharing only through Snowflake Support?
Snowflake EditionsVirtual Private SnowflakeData SharingAccount Isolation - Question #299Data Protection and Data Sharing
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
Snowflake MarketplaceCross-Cloud Auto-FulfillmentPaid ListingsData Sharing - Question #300Data Transformations
Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).
UDFsSnowflake UDF LanguagesInline CodeData Transformations