Free COF-R02 Exam Files Verified & Correct Answers Downloaded Instantly
Instant Download COF-R02 Dumps Q&As Provide PDF&Test Engine
NEW QUESTION 135
Which data type can store more than one type of data structure?
- A. JSON
- B. BINARY
- C. VARCHAR
- D. VARIANT
Answer: D
NEW QUESTION 136
True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
- A. False
- B. True
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
NEW QUESTION 137
When loading data into Snowflake, how should the data be organized?
- A. Into single files with 100-250 MB of compressed data per file
- B. Into files of maximum size of 4 GB of compressed data per file
- C. Into files of maximum size of 1 GB of compressed data per file
- D. Into single files with 1-100 MB of compressed data per file
Answer: A
NEW QUESTION 138
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
- A. Data masking policies
- B. Data encryption
- C. Role based access control
- D. Row access policies
Answer: A
NEW QUESTION 139
What are common issues found by using the Query Profile? (Choose two.)
- A. Identifying inefficient micro-partition pruning
- B. Data spilling to a local or remote disk
- C. Locating queries that consume a high amount of credits
- D. Identifying logical issues with the queries
- E. Identifying queries that will likely run very slowly before executing them
Answer: A,E
NEW QUESTION 140
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
- A. Okta Verify
- B. Microsoft Authenticator
- C. Duo Mobile
- D. Google Authenticator
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/security-mfa.html
NEW QUESTION 141
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION 142
What Snowflake role must be granted for a user to create and manage accounts?
- A. ORGADMIN
- B. SYSADMIN
- C. ACCOUNTADMIN
- D. SECURITYADMIN
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
NEW QUESTION 143
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
- A. INSERT INTO TABLE SELECT FROM STREAM
- B. SELECT FROM STREAM
- C. UPDATE TABLE FROM STREAM
- D. BEGIN COMMIT
- E. ALTER TABLE AS SELECT FROM STREAM
Answer: A,E
NEW QUESTION 144
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
- A. Use a larger-sized warehouse.
- B. Compress the file and load the compressed file.
- C. Split the file into multiple files in the recommended size range (100 MB - 250 MB).
- D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
Answer: B
NEW QUESTION 145
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
- A. Sequence
- B. Secure view
- C. Transient table
- D. Materialized view
- E. Clustered table
Answer: C,E
NEW QUESTION 146
How would you determine the size of the virtual warehouse used for a task?
- A. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- B. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
- C. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
- D. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
Answer: D
NEW QUESTION 147
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
- A. Roles
- B. Schemas
- C. Secure User-Defined Functions (UDFs)
- D. Secure Views
- E. Tables
- F. Stored Procedures
Answer: A,B,C
NEW QUESTION 148
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
- A. Metadata management
- B. Database storage
- C. Authentication and access control
- D. Query processing
- E. Local disk caching
Answer: A,D
NEW QUESTION 149
What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers
- A. On-premise availability
- B. Performance
- C. Simplicity
- D. Open source based
- E. Concurrency
Answer: B,C,E
NEW QUESTION 150
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
- A. Use of multi-clustered warehouses
- B. The use of warehouse auto scaling
- C. The ability to scale up warehouses
- D. The use of warehouse indexing
- E. The ability to resize warehouses
Answer: A,B
NEW QUESTION 151
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
- A. The virtual warehouse that is defined at the session level will be used to read all data.
- B. The default virtual warehouse will be used to read all data.
- C. No virtual warehouse will be used, data will be read from the local disk cache.
- D. No virtual warehouse will be used, data will be read from the result cache.
Answer: D
NEW QUESTION 152
When cloning a database, what is cloned with the database? (Choose two.)
- A. Existing child objects within the database
- B. Privileges on the schemas within the database
- C. Only schemas and tables within the database
- D. Privileges on the database
- E. Future child objects within the database
Answer: A,C
NEW QUESTION 153
Which of the following objects can be cloned? (Choose four.)
- A. Schemas
- B. Named File Formats
- C. Users
- D. Shares
- E. Databases
- F. Tables
Answer: A,B,E,F
Explanation:
Explanation
Which Objects Can Be Cloned?
Data Containment Objects. Databases. Schemas. Tables. Streams.
Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks
NEW QUESTION 154
......
Exam Valid Dumps with Instant Download Free Updates: https://www.prepawaypdf.com/Snowflake/COF-R02-practice-exam-dumps.html
Fast Exam Updates COF-R02 dumps with PDF Test Engine Practice: https://drive.google.com/open?id=1Ii5xGPugEzKdywo7F4l2KuS-lkt1IS4V