PDF Only
![Dumpspool PDF book](https://www.dumpspool.com/assets/images/pdf.webp)
$35.00 Free Updates Upto 90 Days
- COF-C02 Dumps PDF
- 671 Questions
- Updated On September 04, 2024
PDF + Test Engine
![Dumpspool PDF and Test Engine book](https://www.dumpspool.com/assets/images/pdf_engine.webp)
$60.00 Free Updates Upto 90 Days
- COF-C02 Question Answers
- 671 Questions
- Updated On September 04, 2024
Test Engine
![Dumpspool Test Engine book](https://www.dumpspool.com/assets/images/engine.webp)
$50.00 Free Updates Upto 90 Days
- COF-C02 Practice Questions
- 671 Questions
- Updated On September 04, 2024
How to pass Snowflake COF-C02 exam with the help of dumps?
DumpsPool provides you the finest quality resources you’ve been looking for to no avail. So, it's due time you stop stressing and get ready for the exam. Our Online Test Engine provides you with the guidance you need to pass the certification exam. We guarantee top-grade results because we know we’ve covered each topic in a precise and understandable manner. Our expert team prepared the latest Snowflake COF-C02 Dumps to satisfy your need for training. Plus, they are in two different formats: Dumps PDF and Online Test Engine.
How Do I Know Snowflake COF-C02 Dumps are Worth it?
Did we mention our latest COF-C02 Dumps PDF is also available as Online Test Engine? And that’s just the point where things start to take root. Of all the amazing features you are offered here at DumpsPool, the money-back guarantee has to be the best one. Now that you know you don’t have to worry about the payments. Let us explore all other reasons you would want to buy from us. Other than affordable Real Exam Dumps, you are offered three-month free updates.
You can easily scroll through our large catalog of certification exams. And, pick any exam to start your training. That’s right, DumpsPool isn’t limited to just Snowflake Exams. We trust our customers need the support of an authentic and reliable resource. So, we made sure there is never any outdated content in our study resources. Our expert team makes sure everything is up to the mark by keeping an eye on every single update. Our main concern and focus are that you understand the real exam format. So, you can pass the exam in an easier way!
IT Students Are Using our SnowPro Core Certification Exam Dumps Worldwide!
It is a well-established fact that certification exams can’t be conquered without some help from experts. The point of using SnowPro Core Certification Exam Practice Question Answers is exactly that. You are constantly surrounded by IT experts who’ve been through you are about to and know better. The 24/7 customer service of DumpsPool ensures you are in touch with these experts whenever needed. Our 100% success rate and validity around the world, make us the most trusted resource candidates use. The updated Dumps PDF helps you pass the exam on the first attempt. And, with the money-back guarantee, you feel safe buying from us. You can claim your return on not passing the exam.
How to Get COF-C02 Real Exam Dumps?
Getting access to the real exam dumps is as easy as pressing a button, literally! There are various resources available online, but the majority of them sell scams or copied content. So, if you are going to attempt the COF-C02 exam, you need to be sure you are buying the right kind of Dumps. All the Dumps PDF available on DumpsPool are as unique and the latest as they can be. Plus, our Practice Question Answers are tested and approved by professionals. Making it the top authentic resource available on the internet. Our expert has made sure the Online Test Engine is free from outdated & fake content, repeated questions, and false plus indefinite information, etc. We make every penny count, and you leave our platform fully satisfied!
Snowflake COF-C02 Exam Overview:
Aspect | Details |
---|---|
Exam Name | Snowflake Certified Operator - COF-C02 |
Exam Cost | $250 USD |
Total Time | 120 minutes |
Available Languages | English |
Passing Marks | 70% |
Exam Format | Multiple Choice Questions (MCQs) |
Exam Delivery Platform | Virtual Proctoring (Online) |
Retake Policy | You can retake the exam after 14 days |
Certification Validity | 2 years |
Prerequisites | None |
SnowPro Core Certification Exam Topics Breakdown
Domain | Percentage | Description |
---|---|---|
Snowflake Architecture | 30% | Understanding Snowflake architecture and components |
Data Loading and Unloading | 20% | Techniques for loading and unloading data |
Querying Data | 25% | Writing and optimizing queries in Snowflake |
Security and Governance | 15% | Implementing security measures and governance |
Performance Tuning | 10% | Tuning Snowflake for optimal performance |
Frequently Asked Questions
Question # 1
When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
A. 1 hour
B. 2 hours
C. 4 hours
D. 8 hours
Question # 2
If file format options are specified in multiple locations, the load operation selects whichoption FIRST to apply in order of precedence?
A. Table definition
B. Stage definition
C. Session level
D. COPY INTO TABLE statement
Question # 3
How does Snowflake reorganize data when it is loaded? (Select TWO).
A. Binary format
B. Columnar format
C. Compressed format
D. Raw format
E. Zipped format
Question # 4
Which Snowflake database object can be shared with other accounts?
A. Tasks
B. Pipes
C. Secure User-Defined Functions (UDFs)
D. Stored Procedures
Question # 5
Which Snowflake database object can be shared with other accounts?
A. Tasks
B. Pipes
C. Secure User-Defined Functions (UDFs)
D. Stored Procedures
Question # 6
What is the MINIMUM role required to set the value for the parameterENABLE_ACCOUNT_DATABASE_REPLICATION?
A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSADMIN
D. ORGADMIN
Question # 7
Which system_defined Snowflake role has permission to rename an account and specifywhether the original URL can be used to access the renamed account?
A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSADMIN
D. ORGADMIN
Question # 8
When using SnowSQL, which configuration options are required when unloading data froma SQL query run on a local machine? {Select TWO).
A. echo
B. quiet
C. output_file
D. output_format
E. force_put_overwrite
Question # 9
What value provides information about disk usage for operations where intermediateresults do not fit in memory in a Query Profile?
A. IO
B. Network
C. Pruning
D. Spilling
Question # 10
Which function will provide the proxy information needed to protect Snowsight?
A. SYSTEMADMIN_TAG
B. SYSTEM$GET_PRIVATELINK
C. SYSTEMSALLONTLIST
D. SYSTEMAUTHORIZE
Question # 11
How do secure views compare to non-secure views in Snowflake?
A. Secure views execute slowly compared to non-secure views.
B. Non-secure views are preferred over secure views when sharing data.
C. Secure views are similar to materialized views in that they are the most performant.
D. There are no performance differences between secure and non-secure views.
Question # 12
Which Snowflake layer is associated with virtual warehouses?
A. Cloud services
B. Query processing
C. Elastic memory
D. Database storage
Question # 13
What are characteristics of reader accounts in Snowflake? (Select TWO).
A. Reader account users cannot add new data to the account.
B. Reader account users can share data to other reader accounts.
C. A single reader account can consume data from multiple provider accounts.
D. Data consumers are responsible for reader account setup and data usage costs.
E. Reader accounts enable data consumers to access and query data shared by theprovider.
Question # 14
How does the search optimization service help Snowflake users improve queryperformance?
A. It scans the micro-partitions based on the joins used in the queries and scans only joincolumns.
B. II maintains a persistent data structure that keeps track of the values of the table'scolumns m each of its micro-partitions.
C. It scans the local disk cache to avoid scans on the tables used in the Query.
D. It keeps track of running queries and their results and saves those extra scans on thetable.
Question # 15
Which DDL/DML operation is allowed on an inbound data share?
A. ALTER TA3LE
B. INSERT INTO
C. MERGE
D. SELECT
Question # 16
A view is defined on a permanent table. A temporary table with the same name is createdin the same schema as the referenced table. What will the query from the view return?
A. The data from the permanent table.
B. The data from the temporary table.
C. An error stating that the view could not be compiled.
D. An error stating that the referenced object could not be uniquely identified.
Question # 17
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
A. GROUP BY
B. LIMIT
C. ORDER BY
D. PARTITION BY
E. UNION ALL
Question # 18
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Whichstatements will provide this access?
A. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLEMYROLE;
B. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USERUSER1;
C. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;
D. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
Question # 19
What compute resource is used when loading data using Snowpipe?
A. Snowpipe uses virtual warehouses provided by the user.
B. Snowpipe uses an Apache Kafka server for its compute resources.
C. Snowpipe uses compute resources provided by Snowflake.
D. Snowpipe uses cloud platform compute resources provided by the user.
Question # 20
What activities can a user with the ORGADMIN role perform? (Select TWO).
A. Create an account for an organization.
B. Edit the account data for an organization.
C. Delete the account data for an organization.
D. View usage information for all accounts in an organization.
E. Select all the data in tables for all accounts in an organization.
Question # 21
Which Snowflake feature can be used to find sensitive data in a table or column?
A. Masking policies
B. Data classification
C. Row level policies
D. External functions
Question # 22
Which table function should be used to view details on a Directed Acyclic Graphic (DAG)run that is presently scheduled or is executing?
A. TASK_HISTORY
B. TASK_DEPENDENTS
C. CURRENT_TASK_GRAPHS
D. COMPLETE_TASK_GRAPHS
Question # 23
Snowflake's hierarchical key mode includes which keys? (Select TWO).
A. Account master keys
B. Database master keys
C. File keys
D. Secure view keys
E. Schema master keys
Question # 24
What role is required to use Partner Connect?
A. ACCOUNTADMIN
B. ORGADMIN
C. SECURITYADMIN
D. SYSADMIN
Question # 25
How does a Snowflake user extract the URL of a directory table on an external stage forfurther transformation?
A. Use the SHOW STAGES command.
B. Use the DESCRIBE STAGE command.
C. Use the GET_ABSOLUTE_PATH function.
D. Use the GET_STAGE_LOCATION function.
Question # 26
Which role allows a SnowFlake user to view table-level storage utilization information fromthe TABLE_STORAGE_METRICS view by the default?
A. ACCOUNTADMIN
B. SECURYADMIN
C. SYSADMIN
D. USERADMIN
Question # 27
What action can a user take to address query concurrency issues?
A. Enable the query acceleration service.
B. Enable the search optimization service.
C. Add additional clusters to the virtual warehouse
D. Resize the virtual warehouse to a larger instance size.
Question # 28
What SnowFlake database object is derived from a query specification, stored for later use,and can speed up expensive aggregation on large data sets?
A. Temporary table
B. External table
C. Secure view
D. Materialized view
Question # 29
Why would a Snowflake user decide to use a materialized view instead of a regular view?
A. The base tables do not change frequently.
B. The results of the view change often.
C. The query is not resource intensive.
D. The query results are not used frequently.
Question # 30
A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualifiedobject names.How will those object names be resolved during execution?
A. Snowflake will resolve them according to the SEARCH_PATH parameter.
B. Snowflake will only check the schema the UDF belongs to.
C. Snowflake will first check the current schema, and then the schema the previous queryused
D. Snowflake will first check the current schema, and them the PUBLIC schema of thecurrent database.
Question # 31
What is a non-configurable feature that provides historical data that Snowflake may recoverduring a 7-day period?
A. Fail-safe
B. Time Travel
C. Cloning
D. Account replication
Question # 32
What are the main differences between the account usage views and the informationschema views? (Select TWO).
A. No active warehouse to needed to query account usage views but one is needed toquery information schema views.
B. Account usage views do not contain data about tables but information schema views do.
C. Account issue views contain dropped objects but information schema views do not.
D. Data retention for account usage views is 1 year but is 7 days to 6 months forinformation schema views, depending on the view.
E. Information schema views are read-only but account usage views are not.
Question # 33
What is one of the characteristics of data shares?
A. Data shares support full DML operations.
B. Data shares work by copying data to consumer accounts.
C. Data shares utilize secure views for sharing view objects.
D. Data shares are cloud agnostic and can cross regions by default.
Question # 34
A user wants to access stored in a stage without authenticating into Snowflake.Which type of URL should be used?
A. File URL
B. Staged URL
C. Scoped URL
D. Pre-signed URL
Question # 35
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition andhigher?
A. 0 days
B. 1 day
C. 7 days
D. 14 days
Question # 36
Which data formats are supported by Snowflake when unloading semi-structured data?(Select TWO).
A. Binary file in Avro
B. Binary file in Parquet
C. Comma-separated JSON
D. Newline Delimited JSON
E. Plain text file containing XML elements
Question # 37
What step can reduce data spilling in Snowflake?
A. Using a larger virtual warehouse
B. Increasing the virtual warehouse maximum timeout limit
C. Increasing the amount of remote storage for the virtual warehouse
D. Using a Common Table Expression (CTE) instead of a temporary table
Question # 38
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in thesame Snowflake account, wants to view the result set of the query executed by User1using the Snowsight query history.What will happen if User2 tries to access the query history?
A. If User2 has the sysadmin role they will be able to see the results.
B. If User2 has the securityadmin role they will be able to see the results.
C. If User2 has the ACCOUNTADMIN role they will be able to see the results.
D. User2 will be unable to view the result set of the query executed by User1.
Question # 39
When unloading data, which file format preserves the data values for floating-point numbercolumns?
A. Avro
B. CSV
C. JSON
D. Parquet
Question # 40
Which Snowflow object does not consume and storage costs?
A. Secure view
B. Materialized view
C. Temporary table
D. Transient table
Question # 41
A stream can be created on which Snowflake objects to record data manipulationlanguage(DML) changes? (Select TWO).
A. Database
B. Standard tables
C. Standard tables
D. Standard views
E. Schemas
F. Pipes
Question # 42
How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
A. A single executable statement can call only two stored procedures. In contrast, a singleSQL statement can call multiple UDFs.
B. A single executable statement can call only one stored procedure. In contrast, a singleSQL statement can call multiple UDFs.
C. A single executable statement can call multiple stored procedures. In contrast, multipleSQL statements can call the same UDFs.
D. Multiple executable statements can call more than one stored procedure. In contrast, asingle SQL statement can call multiple UDFs.
Question # 43
What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
A. The provisioning of new compute resources for the warehouse will begin immediately.
B. The warehouse will remain suspended but new resources will be added to the queryacceleration service.
C. The provisioning of additional compute resources will be in effect when the warehouse isnext resumed.
D. The warehouse will resume immediately and start to share the compute load with otherrunning virtual warehouses.
Question # 44
Which statements describe benefits of Snowflake's separation of compute andstorage?(Select TWO).
A. The separation allows independent scaling of computing resources.
B. The separation ensures consistent data encryption across all virtual data warehouses.
C. The separation supports automatic conversion of semi-structured data into structureddata for advanced data analysis.
D. Storage volume growth and compute usage growth can be tightly coupled.
E. Compote can be scaled up or down without the requirement to add more storage.
Question # 45
What type of account can be used to share data with a consumer who does have a Snowflake account?
A. Data provider
B. Data consumer
C. Reader
D. Organization
Question # 46
What can a user win a reader account do in Snowflake?
A. Load now data
B. Update existing data
C. Create a new snare
D. Query shared data
Question # 47
What is the MAXIMUM Time Travel retention period for a transient table?
A. O days
B. 1 day
C. 7 days
D. 90 days
Question # 48
The VALIDATE table function has which parameter as an input argument for a Snowflakeuser?
A. Last_QUERY_ID
B. CURRENT_STATEMENT
C. UUID_STRING
D. JOB_ID
Question # 49
What are characteristics of transient tables in Snowflake? (Select TWO).
A. Transient tables have a Fail-safe period of 7 days.
B. Transient tables can be cloned to permanent tables.
C. Transient tables persist until they are explicitly dropped.
D. Transient tables can be altered to make them permanent tables.
E. Transient tables have Time Travel retention periods of 0 or 1 day.
Question # 50
What information is found within the Statistic output in the Query Profile Overview?
A. Operator tree
B. Table pruning
C. Most expensive nodes
D. Nodes by execution time
Question # 51
Snowflake users can create a resource monitor at which levels? (Select TWO).
A. User level
B. Pipe level
C. Account level
D. Cloud services level
E. Virtual warehouse level
Question # 52
Which kind of Snowflake table stores file-level metadata for each file in a stage?
A. Directory
B. External
C. Temporary
D. Transient
Question # 53
What consideration should be made when loading data into Snowflake?
A. Create small data files and stage them in cloud storage frequently.
B. Create large data files to maximize the processing overhead for each file.
C. The number of load operations That run in parallel can exceed the number of data filesto be loaded.
D. The number of data files that are processed in parallel is determined by the virtualwarehouse.
Question # 54
Which data types can be used in a Snowflake table that holds semi-structured data?(Select TWO).
A. ARRAY
B. BINARY
C. TEXT
D. VARIANT
E. VARCHAK
Question # 55
How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''
A. Set the WAREHOUSES_SIZE to 6XL.
B. Set the STATEMENT_TIMEOUT_1M_SECOMES to 0.
C. Set the MAX_CONCURRENCY_LEVEL to a value of 12 or large.
D. Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.
Question # 56
What information does the Query Profile provide?
A. Graphical representation of the data model
B. Statistics for each component of the processing plan
C. Detailed Information about I he database schema
D. Real-time monitoring of the database operations
Question # 57
What is the MINIMUM permission needed to access a file URL from an external stage?
A. MODIFY
B. READ
C. SELECT
D. USAGE
Question # 58
Which pages are included in the Activity area of Snowsight? (Select TWO).
A. Contacts
B. Sharing settings
C. Copy History
D. Query History
E. Automatic Clustering History
Question # 59
What does Snowflake's search optimization service support?
A. External tables
B. Materialized views
C. Tables and views that are not protected by row access policies
D. Casts on table columns (except for fixed-point numbers cast to strings)
Question # 60
What happens when a network policy includes values that appear in both the allowed andblocked IP address list?
A. Those IP addresses are allowed access to the Snowflake account as Snowflake appliesthe allowed IP address list first.
B. Those IP addresses are denied access lei the Snowflake account as Snowflake appliesthe blocked IP address list first.
C. Snowflake issues an alert message and adds the duplicate IP address values lo both 'heallowed and blocked IP address lists.
D. Snowflake issues an error message and adds the duplicate IP address values to boththe allowed and blocked IP address list
Question # 61
How does Snowflake handle the bulk unloading of data into single or multiple files?
A. It assigns each unloaded data file a unique name.
B. It uses the put command to download the data by default.
C. It uses COPY INTO <location> for bulk unloading where the default option is SINGLE -TRUE.
D. It uses COPY INTO <location> to copy the data from a table into one or more files in anexternal stage only.
Question # 62
What should be used when creating a CSV file format where the columns are wrapped bysingle quotes or double quotes?
A. BINARY_FORMAT
B. ESCAPE_UNENCLOSED_FIELD
C. FIELD_OPTIONALLY_ENCLOSED_BY
D. SKIP BYTE ORDER MARK
Question # 63
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible stringvalues for a single tag?
A. 10
B. 50
C. 64
D. 256
Question # 64
There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the productionaccount to the non-production account?
A. Clone the data from the production account to the non-production account.
B. Create a data share from the production account to the non-production account.
C. Create a subscription in the production account and have it publish to the nonproductionaccount.
D. Create a reader account using the production account and link the reader account to thenon-production account.
Question # 65
Which objects together comprise a namespace in Snowflake? (Select TWO).
A. Account
B. Database
C. Schema
D. Table
E. Virtual warehouse
Question # 66
Which statements reflect valid commands when using secondary roles? (Select TWO).
A. Use SECONDARY ROLES RESUME
B. USE SECONDARY ROLES SUSPEND
C. USE SECONDARY RLES ALL
D. USE SECONDARY ROLES ADD <Role Name>
E. Use SECONDARY ROLES NONE
Question # 67
Which common query problems are identified by the Query Profile? (Select TWO.)
A. Syntax error
B. Inefficient pruning
C. Ambiguous column names
D. Queries too large to fit in memory
E. Object does not exist or not authorized
Question # 68
How long can a data consumer who has a pre-signed URL access data files usingSnowflake?
A. Indefinitely
B. Until the result_cache expires
C. Until the retention_time is met
D. Until the expiration time is exceeded
Question # 69
What does the TableScan operator represent in the Query Profile?
A. The access to a single table
B. The access to data stored in stage objects
C. The list of values provided with the VALUES clause
D. The records generated using the TABLE (GENERATOR (...)) construct
Question # 70
Which command should be used to unload all the rows from a table into one or more filesin a named stage?
A. COPY INTO
B. GET
C. INSERT INTO
D. PUT
Question # 71
What criteria does Snowflake use to determine the current role when initiating a session?(Select TWO).
A. If a role was specified as part of the connection and that role has been granted to theSnowflake user, the specified role becomes the current role.
B. If no role was specified as part of the connection and a default role has been defined forthe Snowflake user, that role becomes the current role.
C. If no role was specified as part of the connection and a default role has not been set forthe Snowflake user, the session will not be initiated and the log in will fail.
D. If a role was specified as part of the connection and that role has not been granted tothe Snowflake user, it will be ignored and the default role will become the current role.
E. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.
Question # 72
Which Snowflake URL type is used by directory tables?
A. File
B. Pre-signed
C. Scoped
D. Virtual-hosted style
Question # 73
Which Snowflake table type persists until it is explicitly dropped. is available for all userswith relevant privileges (across sessions). and has no Fail-safe period?
A. External
B. Permanent
C. Temporary
D. Transient
Question # 74
Regardless of which notation is used, what are considerations for writing the column nameand element names when traversing semi-structured data?
A. The column name and element names are both case-sensitive.
B. The column name and element names are both case-insensitive.
C. The column name is case-sensitive but element names are case-insensitive.
D. The column name is case-insensitive but element names are case-sensitive.
Question # 75
Which statement accurately describes how a virtual warehouse functions?
A. Increasing the size of a virtual warehouse will always improve data loading performance.
B. Each virtual warehouse is an independent compute cluster that shares computeresources with other warehouses.
C. Each virtual warehouse is a compute cluster composed of multiple compute nodesallocated by Snowflake from a cloud provider.
D. All virtual warehouses share the same compute resources so performance degradationof one warehouse can significantly affect all the other warehouses.
Question # 76
Which service or feature in Snowflake is used to improve the performance of certain typesof lookup and analytical queries that use an extensive set of WHERE conditions?
A. Data classification
B. Query acceleration service
C. Search optimization service
D. Tagging
Question # 77
What does Snowflake attempt to do if any of the compute resources for a virtual warehousefail to provision during start-up?
A. Repair the failed resources.
B. Restart failed resources.
C. Queue the failed resources
D. Provision the failed resources
Question # 78
What is it called when a customer managed key is combined with a Snowflake managedkey to create a composite key for encryption?
A. Hierarchical key model
B. Client-side encryption
C. Tri-secret secure encryption
D. Key pair authentication
Question # 79
Which Snowflake objects can be restored using Time Travel? (Select VNO).
A. Roles
B. Users
C. Databases
D. Schemas
E. Virtual warehouses
Question # 80
How can a Snowflake user validate data that is unloaded using the COPY INTO <location>command?
A. Load the data into a CSV file.
B. Load the data into a relational table.
C. Use the VALIDATION_MODE = SQL Statement.
D. Use the VALIDATION MODE = RETURN ROWS statement.
Question # 81
Which Snowflake data type is used to store JSON key value pairs?
A. TEXT
B. BINARY
C. STRING
D. VARIANT
Question # 82
Which statement describes Snowflake tables?
A. Snowflake tables arc logical representation of underlying physical data.
B. Snowflake tables are the physical instantiation of data loaded into Snowflake.
C. Snowflake tables require that clustering keys be defined lo perform optimally.
D. Snowflake tables are owned by a use.
Question # 83
What does Snowflake recommend a user do if they need to connect to Snowflake with atool or technology mat is not listed in Snowflake partner ecosystem?
A. Use Snowflake's native API.
B. Use a custom-built connector.
C. Contact Snowflake Support for a new driver.
D. Connect through Snowflake’s JDBC or ODBC drivers
Question # 84
Which file function generates a SnowFlake-hosted URL that must be authenticated whenused?
A. GET_STATE_LOCATION
B. GET_PRESENT_URL
C. BUILD_SCOPED_FILE_URL
D. BUILD_STAGE_FILE_URL
Question # 85
What is a characteristic of the Snowflake Query Profile?
A. It can provide statistics on a maximum number of 100 queries per week.
B. It provides a graphic representation of the main components of the query processing.
C. It provides detailed statistics about which queries are using the greatest number ofcompute resources.
D. It can be used by third-party software using the Query Profile API.
Question # 86
Which Snowflake feature records changes mace to a table so actions can be taken usingthat change data capture?
A. Materialized View
B. Pipe
C. Stream
D. Task
Question # 87
Who can grant object privileges in a regular schema?
A. Object owner
B. Schema owner
C. Database Owner
D. SYSADMIN
Question # 88
Which data types optimally store semi-structured data? (Select TWO).
A. ARRAY
B. CHARACTER
C. STRING
D. VARCHAR
E. VARIANT
Question # 89
What type of function returns one value for each Invocation?
A. Aggregate
B. Scalar
C. Table
D. Window
Question # 90
How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
A. 60 minutes
B. 24 hours
C. 14 days
D. 30 days
Question # 91
What is used to diagnose and troubleshoot network connections to Snowflake?
A. SnowCD
B. Snowpark
C. Snowsight
D. SnowSQL
Question # 92
What is the Fail-safe retention period for transient and temporary tables?
A. 0 days
B. 1 day
C. 7 days
D. 90 days
Question # 93
What is the MAXIMUM number of clusters that can be provisioned with a multi-clustervirtual warehouse?
A. 1
B. 5
C. 10
D. 100
Question # 94
A Snowflake account administrator has set the resource monitors as shown in the diagram,with actions defined for each resource monitor as "Notify & Suspend Immediately". What is the MAXIMUM limit of credits that Warehouse 2 can consume?
A. 0
B. 1500
C. 3500
D. 5000
Question # 95
Which query contains a Snowflake hosted file URL in a directory table for a stage namedbronzestage?
A. list @bronzestage;
B. select * from directory(@bronzestage);
C. select metadata$filename from @bronzestage;
D. select * from table(information_schema.stage_directory_file_registration_history(stage name=>'bronzestage1));
Question # 96
A JSON object is loaded into a column named data using a Snowflake variant datatype.The root node of the object is BIKE. The child attribute for this root node is BIKEID.Which statement will allow the user to access BIKEID?
A. select data:BIKEID
B. select data.BIKE.BIKEID
C. select data:BIKE.BIKEID
D. select data:BIKE:BIKEID
Question # 97
How does Snowflake describe its unique architecture?
A. A single-cluster shared data architecture using a central data repository and massivelyparallel processing (MPP)
B. A multi-duster shared nothing architecture using a soloed data repository and massivelyparallel processing (MPP)
C. A single-cluster shared nothing architecture using a sliced data repository andsymmetric multiprocessing (SMP)
D. A multi-cluster shared nothing architecture using a siloed data repository and symmetricmultiprocessing (SMP)
Question # 98
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
A. Bytes spilled to local cache.
B. Bytes spilled to local storage.
C. Bytes spilled to remote cache.
D. Bytes spilled to remote storage.
E. Bytes spilled to remote metastore.
Question # 99
Which SQL statement will require a virtual warehouse to run?
A. SELECT COUNT{*) FROM TBL_EMPLOYEE;
B. ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);
C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT)VALUES(1,'Adam*,20000,* Finance');
D. CREATE OR REPLACE TABLE TBL_EMPLOYEE (EMP_ID NUMBER,EMP_NAME VARCHAR(30),EMP_SALARY NUMBER, DEPT VARCHAR{20));
Question # 100
Which features make up Snowflake's column level security? (Select TWO).
A. Continuous Data Protection (CDP)
B. Dynamic Data Masking
C. External Tokenization
D. Key pair authentication
E. Row access policies
Question # 101
Which privilege is required to use the search optimization service in Snowflake?
A. GRANT SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
B. GRANT SEARCH OPTIMIZATION ON DATABASE <database_name> TO ROLE <role>
C. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE<role>
D. GRANT ADD SEARCH OPTIMIZATION ON DATABASE <database name> TO ROLE<role>
Question # 102
Which command will unload data from a table into an external stage?
A. PUT
B. INSERT
C. COPY INTO <location>
D. GET
Question # 103
Which file function gives a user or application access to download unstructured data from aSnowflake stage?
A. BUILD_SCOPED_FILE_URL
B. BUILD_STAGE_FILE_URL
C. GET_PRESIGNED_URL
D. GET STAGE LOCATION
Question # 104
What are characteristic of Snowsight worksheet? (Select TWO.)
A. Worksheets can be grouped under folder, and a folder of folders.
B. Each worksheet is a unique Snowflake session.
C. Users are limited to running only one on a worksheet.
D. The Snowflake session ends when a user switches worksheets.
E. Users can import worksheets and share them with other users.
Question # 105
Which typos of charts does Snowsight support? (Select TWO).
A. Area charts
B. Bar charts
C. Column charts
D. Radar charts
E. Scorecards
Question # 106
How does Snowflake define i1s approach to Discretionary Access Control (DAC)?
A. A defined level of access to an object
B. An entity in which access can be granted
C. Each object has an owner, who can in turn grail access to that object.
D. Access privileges are assigned to roles. which are in turn assigned to use's
Question # 107
Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a userconnected to Snowflak?
A. ACCESS_HOSTORY
B. LOGIN_HISTORY
C. SESSIONS
D. QUERY HISTORY
Question # 108
A Snowflake user needs to share unstructured data from an internal stage to a reportingtool that does not have Snowflake access.Which file function should be used?
A. BUILD_SCOPED_FILE_URL
B. BUILD_STAGE_FILE_URL
C. GET_PRESIGNED_URL
D. GET STAGE LOCATION
Question # 109
A user has semi-structured data to load into Snowflake but is not sure what types ofoperations will need to be performed on the data. Based on this situation, what type ofcolumn does Snowflake recommend be used?
A. ARRAY
B. OBJECT
C. TEXT
D. VARIANT
Question # 110
Which command is used to lake away staged files from a Snowflake stage after asuccessful data ingestion?
A. DELETE
B. DROP
C. REMOVE
D. TRUNCATE
Question # 111
Snowflake's access control framework combines which models for securing data? (SelectTWO).
A. Attribute-based Access Control (ABAC 1
B. Discretionary Access Control (DAC)
C. Access Control List (ACL)
D. Role-based Access Control (RBAC)
E. Rule-based Access Control (RuBAC)
Question # 112
Which use case does the search optimization service support?
A. Disjuncts (OR) in join predicates
B. LIKE/ILIKE/RLIKE join predicates
C. Join predicates on VARIANT columns
D. Conjunctions (AND) of multiple equality predicates
Question # 113
When referring to User-Defined Function (UDF) names in Snowflake, what does the termoverloading mean?
A. There are multiple SOL UDFs with the same names and the same number ofarguments.
B. There are multiple SQL UDFs with the same names and the same number of argumenttypes.
C. There are multiple SQL UDFs with the same names but with a different number ofarguments or argument types.
D. There are multiple SQL UDFs with different names but the same number of argumentsor argument types.
Question # 114
Which SQL command can be used to verify the privileges that are granted to a role?
A. SHOW GRANTS ON ROLE <Role Name>
B. SHOW ROLES <Role Name>
C. SHOW GRANTS TO ROLE <Role Name>
D. SHOW GRANTS FOR ROLE <Role Name>
Question # 115
In Snowflake, the use of federated authentication enables which Single Sign-On (SSO)workflow activities? (Select TWO).
A. Authorizing users
B. Initiating user sessions
C. Logging into Snowflake
D. Logging out of Snowflake
E. Performing role authentication
Question # 116
Which rotes can make grant decisions to objects within a managed access schema?(Select TWO)
A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSTEMADMIN
D. ORGADMIN
E. USERADMIN
Question # 117
Which function should be used to insert JSON format string data inot a VARIANT field?
A. FLATTEN
B. CHECK_JSON
C. PARSE_JSOK
D. TO_VARIANT
Question # 118
What can the Snowflake SCIM API be used to manage? (Select TWO).
A. Integrations
B. Network policies
C. Session policies
D. Roles
E. Users
Question # 119
A Snowflake user wants to temporarily bypass a network policy by configuring the userobject property MINS_TO_BYPASS_NETWORK_POLICY.What should they do?
A. Use the SECURITYADMIN role.
B. Use the SYSADMIN role.
C. Use the USERADMIN role.
D. Contact Snowflake Support.
Question # 120
What operations can be performed while loading a simple CSV file into a Snowflake tableusing the COPY INTO command? (Select TWO).
A. Performing aggregate calculations
B. Reordering the columns
C. Grouping by operations
D. Converting the datatypes
E. Selecting the first few rows
Question # 121
A permanent table and temporary table have the same name, TBLI, in a schema.What will happen if a user executes select * from TBLI;?
A. The temporary table will take precedence over the permanent table.
B. The permanent table will take precedence over the temporary table.
C. An error will say there cannot be two tables with the same name in a schema.
D. The table that was created most recently will take precedence over the older table.
Question # 122
Who can create network policies within Snowflake? (Select TWO).
A. SYSADMIN only
B. ORCADMIN only
C. SECURITYADMIN or higher roles
D. A role with the CREATE NETWORK POLICY privilege
E. A role with the CREATE SECURITY INTEGRATION privilege
Question # 123
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
A. (12,2)
B. (10,4)
C. (14,8)
D. (15,9)
Question # 124
How is unstructured data retrieved from data storage?
A. SOL functions like the GET command can be used to copy the unstructured data to alocation on the client.
B. SQL functions can be used to create different types of URLs pointing to the unstructureddata. These URLs can be used to download the data to a client.
C. SQL functions can be used to retrieve the data from the query results cache. When thequery results are output to a client, the unstructured data will be output to the client as files.
D. SQL functions can call on different web extensions designed to display different types offiles as a web page. The web extensions will allow the files to be downloaded to the client.
Question # 125
What does the worksheet and database explorer feature in Snowsight allow users to do?
A. Add or remove users from a worksheet.
B. Move a worksheet to a folder or a dashboard.
C. Combine multiple worksheets into a single worksheet.
D. Tag frequently accessed worksheets for ease of access.
Question # 126
What is the default value in the Snowflake Web Interface (Ul) for auto suspending a VirtualWarehouse?
A. 1 minutes
B. 5 minutes
C. 10 minutes
D. 15 minutes
Question # 127
What is a feature of column-level security in Snowflake?
A. Role access policies
B. Network policies
C. Internal tokenization
D. External tokenization
Question # 128
What is the only supported character set for loading and unloading data from all supportedfile formats?
A. UTF-8
B. UTF-16
C. ISO-8859-1
D. WINDOWS-1253
Question # 129
How does Snowflake recommend handling the bulk loading of data batches from filesalready available in cloud storage?
A. Use Snowpipe.
B. Use the INSERT command.
C. Use an external table.
D. Use the COPY command.
Question # 130
What do temporary and transient tables have m common in Snowflake? (Select TWO).
A. Both tables have no Fail-safe period.
B. Both tables have data retention period maximums of one day.
C. Both tables are visible only to a single user session.
D. For both tables the retention period ends when the tables are dropped.
E. For both tables, the retention period does not end when the session ends
Question # 131
Which file function generates a Snowflake-hosted file URL to a staged file using the nameand relative file path as inputs?
A. BUILD_STAGE_FILE_URL
B. GET_ABSOLUTE_PATH
C. GET_RELATIVE_PATH
D. GET_STAGE_LOCATION
Question # 132
By definition, a secure view is exposed only to users with what privilege?
A. IMPORT SHARE
B. OWNERSHIP
C. REFERENCES
D. USAGE
Question # 133
How can a Snowflake user post-process the result of SHOW FILE FORMATS?
A. Use the RESULT_SCAM function.
B. Create a CURSOR for the command.
C. Put it in the FROM clause in brackets.
D. Assign the command to RESULTSET.
Question # 134
Which function should be used to find the query ID of the second query executed in acurrent session?
A. Select LAST_QUERY_ID-2)
B. Select LAST_QUERY_ID{2)
C. Select LAST_QUERY_ID{1)
D. Select LAST_QUERY_ID{2)
Leave a comment
Your email address will not be published. Required fields are marked *