COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 8 of 14.
- Question #351Performance Concepts
How should clustering be used to optimize the performance of queries that run on a very large table?
Snowflake ClusteringPerformance OptimizationClustering KeyTable Optimization - Question #352Performance Concepts
What step can reduce data spilling in Snowflake?
Data SpillingVirtual WarehousePerformance TuningQuery Performance - Question #353Data Loading and Unloading
Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?
Data LoadingCOPY INTOVALIDATION_MODEError Handling - Question #354Performance Management
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Search Optimization ServicePoint LookupQuery PerformancePerformance Tuning - Question #355Storage and Data Protection
Which Snowflake object does not consume any storage costs?
Temporary tablesStorage costsTable typesSnowflake objects - Question #356Data Loading and Unloading
Which function unloads data from a relational table to JSON?
Data UnloadingJSON FunctionsSemi-structured DataTO_JSON Function - Question #357Data Loading and Unloading
Which commands can only be executed using SnowSQL? (Select TWO).
SnowSQLData LoadingStagesClient Tools - Question #358Performance Management
What is the relationship between a Query Profile and a virtual warehouse?
Query ProfileVirtual WarehousePerformance TuningRight-sizing - Question #359Data Loading and Unloading
What is the primary purpose of a directory table in Snowflake?
Directory tablesExternal stagesFile metadataData loading - Question #360Snowflake Cloud Data Platform Features and Architecture
Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).
Snowflake ArchitectureCompute-Storage SeparationIndependent ScalingVirtual Warehouses - Question #361Account Access and Security
Which commands are restricted in owner's rights stored procedures? (Select TWO).
Stored ProceduresOwner's RightsCommand Restrictions - Question #362Data Governance
Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Access HistoryData Usage MonitoringData Lifecycle ManagementCost Optimization - Question #363Account Access and Security
Which privilege must be granted by one role to another role, and cannot be revoked?
privilegesrolesownershipaccess control - Question #364Performance Management
How can performance be optimized for a query that returns a small amount of data from a very large base table?
Query optimizationPerformance tuningSearch optimization serviceSelective queries - Question #365Data Transformations
What does the LATERAL modifier for the FLATTEN function do?
FLATTEN functionLATERAL modifierSemi-structured dataData transformation - Question #366Data Governance
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
Data GovernanceTagsSensitive Data TrackingCompliance - Question #367Snowflake Cloud Data Platform Features and Architecture
What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
virtual warehousescompute elasticitydynamic scalingresource management - Question #368Storage and Data Protection
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
Time TravelData RetentionAccount ParametersConfiguration - Question #369Data Governance
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database. Which CREATE object statement will automatically assign the TABLE_A tag to a target obj...
Snowflake TagsTag PropagationCREATE TABLE AS SELECTObject Tagging - Question #370Data Protection and Data Sharing
What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Dynamic Data MaskingData MaskingSnowflake ObjectsSecurity Features - Question #371Storage and Data Protection
What happens when a Snowflake user changes the data retention period at the schema level?
Data RetentionSchema ParametersObject InheritanceTime Travel - Question #372Data Transformations
Which Snowflake function will parse a JSON-null into a SQL-null?
JSON Data HandlingNULL HandlingData ParsingData Type Conversion - Question #373Data Loading and Unloading
While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?
unstructured datastaged filesfile functionsBUILD_STAGE_FILE_URL - Question #374Snowflake Cloud Data Platform Features and Architecture
Which Snowflake database object can be used to track data changes made to table data?
StreamChange Data CaptureData TrackingDatabase Objects - Question #375Data Loading and Unloading
What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).
COPY INTO commandData loading transformationsColumn reorderingColumn omission - Question #376Data Protection and Data Sharing
Which Snowflake table objects can be shared with other accounts? (Select TWO).
Data SharingTable TypesPermanent TablesExternal Tables - Question #377Data Protection and Data Sharing
Which object can be used with Secure Data Sharing?
Secure Data SharingData SharingViewsSnowflake Objects - Question #378Data Governance
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
Data AuditingACCESS_HISTORY ViewUser Access TrackingSensitive Data Access - Question #379Data Transformations
Which type of loop requires a BREAK statement to stop executing?
SQL ScriptingControl FlowLoopsBREAK statement - Question #380Snowflake Cloud Data Platform Features and Architecture
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Micro-partitionsSnowflake ArchitectureTime TravelQuery Optimization - Question #381Data Protection and Data Sharing
Which views are included in the DATA SHARING USAGE schema? (Select TWO).
DATA_SHARING_USAGE SchemaSnowflake MarketplaceMonetized UsageData Sharing Views - Question #382Account Access and Security
What are the least privileges needed to view and modify resource monitors? (Select TWO).
Resource MonitorsPrivilegesAccess Control - Question #383Data Transformations
How can a Snowflake user traverse semi-structured data?
Semi-structured dataVARIANT data typeData traversalColon notation - Question #384Data Transformations
What is the purpose of the Snowflake SPLIT TO_TABLE function?
SQL functionsString manipulationTable functionsData transformation - Question #385Data Transformations
A column named "Data" contains VARIANT data and stores values as follows: How will Snowflake extract the employee's name from the column data?
VARIANT data typeSemi-structured dataJSON extractionDot notation - Question #386Account Access and Security
Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
MFADuo SecurityLogin SecurityAuthentication - Question #387Account Access and Security
A Snowflake account has activated federated authentication. What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
Federated AuthenticationSSOUser AuthenticationLogin Process - Question #388Performance Concepts
What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?
Query ProfileSpillingPerformance OptimizationMemory Management - Question #389Performance Management
What information is found within the Statistic output in the Query Profile Overview?
Query ProfilePerformance MonitoringQuery PerformancePerformance Tuning - Question #390Data Protection and Data Sharing
How do secure views compare to non-secure views in Snowflake?
Secure ViewsViewsPerformanceData Security - Question #391Data Loading and Unloading
When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? {Select TWO).
SnowSQLData UnloadingConfigurationLocal File Output - Question #392Snowflake Cloud Data Platform Features and Architecture
How can a Snowflake user post-process the result of SHOW FILE FORMATS?
RESULT_SCANSHOW commandsMetadata queryingTable functions - Question #393Data Loading and Unloading
Which file function gives a user or application access to download unstructured data from a Snowflake stage?
Snowflake stagesUnstructured dataPresigned URLsData downloading - Question #394Performance Management
When should a multi-cluster virtual warehouse be used in Snowflake?
Virtual WarehouseMulti-clusterConcurrencyQuery queuing - Question #395Data Transformations
A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID. Which st...
JSONVARIANT Data TypeSemi-structured DataSQL Querying - Question #396Snowflake Cloud Data Platform Features and Architecture
Which Snowflake tool is recommended for data batch processing?
SnowSQLBatch processingCommand-line clientSnowflake tools - Question #397Performance Management
How does the Snowflake search optimization service improve query performance?
Search OptimizationQuery PerformancePerformance TuningEquality Searches - Question #398Data Loading and Unloading
What compute resource is used when loading data using Snowpipe?
SnowpipeData LoadingCompute ResourcesServerless - Question #399Data Protection and Data Sharing
What is one of the characteristics of data shares?
Data SharingSecure ViewsView ObjectsSecurity Features - Question #400Data Protection and Data Sharing
Which DDL/DML operation is allowed on an inbound data share?
Data SharingInbound ShareRead-Only DataDML Operations