COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 13 of 14.
- Question #601Snowflake Cloud Data Platform Features and Architecture
Which function determines the kind of value stored in a VARIANT column?
VARIANT data typeTYPEOF functionSQL functionsSemi-structured data - Question #602Account Access and Security
Which access control entity in Snowflake can be created as part of a hierarchy within an account?
Access ControlRolesRole HierarchyRBAC - Question #603Account Access and Security
When an object is created in Snowflake. who owns the object?
Object OwnershipRole-based Access Control (RBAC)Object CreationSecurity Model - Question #604Data Governance
What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY view?
Snowflake EditionsACCESS_HISTORY viewAccount UsageData Auditing - Question #605Account Access and Security
Which role is responsible for managing the billing and credit data within Snowflake?
Snowflake rolesORGADMIN roleBilling managementOrganization administration - Question #606Account Access and Security
Which role must be used to create resource monitors?
Snowflake RolesResource MonitorsACCOUNTADMINPermissions - Question #607Data Loading and Unloading
Which command is used to remove files from either external cloud storage or an internal staged
REMOVE commandStaged filesFile managementData unloading - Question #608Snowflake Cloud Data Platform Features and Architecture
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
Search Optimization ServicePoint LookupsPerformance TuningData Structures - Question #609Data Governance
What is a characteristic of a tag associated with a masking policy?
Masking PolicyTagsData GovernanceColumn-Level Security - Question #610Data Loading and Unloading
Which function unloads data from a relational table to JSON?
Data UnloadingJSON FormatSnowflake FunctionsData Type Conversion - Question #611Data Loading and Unloading
While unloading data into a stage, how can the user ensure that the output will be a single file?
Data UnloadingCOPY INTO (location)StageFile Output Options - Question #612Performance Management
Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)
Search Optimization ServicePerformance ImprovementQuery OptimizationPoint Lookups - Question #613Performance Concepts
Which Query Profile operator is considered a DML operator?
Query ProfileDML OperatorsMERGE INTOQuery Execution - Question #614Account Access and Security
Who can create and manage reader accounts? (Select TWO).
Reader AccountsSnowflake RolesAccount ManagementSystem Privileges - Question #615Data Governance
Masking policies are created at what level in Snowflake?
Masking PoliciesData GovernanceColumn-level Security - Question #616Data Transformations
What would cause different results to be returned when running the same query twice?
Snowflake SAMPLE clauseNon-deterministic samplingSEED parameterQuery result consistency - Question #617Account Access and Security
Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?
Network PoliciesUser ParametersRoles and PrivilegesAccount Security - Question #618Data Loading and Unloading
Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?
Directory TablesStagesData Ingestion - Question #619Data Transformations
What are type predicates used for?
VARIANT data typeType predicatesSQL functions - Question #620Data Transformations
In Snowflake, what allows users to perform recursive queries?
Recursive queriesCONNECT BYSQL - Question #621Data Transformations
Which table function is used to perform additional processing on the results of a previously-run query?
RESULT_SCANTable FunctionsQuery Results - Question #622Performance Management
Which actions can be performed using a resource monitor in Snowflake? (Select TWO).
Resource MonitorsCost ManagementVirtual WarehousesCredit Usage - Question #623Snowflake Cloud Data Platform Features and Architecture
Which Snowflake native tool can be used to diagnose and troubleshoot network connections?
Network ConnectivityTroubleshootingSnowflake Client ToolsSnowSQL - Question #624Data Loading and Unloading
Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?
JSON dataVARIANT data typeSemi-structured dataData types - Question #625Performance Management
Which statistics on a Query Profile reflect the efficiency of the query pruning? (Select TWO).
Query ProfileQuery PruningPerformance OptimizationMicro-partitions - Question #626Data Loading and Unloading
How can a 5 GB table be downloaded into a single file MOST efficiently?
Data UnloadingCOPY INTOSINGLE parameterFile Output - Question #627Account Access and Security
Which security models are used in Snowflake to manage access control? (Select TWO).
Access ControlRBACDACSecurity Models - Question #628Data Governance
Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?
Object TaggingData GovernanceMetadata ManagementAccess Control - Question #629Data Protection and Data Sharing
What is the MINIMUM Snowftake edition that supports database replication?
Snowflake EditionsDatabase ReplicationCross-Region ReplicationBusiness Continuity - Question #630Performance Management
Which type of workload traditionally benefits from the use of the query acceleration service?
Query Acceleration ServicePerformance OptimizationAd-hoc Queries - Question #631Data Loading and Unloading
Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows Into a file in JSON format? (S...
Data UnloadingJSON FormatVARIANT Data TypeOBJECT_CONSTRUCT Function - Question #632Data Loading and Unloading
What Snowflake recommendation is designed to ensure that staged data is only loaded once"?
Data LoadingIdempotencyStaged FilesBest Practices - Question #633Data Governance
Which privilege grants the ability to set a column-level security masking policy on a table or view column?
Column-level securityMasking policyPrivilegesData governance - Question #634Performance Management
How can the Query Profile be used to troubleshoot a problematic query?
Query ProfilePerformance TroubleshootingVirtual Warehouse SizingMemory Spilling - Question #635Snowflake Cloud Data Platform Features and Architecture
Which data type can be used for floating-point numbers without losing precision?
Data typesFloating-pointPrecisionDOUBLE data type - Question #636Data Protection and Data Sharing
What does Snowflake recommend as a best practice for using secure views?
Secure ViewsSecurity Best PracticesData ProtectionIdentifier Protection - Question #637Storage and Data Protection
Which objects will incur storage costs associated with Fail-safe?
Fail-safeStorage CostsExternal StagesData Retention - Question #638Data Protection and Data Sharing
Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?
Data SharingDirect ShareConsumer AccountsData Provider - Question #639Snowflake Cloud Data Platform Features and Architecture
Which type of charts are supported by Snowsight? {Select TWO)
SnowsightData VisualizationCharts - Question #640Performance Management
How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?
Virtual WarehousesSnowpark-optimized WarehousesALTER WAREHOUSEWarehouse Configuration - Question #641Account Access and Security
What kind of authentication do Snowpipe REST endpoints use?
SnowpipeREST APIAuthenticationKey-based authentication - Question #642Data Transformations
What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).
Snowflake StreamsMETADATA$ACTIONData Change TrackingDML Operations - Question #643Data Loading and Unloading
What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?
Data LoadingCOPY INTOFile Format OptionsPrecedence - Question #644Snowflake Cloud Data Platform Features and Architecture
Which service or tool is a Command Line Interface (CLI) client used for connecting to Snowflake to execute SQL queries?
SnowSQLCLI ClientSQL ExecutionConnectivity - Question #645Data Transformations
What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)
JavaScriptCustom LogicStored ProceduresUDFs - Question #646Data Transformations
Which Snowflake object can be used to record DML changes made to a table?
StreamsChange Data CaptureDML Tracking - Question #647Account Access and Security
Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?
Key pair authenticationUser authenticationALTER USER commandRSA_PUBLIC_KEY - Question #648Data Protection and Data Sharing
Secured Data Sharing is allowed for which Snowflake database objects? (Select TWO).
Data SharingSecure ViewsTablesSnowflake Objects - Question #649Performance Management
What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).
Virtual WarehouseWarehouse ConfigurationResource MonitoringAuto-suspend - Question #650Data Loading and Unloading
What is the purpose of the use of the VALIDATE command?
VALIDATE commandCOPY INTO errorsData loadingError handling