COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 1 of 14.
- Question #1Data Protection and Data Sharing
What features does Snowflake Time Travel enable?
Time TravelData RecoveryPoint-in-Time QueryingData Protection - Question #2Snowflake Cloud Data Platform Features and Architecture
Which statement about billing applies to Snowflake credits?
Snowflake creditsBillingVirtual warehouseCompute usage - Question #3Snowflake Cloud Data Platform Features and Architecture
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
Virtual WarehousesHigh ConcurrencyMulti-clustered WarehousesAuto-scaling - Question #4Performance Management
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommen...
Warehouse ScalingQuery QueuingPerformance TuningMulti-cluster Warehouse - Question #5Data Protection and Data Sharing
Which of the following objects can be shared through secure data sharing?
Secure Data SharingShareable ObjectsExternal Tables - Question #6Data Protection and Data Sharing
Which of the following commands cannot be used within a reader account?
Reader AccountsData SharingSQL CommandsAccount Capabilities - Question #7Data Loading and Unloading
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?
Internal StagesLIST commandData UnloadingFile Management - Question #8Account Access and Security
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
Snowflake EditionsData SecurityAccess ControlData Encryption - Question #9Data Loading and Unloading
Which command is used to unload data from a Snowflake table into a file in a stage?
Data UnloadingCOPY INTOSnowflake StagesSQL Commands - Question #10Storage and Data Protection
How often are encryption keys automatically rotated by Snowflake?
Encryption keysKey rotationData securityAutomatic key rotation - Question #11Storage and Data Protection
What are value types that a VARIANT column can store? (Select TWO)
VARIANT data typeSemi-structured dataJSONData types - Question #12Data Loading and Unloading
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?
SnowpipeAuto-ingestExternal stagesContinuous data loading - Question #13Data Loading and Unloading
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Data LoadingBest PracticesFile OptimizationData Formatting - Question #14Data Loading and Unloading
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The ne...
Data LoadingCOPY INTOStageDuplicate Data - Question #15Data Loading and Unloading
A user has unloaded data from Snowflake to a stage Which SQL command should be used to validate which data was loaded into the stage?
Snowflake stagesData unloadingLIST commandFile management - Question #16Data Protection and Data Sharing
What happens when a cloned table is replicated to a secondary database? (Select TWO)
Snowflake ReplicationZero-Copy CloningData ProtectionMetadata and Data Replication - Question #17Snowflake Cloud Data Platform Features and Architecture
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Semi-structured dataVARIANT data typeARRAY data typeSnowflake data types - Question #18Snowflake Cloud Data Platform Features and Architecture
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Snowflake OrganizationMulti-cloudMulti-regionAccount architecture - Question #19Data Loading and Unloading
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP...
JSON LoadingFile Format OptionsSTRIP_OUTER_ARRAYData Loading - Question #20Storage and Data Protection
What are the default Time Travel and Fail-safe retention periods for transient tables?
Transient tablesTime TravelFail-safeData retention - Question #21Account Access and Security
What is a best practice after creating a custom role?
Role-Based Access ControlSecurity Best PracticesSnowflake RolesRole Hierarchy - Question #22Data Protection and Data Sharing
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
Secure ShareData SharingShareable ObjectsSnowflake Objects - Question #23Snowflake Cloud Data Platform Features and Architecture
Will data cached in a warehouse be lost when the warehouse is resized?
WarehousesCachingArchitectureData Persistence - Question #24Data Governance
Which Snowflake partner specializes in data catalog solutions?
Data CatalogSnowflake PartnersData Governance Ecosystem - Question #25Data Loading and Unloading
What is the MOST performant file format for loading data in Snowflake?
Data Loading Best PracticesFile FormatsPerformance OptimizationColumnar Storage - Question #26Data Loading and Unloading
Which copy INTO command outputs the data into one file?
Data UnloadingOutput File ControlCOPY INTOSingle File - Question #27Performance Management
Where would a Snowflake user find information about query activity from 90 days ago?
Query HistoryAccount Usage ViewsMetadata Retention - Question #28Performance Management
Which Snowflake technique can be used to improve the performance of a query?
ClusteringQuery PerformancePerformance Optimization - Question #29Account Access and Security
User-level network policies can be created by which of the following roles? (Select TWO).
Snowflake RolesNetwork PoliciesAccess ControlSecurity Administration - Question #30Data Loading and Unloading
Which command can be used to load data into an internal stage?
Data loadingInternal stagesPUT command - Question #31Data Loading and Unloading
What happens when an external or an internal stage is dropped? (Select TWO).
Stage ManagementExternal StagesInternal StagesDROP STAGE - Question #32Data Loading and Unloading
How long is Snowpipe data load history retained?
SnowpipeData LoadingRetention PolicyLoad History - Question #33Data Protection and Data Sharing
In which use cases does Snowflake apply egress charges?
Egress chargesDatabase replicationData transfer costsCloud billing - Question #34Data Governance
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Dynamic Data MaskingACCOUNT_USAGE ViewsData GovernanceAuditing - Question #35Snowflake Cloud Data Platform Features and Architecture
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Snowflake architectureCloud Services layerQuery compilationPlatform components - Question #36Account Access and Security
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
Snowflake EditionsPrivate ConnectivityNetwork SecurityPrivateLink - Question #37Performance Management
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
Query ProfilerQuery OptimizationPerformance MetricsMicro-partitions - Question #38Account Access and Security
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate thi...
Snowflake Access ControlVirtual WarehousesGRANT StatementMODIFY Privilege - Question #39Performance Management
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
Query performanceMemory managementQuery profileSpilling - Question #40Data Loading and Unloading
Which stage type can be altered and dropped?
Snowflake stagesExternal stagesData loadingDDL - Question #41Data Loading and Unloading
Which command can be used to stage local files from which Snowflake interface?
SnowSQLStaging local filesPUT commandData loading interfaces - Question #42Data Loading and Unloading
What is the recommended file sizing for data loading using Snowpipe?
SnowpipeData loadingFile sizingBest practices - Question #43Snowflake Cloud Data Platform Features and Architecture
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
Snowflake ArchitectureCloud Services LayerAuthenticationMetadata Management - Question #44Storage and Data Protection
What data is stored in the Snowflake storage layer? (Select TWO).
Snowflake architectureStorage layerMicro-partitionsPersisted query results - Question #45Snowflake Cloud Data Platform Features and Architecture
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
Cloud ServicesBillingCredit ConsumptionCost Management - Question #46Data Transformations
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
CREATE PIPECOPY INTOData LoadingIn-line Transformations - Question #47Snowflake Cloud Data Platform Features and Architecture
What is a responsibility of Snowflake's virtual warehouses?
Virtual WarehousesCompute LayerSnowflake ArchitectureQuery Processing - Question #48Snowflake Cloud Data Platform Features and Architecture
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
SnowpipeVirtual WarehouseManaged ServicesCompute Resources - Question #49Performance Management
What happens when a virtual warehouse is resized?
Virtual WarehousesWarehouse ResizingCompute ResourcesQuery Execution - Question #50Data Governance
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked dat
Masking PoliciesData GovernanceRole-Based Access Control (RBAC)Object Ownership