COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 9 of 14.
- Question #401Account Access and Security
In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities? (Select TWO).
Federated AuthenticationSSOUser AuthenticationAccount Access - Question #402Data Loading and Unloading
A user wants to upload a file to an internal Snowflake stage using a put command. Which tools and or connectors could be used to execute this command? (Select TWO).
Data LoadingInternal StagesPUT CommandSnowflake Client Tools - Question #403Snowflake Cloud Data Platform Features and Architecture
Which SQL statement will require a virtual warehouse to run?
Virtual WarehouseCompute LayerDMLSnowflake Architecture - Question #404Snowflake Cloud Data Platform Features and Architecture
Which statement accurately describes how a virtual warehouse functions?
Virtual WarehousesCompute ArchitectureSnowflake Architecture - Question #405Data Loading and Unloading
From what stage can a Snowflake user omit the FROM clause while loading data into a table?
Data LoadingCOPY INTO commandTable StageFROM clause - Question #406Data Protection and Data Sharing
A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access. Which file function should be used?
Presigned URLUnstructured DataInternal StageExternal Sharing - Question #407Account Access and Security
What activities can a user with the ORGADMIN role perform? (Select TWO).
ORGADMIN roleOrganizational administrationDatabase replicationUsage monitoring - Question #408Account Access and Security
What is a feature of column-level security in Snowflake?
Column-level securityMasking policiesAccess controlRole-based access control - Question #409Data Loading and Unloading
What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).
COPY INTO commandData loading transformationsColumn reorderingData type conversion - Question #410Data Loading and Unloading
What consideration should be made when loading data into Snowflake?
Data LoadingVirtual WarehouseParallelismPerformance - Question #411Data Governance
Which Snowflake feature can be used to find sensitive data in a table or column?
Sensitive dataData classificationData governance - Question #412Account Access and Security
What can the Snowflake SCIM API be used to manage? (Select TWO).
SCIM APIUser ProvisioningRole ManagementIdentity Management - Question #413Data Transformations
Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Semi-structured DataCase SensitivityVariant DataData Traversal - Question #414Account Access and Security
What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).
Session initiationRolesDefault rolesAccess control - Question #415Snowflake Cloud Data Platform Features and Architecture
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
UDFsFunction OverloadingSnowflake Features - Question #416Snowflake Cloud Data Platform Features and Architecture
Which data types optimally store semi-structured data? (Select TWO).
Semi-structured dataData typesVARIANTARRAY - Question #417Account Access and Security
Which SQL command can be used to verify the privileges that are granted to a role?
SQL CommandsRoles and PrivilegesAccess ControlSecurity - Question #418Performance Management
Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
Search Optimization ServicePerformance TuningQuery OptimizationWHERE Conditions - Question #419Data Protection and Data Sharing
There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production accoun...
Data SharingCross-account data transferSnowflake features - Question #420Account Access and Security
Which privilege is required to use the search optimization service in Snowflake?
Search OptimizationPrivilegesAccess ControlGRANT statement - Question #421Data Protection and Data Sharing
What are the benefits of the replication feature in Snowflake? (Select TWO).
ReplicationDisaster RecoveryDatabase FailoverBusiness Continuity - Question #422Account Access and Security
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the...
Query HistorySnowsightRole-Based Access Control (RBAC)ACCOUNTADMIN Role - Question #423Storage and Data Protection
What is the Fail-safe retention period for transient and temporary tables?
Fail-safetransient tablestemporary tablesdata retention - Question #424Data Loading and Unloading
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
Floating-point numbersData unloadingCSV/JSON formatsPrecision - Question #425Data Transformations
How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Stored ProceduresUser-Defined Functions (UDFs)SQL InvocationProgrammability - Question #426Storage and Data Protection
Which URL provides access to files in Snowflake without authorization?
Pre-signed URLsExternal StagesData AccessTemporary Access - Question #427Performance Concepts
What does the TableScan operator represent in the Query Profile?
Query ProfileQuery OperatorsTableScanPerformance Optimization - Question #428Snowflake Cloud Data Platform Features and Architecture
Which Snowflake data type is used to store JSON key value pairs?
Snowflake data typesJSON storageVARIANT data typeSemi-structured data - Question #429Data Loading and Unloading
How does Snowflake reorganize data when it is loaded? (Select TWO).
Data LoadingColumnar StorageData CompressionStorage Format - Question #430Account Access and Security
What activities can a user with the ORGADMIN role perform? (Select TWO).
ORGADMIN RoleAccount ManagementOrganization AccountsUsage Monitoring - Question #431Account Access and Security
How are network policies defined in Snowflake?
Network PoliciesAccount AccessIP WhitelistingSecurity - Question #432Snowflake Cloud Data Platform Features and Architecture
What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?
Multi-cluster virtual warehouseVirtual warehouse scalingCluster limits - Question #433Performance Management
The effects of query pruning can be observed by evaluating which statistics? (Select TWO).
Query PruningPerformance OptimizationQuery StatisticsMicro-partitions - Question #434Performance Management
What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?
Virtual WarehouseAuto suspendDefault settingsCost management - Question #435Data Loading and Unloading
When unloading data, which file format preserves the data values for floating-point number columns?
Data UnloadingFile FormatsFloating-point PrecisionParquet - Question #436Data Loading and Unloading
A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the dat
Semi-structured dataData loadingTEXT data typeData type selection - Question #437Snowflake Cloud Data Platform Features and Architecture
Which activities are included in the Cloud Services layer? {Select TWO).
Snowflake ArchitectureCloud Services LayerPlatform ComponentsAuthentication - Question #438Snowflake Cloud Data Platform Features and Architecture
How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
Query HistoryWeb InterfaceUI FeaturesData Retention - Question #439Performance Concepts
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
Micro-partitionsQuery pruningPerformance optimizationData scanning - Question #440Data Transformations
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
Directory TableExternal StagesFile Path ExtractionSQL Functions - Question #441Data Loading and Unloading
What is the only supported character set for loading and unloading data from all supported file formats?
Character setData loadingData unloadingFile formats - Question #442Snowflake Cloud Data Platform Features and Architecture
Which statement accurately describes Snowflake's architecture?
Snowflake architectureshared-diskshared-nothingcloud data warehousing - Question #443Performance Management
Which use case does the search optimization service support?
Search OptimizationQuery PerformanceSnowflake Features - Question #444Storage and Data Protection
What are characteristics of transient tables in Snowflake? (Select TWO).
Transient TablesTable TypesData RetentionCloning - Question #445Snowflake Cloud Data Platform Features and Architecture
What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
Virtual WarehousesWarehouse ManagementSuspended StateResource Provisioning - Question #446Storage and Data Protection
How can a user get the MOST detailed information about individual table storage details in Snowflake?
Storage MetricsAccount UsageData StorageTime Travel - Question #447Storage and Data Protection
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
Transient tablesFail-safeData retentionTable types - Question #448Storage and Data Protection
Which view can be used to determine if a table has frequent row updates or deletes?
System viewsStorage monitoringTable metricsDML operations - Question #449Performance Management
While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).
ClusteringClustering KeysData TypesPerformance Optimization - Question #450Snowflake Cloud Data Platform Features and Architecture
What does the worksheet and database explorer feature in Snowsight allow users to do?
SnowsightWorksheet managementUser interfaceProductivity features