COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 11 of 14.
- Question #501Snowflake Cloud Data Platform Features and Architecture
Which user preferences can be set for a user profile in Snowsight? (Select TWO).
SnowsightUser PreferencesDefault DatabaseDefault Schema - Question #502Storage and Data Protection
Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions). and has no Fail-safe period?
Snowflake table typesTransient tablesData persistenceFail-safe - Question #503Data Loading and Unloading
Which semi-structured file format is a compressed, efficient, columnar data representation?
Semi-structured dataFile formatsColumnar storageData loading - Question #504Performance Management
How does the search optimization service help Snowflake users improve query performance?
Search Optimization ServiceQuery PerformanceSnowflake ArchitectureData Structures - Question #505Account Access and Security
How does Snowflake define i1s approach to Discretionary Access Control (DAC)?
Discretionary Access ControlRole-Based Access ControlAccess ManagementRoles and Privileges - Question #506Snowflake Cloud Data Platform Features and Architecture
How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?
Virtual WarehousesCredit ConsumptionResource ManagementCost Management - Question #507Data Loading and Unloading
Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?
Snowflake stagesFile managementData loading cleanupREMOVE command - Question #508Storage and Data Protection
Which Snowflake table supports unstructured data?
Unstructured DataPermanent TableTable TypesData Storage - Question #509Snowflake Cloud Data Platform Features and Architecture
If a virtual warehouse is suspended, what happens to the warehouse cache?
Virtual WarehousesWarehouse CacheSuspensionCompute Management - Question #510Account Access and Security
Who can create network policies within Snowflake? (Select TWO).
Network PoliciesRoles and PrivilegesSecurityAccess Control - Question #511Account Access and Security
What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?
Account RolesAccount ParametersDatabase Replication - Question #512Data Transformations
A stream can be created on which Snowflake objects to record data manipulation language(DML) changes? (Select TWO).
StreamsDMLTablesChange Data Capture (CDC) - Question #513Data Protection and Data Sharing
What can a user win a reader account do in Snowflake?
Reader AccountsData SharingQuerying Shared Data - Question #514Snowflake Cloud Data Platform Features and Architecture
Which typos of charts does Snowsight support? (Select TWO).
SnowsightData VisualizationCharts - Question #515Performance Management
Snowflake users can create a resource monitor at which levels? (Select TWO).
Resource monitorVirtual warehouseCredit managementAccount level - Question #516Data Transformations
Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?
Snowflake StreamsChange Data CaptureCDC - Question #517Account Access and Security
Which roles can make grant decisions to objects within a managed access schema? (Select TWO)
Snowflake RolesManaged Access SchemaGrant ManagementSecurity Privileges - Question #518Snowflake Cloud Data Platform Features and Architecture
Which statement describes Snowflake tables?
Snowflake tablesLogical data modelPhysical data storageArchitecture - Question #519Snowflake Cloud Data Platform Features and Architecture
What are the main differences between the account usage views and the information schema views? (Select TWO).
Account UsageInformation SchemaMetadata ViewsData Retention - Question #520Data Governance
In which hierarchy is tag inheritance possible?
Tag InheritanceData GovernanceObject HierarchyMetadata Management - Question #521Snowflake Cloud Data Platform Features and Architecture
Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).
Semi-structured dataData typesVARIANTARRAY - Question #522Data Protection and Data Sharing
Which Snowflake database object can be shared with other accounts?
Snowflake Data SharingDatabase ObjectsSecure UDFs - Question #523Snowflake Cloud Data Platform Features and Architecture
What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?
Virtual WarehouseCompute ResourcesFailure HandlingAutomatic Recovery - Question #524Data Transformations
A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflak...
JSON queryingVARIANT data typeSemi-structured dataArray indexing - Question #525Account Access and Security
Which key access control concept does Snowflake descibe as a defined level of access to an object?
Access ControlPrivilegeSecurity ConceptsSnowflake Terminology - Question #526Account Access and Security
Snowflake's access control framework combines which models for securing data? (Select TWO).
Access ControlRBACDACSecurity Models - Question #527Account Access and Security
What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?
ConnectivityJDBCODBCDrivers - Question #528Performance Management
How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''
Virtual WarehousesMulti-cluster WarehousesWarehouse ScalingPerformance Configuration - Question #529Data Governance
Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?
Column LineageACCESS_HISTORY ViewData GovernanceSystem Views - Question #530Data Protection and Data Sharing
When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).
Data SharingProvider PrivilegesUSAGE GrantAccess Control - Question #531Account Access and Security
Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?
ACCOUNT_USAGELOGIN_HISTORYSecurity AuditingUser Connections - Question #532Data Protection and Data Sharing
Given the statement template below, which database objects can be added to a share?(Select TWO). GRANT <privilege> ON <object> <object_name> To SHARE <share_name>;
Data SharingGRANT commandShareable ObjectsSnowflake Objects - Question #533Account Access and Security
How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
SCIMIdentity ManagementAPI MonitoringAccount Auditing - Question #534Data Protection and Data Sharing
What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?
Data SharingGrant PrivilegesObject SharingConsumer Access - Question #535Account Access and Security
Which Snowflake privilege is required on a pipe object to pause or resume pipes?
Pipe objectsSnowflake privilegesAccess controlData loading - Question #536Account Access and Security
What information is stored in the ACCESS_HlSTORY view?
PrivilegesGrantsAccount UsageAccess Control - Question #537Data Protection and Data Sharing
In the Data Exchange, who can get or request data from the listings? (Select TWO).
Snowflake Data ExchangeData SharingRoles and PrivilegesAccess Control - Question #538Account Access and Security
Authorization to execute CREATE <object> statements comes only from which role?
Role-based access control (RBAC)Primary rolePermissionsCREATE statements - Question #539Data Loading and Unloading
Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?
Data LoadingPUT commandInternal StagesFile Upload - Question #540Storage and Data Protection
Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?
Presigned URLStage accessFile functionsExternal data access - Question #541Data Governance
Which governance feature is supported by all Snowflake editions?
Data GovernanceSnowflake EditionsAccount Usage ViewsMetadata Management - Question #542Data Protection and Data Sharing
What causes objects in a data share to become unavailable to a consumer account?
Data SharingProducer-Consumer ModelGrantsObject Availability - Question #543Snowflake Cloud Data Platform Features and Architecture
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
SnowsightDashboardsVisualizationsChart types - Question #544Storage and Data Protection
At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?
Data RetentionTime TravelAccount ParametersMIN_DATA_RETENTION_TIME_IN_DAYS - Question #545Performance Management
What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?
Clustering KeyPerformance OptimizationTable Size Recommendations - Question #546Data Transformations
Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
String FunctionsSimilarity FunctionsJaro-WinklerData Processing - Question #547Data Transformations
Which types of subqueries does Snowflake support? (Select TWO).
SQLSubqueriesQuerying DataData Transformation - Question #548Data Governance
Which Snowflake data governance feature can support auditing when a user query reads column data?
Access HistoryAuditingData GovernanceColumn-level access - Question #549Performance Management
A clustering key was defined on a table, but It is no longer needed. How can the key be removed?
Clustering KeyTable ManagementSQL DDL - Question #550Account Access and Security
What are characteristics of Snowflake network policies? (Select TWO).
Network PoliciesAccess ControlSecurityIP Whitelisting