COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 5 of 14.
- Question #201Storage and Data Protection
Which of the following are characteristics of security in Snowflake?
Security FeaturesData EncryptionRekeyingEdition Features - Question #202Account Access and Security
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW. Which command w...
SHOW GRANTSAccess ControlSchema PrivilegesSQL Syntax - Question #203Data Loading and Unloading
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
Data LoadingLoad HistorySnowpipeMetadata Retention - Question #204Account Access and Security
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
Secure ViewsInformation SchemaAccount UsageMetadata Queries - Question #205Data Loading and Unloading
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does...
Data LoadingPerformance OptimizationFile SizingBulk Load - Question #206Performance Management
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
ClusteringPerformance OptimizationTable Design - Question #207Storage and Data Protection
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
Snowflake EditionsSecurity FeaturesData EncryptionMicro-partitions - Question #208Account Access and Security
What privilege should a user be granted to change permissions for new objects in a managed access schema?
Access ControlManaged Access SchemasMANAGE GRANTS PrivilegeSecurity - Question #209Performance Management
A materialized view should be created when which of the following occurs? (Choose two.)
Materialized ViewsPerformance OptimizationQuery PerformanceCost Management - Question #210Data Protection and Data Sharing
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
Secure ViewsData Sharing PrivilegesCross-Database ReferencingREFERENCE_USAGE Privilege - Question #211Performance Management
Which feature allows a user the ability to control the organization of data in a micro-partition?
Automatic ClusteringMicro-partitionsClustering KeyPerformance Optimization - Question #212Performance Concepts
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?
Result CacheCachingQuery OptimizationVirtual Warehouse - Question #213Data Protection and Data Sharing
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
Snowflake Data ExchangeData SharingPrivate Data ExchangeData Provider Consumer - Question #214Data Protection and Data Sharing
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
Secure Data SharingDatabase ObjectsExternal TablesUDFs - Question #215Snowflake Cloud Data Platform Features and Architecture
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Snowflake ArchitectureCloud Services LayerQuery Processing - Question #216Snowflake Cloud Data Platform Features and Architecture
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
Account UsageCredit UsageCost ManagementMonitoring - Question #217Data Governance
Which SQL command can be used to see the CREATE definition of a masking policy?
GET_DDL functionMasking policiesDDL retrievalData governance - Question #218Performance Concepts
Which statement describes pruning?
PruningMicro-partitionsQuery OptimizationPerformance - Question #219Data Transformations
How can a user change which columns are referenced in a view?
ViewsDDLView ManagementCREATE OR REPLACE VIEW - Question #220Account Access and Security
Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)
Snowflake Access ControlGRANT StatementSELECT PrivilegeFuture Grants - Question #221Snowflake Cloud Data Platform Features and Architecture
Using variables in Snowflake is denoted by using which SQL character?
VariablesSQL SyntaxSession Variables - Question #222Data Protection and Data Sharing
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Data SharingConsumer AccountShared DatabaseObject Accessibility - Question #223Data Loading and Unloading
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
COPY commandData loadingFile validationVALIDATION_MODE - Question #224Account Access and Security
Which Snowflake tool would be BEST to troubleshoot network connectivity?
SnowCDNetwork connectivityTroubleshootingDiagnostic tools - Question #225Snowflake Cloud Data Platform Features and Architecture
Which activities are included in the Cloud Sen/ices layer? (Select TWO).
Snowflake architectureCloud Services layerUser authenticationInfrastructure management - Question #226Data Loading and Unloading
What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?
OBJECT_CONSTRUCT functionCOPY INTO (unload)VARIANT data typeData format conversion - Question #227Data Transformations
Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?
User-Defined Table Function (UDTF)SQL Query StructureFROM ClauseData Transformation - Question #228Data Transformations
Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?
SQL JoinsOuter JoinData Retrieval - Question #229Snowflake Cloud Data Platform Features and Architecture
Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).
Snowflake architectureCloud Services layerMetadata managementSecurity - Question #230Data Protection and Data Sharing
How can a data provider ensure that a data consumer is going to have access to the required objects?
Data SharingData ProviderConsumer AccessShared Objects - Question #231Performance Management
How can a user improve the performance of a single large complex query in Snowflake?
Virtual WarehousesQuery PerformanceWarehouse ScalingCompute Resources - Question #232Account Access and Security
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
MFAToken CachingClient ConnectivityAuthentication - Question #233Data Transformations
What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?
SnowparkUser-Defined FunctionsProgramming Languages - Question #234Snowflake Cloud Data Platform Features and Architecture
What is the MAXIMUM size limit for a record of a VARIANT data type?
VARIANT data typeData type limitsSemi-structured dataSnowflake data types - Question #235Account Access and Security
What is the name of the SnowSQLfile that can store connection information?
SnowSQLConfiguration filesConnection management - Question #236Data Protection and Data Sharing
A Snowflake user has been granted the create data EXCHANGE listing privilege with their role. Which tasks can this user now perform on the Data Exchange? (Select TWO).
Snowflake Data ExchangePrivilegesListing ManagementObject Ownership - Question #237Account Access and Security
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
MFAMulti-Factor AuthenticationDuo SecurityAccount Security - Question #238Account Access and Security
Which user object property requires contacting Snowflake Support in order to set a value for it?
MFASecurityUser PropertiesAccount Administration - Question #239Data Loading and Unloading
Which file format will keep floating-point numbers from being truncated when data is unloaded?
File FormatsData UnloadingFloating-Point NumbersData Integrity - Question #240Snowflake Cloud Data Platform Features and Architecture
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
Snowflake ArchitectureData Storage LayerColumnar FormatData Compression - Question #241Performance Management
What can a Snowflake user do in the Admin area of Snowsight?
Snowsight AdminQuery PerformancePerformance MonitoringWarehouse Monitoring - Question #242Performance Management
How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
Query optimizationAutomatic ClusteringSearch Optimization ServicePerformance tuning - Question #243Account Access and Security
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
External StagesPrivilegesUnstructured Data AccessAccess Control - Question #244Performance Management
Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
Query performanceSearch optimizationClusteringData access optimization - Question #245Data Loading and Unloading
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
Pre-signed URLsSnowflake StagesData UnloadingExternal Data Access - Question #246Performance Management
At what levels can a resource monitor be configured? (Select TWO).
Resource MonitorAccount LevelVirtual WarehouseCost Management - Question #247Data Protection and Data Sharing
How do Snowflake data providers share data that resides in different databases?
Data SharingSecure ViewsCross-Database Sharing - Question #248Performance Management
What can a Snowflake user do with the information included in the details section of a Query Profile?
Query ProfileQuery PerformancePerformance MonitoringExecution Duration - Question #249Account Access and Security
How many network policies can be assigned to an account or specific user at a time?
Network PolicyAccount SecurityUser SecurityAccess Control - Question #250Data Transformations
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
User-Defined Functions (UDFs)Tabular UDFs (UDTFs)SQL SyntaxCREATE FUNCTION