COF-C02 Practice Questions
691 real COF-C02 exam questions with expert-verified answers and explanations. Page 10 of 14.
- Question #451Data Protection and Data Sharing
What are characteristics of reader accounts in Snowflake? (Select TWO).
Reader AccountsData SharingData ConsumersAccount Types - Question #452Account Access and Security
A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY. What should they do?
User ManagementSnowflake RolesNetwork PoliciesSecurity Administration - Question #453Account Access and Security
When using the ALLOW_CLI T_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
MFAAuthenticationSecurityToken caching - Question #454Account Access and Security
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
Snowflake editionsVirtual Private SnowflakeSecurity levelsData isolation - Question #455Account Access and Security
A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
Role-based access controlCustom rolesPrivilege managementSnowflake best practices - Question #456Data Transformations
Which function is used to convert rows in a relational table to a single VARIANT column?
OBJECT_CONSTRUCTVARIANT Data TypeSemi-structured DataData Transformation - Question #457Data Loading and Unloading
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
Data UnloadingSemi-structured DataFile FormatsJSONParquet - Question #458Snowflake Cloud Data Platform Features and Architecture
Which Snowflake layer is associated with virtual warehouses?
Snowflake architectureVirtual warehousesQuery processing layerCloud data platform - Question #459Data Protection and Data Sharing
What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
EncryptionCustomer Managed Keys (CMK)SecurityTri-secret Secure - Question #460Data Loading and Unloading
What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?
CSVFile FormatsField EnclosureData Unloading - Question #461Data Transformations
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
Window functionsSQL syntaxOVER clauseData transformation - Question #462Snowflake Cloud Data Platform Features and Architecture
How does Snowflake describe its unique architecture?
Snowflake ArchitectureShared Data ArchitectureMassively Parallel Processing (MPP)Central Data Repository - Question #463Performance Management
What information does the Query Profile provide?
Query ProfileQuery OptimizationExecution PlanPerformance Monitoring - Question #464Storage and Data Protection
By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
Time TravelData RetentionDefault SettingsStorage - Question #465Data Protection and Data Sharing
Which role has the ability to create a share from a shared database by default?
Snowflake RolesDefault PrivilegesData SharingACCOUNTADMIN - Question #466Performance Concepts
Why would a Snowflake user decide to use a materialized view instead of a regular view?
Materialized ViewsViewsPerformance OptimizationData Stability - Question #467Data Loading and Unloading
Which command can be used to list all the file formats for which a user has access privileges?
File FormatsSHOW CommandsObject ManagementMetadata - Question #468Performance Management
Which common query problems are identified by the Query Profile? (Select TWO.)
Query ProfileQuery OptimizationPerformance TuningTroubleshooting - Question #469Account Access and Security
By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
ACCOUNTADMIN roleSystem functionsGlobal account parametersRole-based access control - Question #470Snowflake Cloud Data Platform Features and Architecture
If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?
Virtual Warehouse BillingCompute UsageCredit ConsumptionBilling Model - Question #471Storage and Data Protection
Which Snowflow object does not consume and storage costs?
Storage CostsTemporary TablesData RetentionSnowflake Objects - Question #472Data Transformations
What type of function returns one value for each Invocation?
SQL FunctionsScalar FunctionsData ManipulationFunction Types - Question #473Storage and Data Protection
For Directory tables, what stage allows for automatic refreshing of metadata?
Directory TablesExternal StagesMetadata ManagementAutomatic Refresh - Question #474Account Access and Security
Which command removes a role from another role or a user in Snowflak?
Role managementAccess controlREVOKE commandSecurity permissions - Question #475Data Loading and Unloading
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
VALIDATE functionData Loading ValidationUUIDJOB_ID - Question #476Data Transformations
Which function should be used to insert JSON format string data inot a VARIANT field?
PARSE_JSONVARIANT data typeJSON parsingSemi-structured data - Question #477Account Access and Security
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
File functionsStage filesURL generationAuthentication - Question #478Performance Management
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
Materialized ViewsPerformance OptimizationViewsPre-computation - Question #479Snowflake Cloud Data Platform Features and Architecture
What are characteristic of Snowsight worksheet? (Select TWO.)
SnowsightWorksheetsCollaborationUser Interface - Question #480Snowflake Cloud Data Platform Features and Architecture
A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names. How will those object names be resolved during execution?
UDFsObject ResolutionSchema Context - Question #481Performance Management
What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
Materialized ViewQuery OptimizationPerformance TuningAggregation - Question #482Storage and Data Protection
How can a user get the MOST detailed information about individual table storage details in Snowflake?
Table StorageAccount Usage ViewsMetadataStorage Monitoring - Question #483Account Access and Security
What happens when a network policy includes values that appear in both the allowed and blocked IP address list?
Network PoliciesIP Access ControlAccount SecuritySecurity Configuration - Question #484Account Access and Security
What is the MINIMUM permission needed to access a file URL from an external stage?
PermissionsStagesExternal StagesAccess Control - Question #485Account Access and Security
Which function will provide the proxy information needed to protect Snowsight?
SnowsightPrivateLinkNetwork SecuritySystem Functions - Question #486Data Loading and Unloading
Which command should be used to unload all the rows from a table into one or more files in a named stage?
Data UnloadingCOPY INTO commandNamed StagesExporting Data - Question #487Data Protection and Data Sharing
What type of account can be used to share data with a consumer who does have a Snowflake account?
Data SharingReader AccountsExternal ConsumersConsumer Accounts - Question #488Account Access and Security
Which privilege is needed for a SnowFlake user to see the definition of a secure view?
Secure ViewsPrivilegesAccess ControlOwnership - Question #489Snowflake Cloud Data Platform Features and Architecture
Which function should be used to find the query ID of the second query executed in a current session?
Snowflake FunctionsQuery ManagementSession ContextQuery ID Retrieval - Question #490Data Loading and Unloading
Which command will unload data from a table into an external stage?
Data UnloadingCOPY INTOExternal StageSQL Commands - Question #491Account Access and Security
Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?
Snowflake rolesACCOUNTADMIN permissionsAccount administrationSystem-defined roles - Question #492Storage and Data Protection
What do temporary and transient tables have m common in Snowflake? (Select TWO).
Temporary TablesTransient TablesData RetentionFail-safe - Question #493Storage and Data Protection
What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?
Fail-safeData retentionData recoveryHistorical data - Question #494Snowflake Cloud Data Platform Features and Architecture
Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).
Snowflake architectureCloud Services layerAuthorizationQuery optimization - Question #495Account Access and Security
Which statements reflect valid commands when using secondary roles? (Select TWO).
Secondary RolesAccess ControlRolesSQL Commands - Question #496Account Access and Security
What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?
ACCOUNTADMIN roleMFASecurity best practicesUser access - Question #497Account Access and Security
A user wants to access stored in a stage without authenticating into Snowflake. Which type of URL should be used?
Pre-signed URLsExternal stagesUnauthenticated accessData access - Question #498Storage and Data Protection
Which Snowflake objects can be restored using Time Travel? (Select VNO).
Time TravelData RestorationUNDROPDatabaseSchema - Question #499Data Transformations
Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?
Task GraphsMonitoringSnowflake Tasks - Question #500Data Loading and Unloading
A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?
Data LoadingSnowSQLStatement TimeoutTransaction Management