COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 7 of 14.
- Question #301Data Transformations
Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
Semi-structured dataJSONVARIANT data typeSQL Functions - Question #302Snowflake Cloud Data Platform Features and Architecture
Which items are considered schema objects in Snowflake? (Select TWO).
Schema objectsSnowflake objectsDatabase objectsObject hierarchy - Question #303Snowflake Cloud Data Platform Features and Architecture
What are benefits of using Snowpark with Snowflake? (Select TWO).
SnowparkData ProcessingArchitecture BenefitsVirtual Warehouses - Question #304Snowflake Cloud Data Platform Features and Architecture
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
Virtual WarehouseBillingCompute CostsCost Management - Question #305Data Loading and Unloading
Which transformation is supported by a COPY INTO <table> command?
COPY INTOData LoadingInline TransformationsData Casting - Question #306Account Access and Security
Which task privilege does a Snowflake role need in order to suspend or resume a task?
Task managementPrivilegesAccess controlOPERATE privilege - Question #307Account Access and Security
Which role has the ability to create and manage users and roles?
Snowflake RolesUser ManagementRole ManagementAccess Control - Question #308Account Access and Security
Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
Network PolicyRoles and PrivilegesAccount AdministrationSecurity - Question #309Snowflake Cloud Data Platform Features and Architecture
A permanent table and temporary table have the same name, TBL1, in a schema. What will happen if a user executes select * from TBL1 ;?
Temporary TablesTable TypesName ResolutionSchema Objects - Question #310Data Transformations
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
FLATTEN functionSemi-structured dataJSON traversalData transformation - Question #311Account Access and Security
What will prevent unauthorized access to a Snowflake account from an unknown source?
Network PolicyAccount SecurityAccess ControlIP Restriction - Question #312Performance Management
What is the purpose of a Query Profile?
Query ProfileQuery PerformancePerformance MonitoringQuery Optimization - Question #313Account Access and Security
When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?
Scoped URLUnstructured Data AccessData StagingTemporary Access - Question #314Storage and Data Protection
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Snowflake EditionsPHI ComplianceData SecurityBusiness Critical Edition - Question #315Snowflake Cloud Data Platform Features and Architecture
What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
Micro-partitionsData StorageQuery OptimizationMetadata - Question #316Performance Management
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).
Query ProfilePerformance TuningMemory SpillingIntermediate Results - Question #317Data Loading and Unloading
How can a Snowflake user validate data that is unloaded using the COPY INTO <location> command?
Data UnloadingCOPY INTO commandValidation ModeExternal Stages - Question #318Storage and Data Protection
At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
MIN_DATA_RETENTION_TIME_IN_DAYSAccount ParametersData RetentionTime Travel - Question #319Data Protection and Data Sharing
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Data Exchange administrationAccount administrator rolesData sharing managementListing approval process - Question #320Performance Management
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
Query PruningPerformance TuningMicro-partitionsQuery Statistics - Question #321Data Loading and Unloading
What is a directory table in Snowflake?
Directory TableStagesFile MetadataUnstructured Data - Question #322Data Loading and Unloading
Which Snowflake command can be used to unload the result of a query to a single file?
Data UnloadingCOPY INTO commandInternal StagesSingle File Output - Question #323Account Access and Security
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
Managed Access SchemaOwnership PrivilegeAccess ControlSchema Owner - Question #324Account Access and Security
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
MFAClient CachingAuthentication TokenSecurity Parameters - Question #325Storage and Data Protection
What factors impact storage costs in Snowflake? (Select TWO).
Storage CostsPricing FactorsCloud RegionAccount Edition - Question #326Account Access and Security
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
Snowflake RolesAccess ControlSECURITYADMIN RoleGrant Management - Question #327Data Governance
Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
Snowflake rolesACCOUNT_USAGEData GovernanceSecurity roles - Question #328Snowflake Cloud Data Platform Features and Architecture
Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
Snowflake Data TypesSemi-structured DataNested DataHierarchical Data - Question #329Storage and Data Protection
How can a dropped internal stage be restored?
Internal stagesObject managementDropped objectsUNDROP command limitations - Question #330Account Access and Security
Who can grant object privileges in a regular schema?
Access ControlObject OwnershipPrivileges - Question #331Data Loading and Unloading
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Data UnloadingCOPY INTO commandSnowflake StagesSQL - Question #332Storage and Data Protection
Which metadata table will store the storage utilization information even for dropped tables?
Storage UtilizationAccount UsageMetadata TablesDropped Tables - Question #333Data Governance
What does a masking policy consist of in Snowflake?
Masking PolicyData MaskingData GovernanceSecurity - Question #334Data Protection and Data Sharing
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
SnowflakeContinuous Data ProtectionTime TravelHistorical Data - Question #335Performance Management
A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data. How can this be achie...
JSON ProcessingSemi-structured DataVariant Data TypeQuery Optimization - Question #336Data Loading and Unloading
For which use cases is running a virtual warehouse required? (Select TWO).
Virtual WarehouseData LoadingData UnloadingCompute Resources - Question #337Snowflake Cloud Data Platform Features and Architecture
What does SnowCD help Snowflake users to do?
SnowCDNetwork ConnectivityTroubleshootingConnection Issues - Question #338Account Access and Security
A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).
User ManagementPrivilegesAccess ControlSecurity - Question #339Data Loading and Unloading
How is unstructured data retrieved from data storage?
Unstructured DataData RetrievalSnowflake StagesFile Access URLs - Question #340Data Governance
Which Snowflake view is used to support compliance auditing?
ACCESS_HISTORY viewCompliance auditingData access loggingData governance - Question #341Data Loading and Unloading
What is the purpose of the STRIP NULL_VALUES file format option when loading semi- structured data files into Snowflake?
Data LoadingSemi-structured DataFile Format OptionsNULL Handling - Question #342Snowflake Cloud Data Platform Features and Architecture
Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
Data TypesSemi-structured DataVARIANTARRAY - Question #343Account Access and Security
A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?
Pre-signed URLsStagesExternal AccessData Access - Question #344Performance Management
What does a Notify & Suspend action for a resource monitor do?
Resource MonitorsNotificationsWarehouse ManagementSuspension Actions - Question #345Performance Management
What type of query will benefit from the query acceleration service?
Query Acceleration ServicePerformance OptimizationQuery PerformanceLarge Scans - Question #346Data Protection and Data Sharing
What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
Data ExchangeSecure Data CollaborationData HubPrivate Sharing - Question #347Data Transformations
What is a characteristic of materialized views in Snowflake?
Materialized ViewsData TransformationsQuery Optimization - Question #348Account Access and Security
Which command is used to start configuring Snowflake for Single Sign-On (SSO)?
SSOSecurity IntegrationAuthenticationFederated Identity - Question #349Data Protection and Data Sharing
What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?
Reader AccountsManaged AccountsDROP CommandData Deletion - Question #350Snowflake Cloud Data Platform Features and Architecture
Which operation can be performed on Snowflake external tables?
External TablesJOIN operationsRead-only tablesData querying