COF-C02 Exam Questions
688 real COF-C02 exam questions with expert-verified answers and explanations. Page 14 of 14.
- Question #654Performance Concepts
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Virtual WarehousesWarehouse ProvisioningCompute ScalingPerformance Variability - Question #655Performance Management
How would you determine the size of the virtual warehouse used for a task?
Virtual WarehousesSnowflake TasksPerformance TuningWarehouse Sizing - Question #656Storage and Data Protection
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Information SchemaAccount UsageStorage MonitoringMetadata Views - Question #657Data Loading and Unloading
What is the default File Format used in the COPY command if one is not specified?
COPY commandFile formatsDefault behaviorData loading - Question #658Data Protection and Data Sharing
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
Reader AccountsData SharingData UnloadingData Export Restrictions - Question #659Data Loading and Unloading
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
Data LoadingFile Size LimitsIngestion - Question #660Performance Management
True or False: A Virtual Warehouse can be resized while suspended.
Virtual WarehouseWarehouse ManagementResizingSuspended State - Question #661Account Access and Security
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
Custom RolesRole-Based Access ControlSecurity Best PracticesLeast Privilege - Question #662Data Protection and Data Sharing
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
Data SharingSnowflake Web InterfaceSQLData Management - Question #663Storage and Data Protection
True or False: Fail-safe can be disabled within a Snowflake account.
Fail-safeData protectionData recovery - Question #664Performance Management
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Query Result CacheWarehousePerformance Optimization - Question #665Snowflake Cloud Data Platform Features and Architecture
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Virtual WarehousesAuto-suspendAuto-resumeCompute Management - Question #666Storage and Data Protection
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
data protectiontime travelfail-safedata recovery - Question #667Performance Management
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Results cacheQuery performanceCaching rulesAccess control - Question #668Data Loading and Unloading
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Data LoadingBest PracticesPerformance OptimizationParallel Processing - Question #669Snowflake Cloud Data Platform Features and Architecture
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Snowflake EditionsEnterprise Edition FeaturesData ReplicationExtended Time Travel - Question #670Data Loading and Unloading
What is the default file size when unloading data from Snowflake using the COPY command?
COPY commandData unloadingFile sizeDefault settings - Question #671Storage and Data Protection
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
Continuous Data Protection (CDP)Data EncryptionTime TravelDefault Features - Question #672Snowflake Cloud Data Platform Features and Architecture
Which Snowflake layer is always leveraged when accessing a query from the result cache?
Snowflake ArchitectureCloud Services LayerResult CacheQuery Processing - Question #673Data Governance
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can th...
Dynamic Data MaskingData GovernanceSecurity PoliciesAccess Control - Question #674Storage and Data Protection
Users are responsible for data storage costs until what occurs?
Storage costsFail-safeData retentionBilling - Question #675Performance Concepts
What affects whether the query results cache can be used?
Query CachingResult CachePerformance OptimizationData Freshness - Question #676Performance Concepts
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Compute resourcesVirtual warehousesQuery executionAggregate functions - Question #677Data Loading and Unloading
How many days is load history for Snowpipe retained?
SnowpipeLoad HistoryData RetentionContinuous Data Loading - Question #678Storage and Data Protection
Which of the following are benefits of micro-partitioning? (Select TWO)
Micro-partitioningStorage architectureTime TravelData pruning - Question #679Snowflake Cloud Data Platform Features and Architecture
What is the minimum Snowflake edition required to create a materialized view?
materialized viewsSnowflake editionsfeature availabilitydata optimization - Question #680Performance Concepts
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Automatic ClusteringMicro-partitionsQuery OptimizationData Pruning - Question #681Account Access and Security
Which feature is only available in the Enterprise or higher editions of Snowflake?
Snowflake editionsColumn-level securityDynamic Data MaskingSecurity features - Question #682Account Access and Security
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
User authenticationFederated authenticationKey-pair authenticationOAuth - Question #683Performance Management
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Warehouse ManagementQuery QueuingPerformance TuningTimeout Parameters - Question #684Performance Management
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Clustering KeyPerformance OptimizationClustering DepthMicro-partitions - Question #685Data Loading and Unloading
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Data loadingSnowpipePipesAutomated ingestion - Question #686Account Access and Security
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
Role-Based Access Control (RBAC)PrivilegesMaterialized ViewsUser Management - Question #687Data Loading and Unloading
What is the default character set used when loading CSV files into Snowflake?
Data LoadingCharacter SetsCSV FilesDefault Settings - Question #688Snowflake Cloud Data Platform Features and Architecture
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?
Snowflake metadataCOUNT(1) optimizationCloud Services layerQuery performance - Question #689Performance Management
Which cache type is used to cache data output from SQL queries?
Result CacheQuery CachingPerformance OptimizationSnowflake Features - Question #690Snowflake Cloud Data Platform Features and Architecture
What is a key feature of Snowflake architecture?
Snowflake ArchitectureVirtual WarehousesResource ContentionCompute Layer - Question #691Snowflake Cloud Data Platform Features and Architecture
What is a limitation of a Materialized View?
Materialized ViewsSnowflake FeaturesLimitationsData Optimization