COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 2 of 14.
- Question #51Snowflake Cloud Data Platform Features and Architecture
Which of the following describes how clustering keys work in Snowflake?
Clustering KeysAutomatic ClusteringPerformance OptimizationData Organization - Question #52Snowflake AI Data Cloud Features and Architecture
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Snowflake Partner EcosystemMachine Learning PartnersData Science PartnersDataRobot - Question #53Data Loading and Unloading
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
External StagesAzure IntegrationData LoadingCloud Storage - Question #54Snowflake Cloud Data Platform Features and Architecture
Which data type can be used to store geospatial data in Snowflake?
Data typesGeospatial dataGEOGRAPHY data type - Question #55Performance Management
What can be used to view warehouse usage over time? (Select Two).
Warehouse UsageMonitoringAccount Usage ViewsCost Management - Question #56Storage and Data Protection
Which Snowflake feature is used for both querying and restoring data?
Time TravelData RecoveryHistorical DataData Versioning - Question #57Account Access and Security
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi- Factor Authentication (MFA) service to provide increased login security for users con...
MFALogin securityDuo MobileAccount security - Question #58Data Transformations
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Snowflake StreamsChange Data Capture (CDC)DML TrackingData Transformation - Question #59Data Loading and Unloading
What tasks can be completed using the copy command? (Select TWO)
COPY INTO commandData loadingColumn selectionData transformation basics - Question #60Performance Management
What feature can be used to reorganize a very large table on one or more columns?
Clustering keysTable optimizationData organizationPerformance management - Question #61Account Access and Security
What SQL command would be used to view all roles that were granted to USER1?
SQL CommandsUser ManagementRole ManagementGrants - Question #62Data Loading and Unloading
Which of the following can be executed/called with Snowpipe?
SnowpipeContinuous data loadingCOPY INTOData ingestion - Question #63Account Access and Security
What Snowflake role must be granted for a user to create and manage accounts?
Built-in rolesACCOUNTADMINAccount managementRole-Based Access Control (RBAC) - Question #64Data Loading and Unloading
When unloading to a stage, which of the following is a recommended practice or approach?
Data UnloadingFile FormatsCOPY INTO - Question #65Performance Management
When is the result set cache no longer available? (Select TWO)
Result set cacheQuery performanceCachingCache invalidation - Question #66Snowflake Cloud Data Platform Features and Architecture
Which of the following describes external functions in Snowflake?
External FunctionsUser-defined FunctionsUDFsFunctions - Question #67Data Protection and Data Sharing
What are ways to create and manage data shares in Snowflake? (Select TWO)
Data SharingShare ManagementSnowflake UISQL Commands - Question #68Account Access and Security
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return th...
Login HistoryAccount Usage ViewsSecurity AuditingInformation Schema - Question #69Data Loading and Unloading
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Data UnloadingFile FormatsSemi-structured Data - Question #70Snowflake Cloud Data Platform Features and Architecture
What is the purpose of an External Function?
External FunctionsUDFsIntegration - Question #71Snowflake Cloud Data Platform Features and Architecture
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
SnowsightWorksheet SharingCollaborationUI Features - Question #72Performance Management
What is the purpose of multi-cluster virtual warehouses?
Virtual WarehousesMulti-clusterQuery ConcurrencyPerformance Scaling - Question #73Snowflake Cloud Data Platform Features and Architecture
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
Snowflake ArchitectureCloud InfrastructureHigh AvailabilityCloud Provider Integration - Question #74Storage and Data Protection
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
Storage CostsCompute CostsMaterialized ViewsTransient Tables - Question #75Data Loading and Unloading
A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?
Data LoadingExternal StagesPerformance OptimizationFile Organization - Question #76Snowflake Cloud Data Platform Features and Architecture
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
Virtual WarehouseWarehouse SizingCompute ResourcesSnowflake Architecture - Question #77Snowflake Cloud Data Platform Features and Architecture
Which command sets the Virtual Warehouse for a session?
Virtual WarehousesSQL CommandsSession Context - Question #78Data Loading and Unloading
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
Snowflake PipesCREATE OR REPLACE PIPELoad HistoryData Loading - Question #79Data Loading and Unloading
True or False: Snowpipe via REST API can only reference External Stages as source.
SnowpipeData LoadingExternal StagesInternal Stages - Question #80Data Loading and Unloading
Which of the following are best practices for loading data into Snowflake? (Choose three.)
Data Loading Best PracticesFile SizingStaging DataParallel Processing - Question #81Snowflake Cloud Data Platform Features and Architecture
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
Virtual WarehouseScalingScale UpScale Out - Question #82Data Governance
What is the minimum Snowflake edition that has column-level security enabled?
Snowflake editionsColumn-level securityData governance featuresSecurity features - Question #83Storage and Data Protection
When cloning a database, what is cloned with the database? (Choose two.)
Database CloningObject CloningPrivilegesZero-Copy Cloning - Question #84Snowflake Cloud Data Platform Features and Architecture
Which of the following describes the Snowflake Cloud Services layer?
Snowflake architectureCloud Services layerArchitectural components - Question #85Storage and Data Protection
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Continuous Data ProtectionTemporary tablesTime TravelData retention policy - Question #86Performance Concepts
What type of query benefits the MOST from search optimization?
Search Optimization ServiceQuery PerformanceEquality PredicatesIN Predicates - Question #87Snowflake Cloud Data Platform Features and Architecture
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
Virtual WarehouseWarehouse ManagementSnowSQLConnectivity - Question #88Data Loading and Unloading
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
Data loadingCOPY INTOExternal stageSQL commands - Question #89Snowflake Cloud Data Platform Features and Architecture
The Snowflake Cloud Data Platform is described as having which of the following architectures?
Snowflake architectureMulti-cluster shared dataCloud Data Platform - Question #90Data Protection and Data Sharing
Which of the following is a data tokenization integration partner?
Data TokenizationData SecurityIntegration PartnersThird-Party Integrations - Question #91Data Governance
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Snowflake EditionsPII ComplianceData SecurityVirtual Private Snowflake - Question #92Data Loading and Unloading
What are supported file formats for unloading data from Snowflake? (Choose three.)
data unloadingfile formatsexternal stages - Question #93Snowflake Cloud Data Platform Features and Architecture
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
Snowflake architectureCloud Services LayerAuthenticationMetadata management - Question #94Data Protection and Data Sharing
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
Snowflake Data MarketplaceCross-Region Data SharingORGADMIN RoleData Replication - Question #95Data Loading and Unloading
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
SnowpipeData LoadingFile SizeBest Practices - Question #96Data Protection and Data Sharing
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it...
External TokenizationData ProtectionSensitive DataData Security - Question #97Data Governance
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
ACCOUNT_USAGE viewsACCESS_HISTORYData governanceAuditing - Question #98Snowflake Cloud Data Platform Features and Architecture
A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
Virtual WarehouseBillingCost ManagementCompute Charges - Question #99Snowflake Cloud Data Platform Features and Architecture
What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)
Snowflake ArchitectureCloud Service LayerLayer ResponsibilitiesCore Architecture - Question #100Storage and Data Protection
How long is the Fail-safe period for temporary and transient tables?
Fail-safeTemporary tablesTransient tablesData retention policy