COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 3 of 14.
- Question #101Data Loading and Unloading
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Data unloadingGET commandSnowflake stagesLocal file system - Question #102Storage and Data Protection
How does Snowflake Fail-safe protect data in a permanent table?
Fail-safeData ProtectionPermanent TablesData Recovery - Question #103Performance Management
A virtual warehouse is created using the following command: Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_r...
Virtual WarehousesMulti-cluster WarehousesConcurrency ManagementPerformance Tuning - Question #104Snowflake Cloud Data Platform Features and Architecture
Which minimum Snowflake edition allows for a dedicated metadata store?
Snowflake EditionsMetadata StorePlatform Architecture - Question #105Account Access and Security
Network policies can be set at which Snowflake levels? (Choose two.)
Network PoliciesSecurityAccess ControlAccount Administration - Question #106Storage and Data Protection
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
Time TravelFail-safeData RetentionEnterprise Edition - Question #107Snowflake Cloud Data Platform Features and Architecture
Which of the following objects are contained within a schema? (Choose two.)
Schema objectsObject hierarchyStreamExternal table - Question #108Snowflake Cloud Data Platform Features and Architecture
Which of the following statements describe features of Snowflake data caching? (Choose two.)
Data CachingQuery Result CacheVirtual Warehouse CacheCache Eviction Policy - Question #109Data Loading and Unloading
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The fol...
Data LoadingJSON DataCOPY INTOFile Sizing Best Practices - Question #110Account Access and Security
Which of the following describes a Snowflake stored procedure?
Stored ProceduresExecution RightsSecurity ModelPermissions - Question #111Data Transformations
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
FLATTEN functionSemi-structured dataJSON processingARRAY processing - Question #112Data Transformations
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
JSONVARIANT data typeSemi-structured dataData transformation - Question #113Snowflake Cloud Data Platform Features and Architecture
How are serverless features billed?
Serverless featuresBillingCost managementPricing model - Question #114Snowflake Cloud Data Platform Features and Architecture
Which Snowflake architectural layer is responsible for a query execution plan?
Snowflake ArchitectureCloud Services LayerQuery Execution PlanQuery Optimization - Question #115Data Transformations
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
Snowflake StreamsChange Data CaptureStream ConsumptionDML Operations - Question #116Data Loading and Unloading
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Snowflake StagesData LoadingFile ManagementCOPY INTO - Question #117Performance Concepts
Assume there is a table consisting of five micro-partitions with values ranging from A to Z. Which diagram indicates a well-clustered table? A. B. C. D.
ClusteringMicro-partitionsQuery PerformanceTable Optimization - Question #118Performance Management
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
Explain PlanQuery ProfilerPerformance TuningQuery Optimization - Question #119Snowflake Cloud Data Platform Features and Architecture
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
Semi-structured dataData typesVARIANTARRAY - Question #120Data Governance
How can a row access policy be applied to a table or a view? (Choose two.)
Row Access PolicyData GovernanceRow-Level SecurityDDL Syntax - Question #121Data Loading and Unloading
Which command can be used to load data files into a Snowflake stage?
Snowflake stagesData loading to stagePUT commandFile upload - Question #122Data Protection and Data Sharing
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
Data MarketplaceData SharingListing TypesPersonalized Listings - Question #123Storage and Data Protection
What is the maximum Time Travel retention period for a temporary Snowflake table?
Time TravelTemporary TablesData RetentionTable Limits - Question #124Performance Management
When should a multi-cluster warehouse be used in auto-scaling mode?
Multi-cluster warehouseAuto-scalingWarehouse scalingConcurrency management - Question #125Data Loading and Unloading
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
External StagesCloud PlatformsData LoadingPlatform Integration - Question #126Account Access and Security
In the Snowflake access control model, which entity owns an object by default?
Snowflake Access ControlRBACObject OwnershipRoles - Question #127Data Governance
What is the minimum Snowflake edition required to use Dynamic Data Masking?
Dynamic Data MaskingSnowflake EditionsData GovernanceSecurity Features - Question #128Snowflake Cloud Data Platform Features and Architecture
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
Snowflake ArchitectureCloud Services LayerAuthenticationMetadata Management - Question #129Data Governance
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII. Which Snowflake feature will...
Data maskingPIIData governanceSecurity policies - Question #130Data Loading and Unloading
A user has unloaded data from a Snowflake table to an external stage. Which command can be used to verify if data has been uploaded to the external stage named my_stage?
External StagesData UnloadingLIST CommandStage Contents - Question #131Snowflake Cloud Data Platform Features and Architecture
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
Snowflake architectureCloud Services layerMetadata managementQuery optimization - Question #132Data Protection and Data Sharing
What is true about sharing data in Snowflake? (Choose two.)
Data SharingCost ModelConsumer Provider RolesZero-Copy Sharing - Question #133Data Transformations
The following JSON is stored in a VARIANT column called src of the CAR_SALES table: A user needs to extract the dealership information from the JSON. How can this be accomplished?
JSON dataVARIANT data typeSemi-structured data queryingDot notation - Question #134Performance Management
Which of the following significantly improves the performance of selective point lookup queries on a table?
Search Optimization ServicePerformance TuningPoint Lookup QueriesQuery Optimization - Question #135Data Protection and Data Sharing
Which of the following accurately describes shares?
Data SharingSnowflake SharesShared Objects - Question #136Account Access and Security
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
ACCOUNTADMIN roleSecurity best practicesMFARole-based access control - Question #137Data Governance
What is the minimum Snowflake edition required for row level security?
Snowflake EditionsRow Level SecurityData SecurityData Governance Features - Question #138Storage and Data Protection
The is the minimum Fail-safe retention time period for transient tables?
Fail-safeData RetentionTransient TablesTable Types - Question #139Data Protection and Data Sharing
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Snowflake Data MarketplaceSecure Data SharingThird-Party DataLive Data Access - Question #140Performance Management
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Materialized ViewsCredit ConsumptionMaintenance CostsClustering - Question #141Data Loading and Unloading
What COPY INTO SQL command should be used to unload data into multiple files?
COPY INTO unloadData UnloadingMultiple FilesSQL Command - Question #142Storage and Data Protection
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
CloningZero-copy cloningStored ProceduresViews - Question #143Data Loading and Unloading
When loading data into Snowflake, how should the data be organized?
Data LoadingFile SizeBest PracticesStaging - Question #144Data Protection and Data Sharing
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
UNDROP commandObject recoveryData protectionSnowflake objects - Question #145Account Access and Security
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
RBACSHOW GRANTSAccess ControlSecurity Auditing - Question #146Account Access and Security
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
SCIMSecurity IntegrationSnowflake Editions - Question #147Storage and Data Protection
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first...
Time TravelTransient TablesData RetentionFail-safe - Question #148Storage and Data Protection
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
Continuous Data ProtectionTime TravelFail-safeData Storage - Question #149Account Access and Security
Where can a user find and review the failed logins of a specific user for the past 30 days?
Account UsageLogin HistorySecurity MonitoringAuditing - Question #150Account Access and Security
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Role-Based Access ControlData EncryptionSecurity FeaturesAccess Management