A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?
A. It removes the last element of the outer array.
B. It removes the outer array structure and loads the records into separate table rows,
C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
Correct Answer: B
Data Size Limitations The VARIANT data type imposes a 16 MB size limit on individual rows. For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported. If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format
option for the COPY INTO
command to remove the outer array structure and load the records into separate table rows:
A. Zero-copy cloning creates a mirror copy of a database that updates with the original
B. Software updates are automatically applied on a quarterly basis
C. Snowflake eliminates resource contention with its virtual warehouse implementation
D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
Correct Answer: C
Question 1015:
User-level network policies can be created by which of the following roles? (Select TWO).
A. ROLEADMIN
B. ACCOUNTADMIN
C. SYSADMIN
D. SECURITYADMIN
E. USERADMIN
Correct Answer: BD
Question 1016:
What happens when a cloned table is replicated to a secondary database? (Select TWO)
A. A read-only copy of the cloned tables is stored.
B. The replication will not be successful.
C. The physical data is replicated
D. Additional costs for storage are charged to a secondary account
E. Metadata pointers to cloned tables are replicated
Correct Answer: CD
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/database-replicationconsiderations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20areandtext=However%2C%20when%20a%20cloned%20table,storage% 20usage%20for% 20your%20account.
Question 1017:
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?
A. list @mytable;
B. list @%raytable;
C. list @ %m.ystage;
D. list @mystage;
Correct Answer: D
Question 1018:
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?
A. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Correct Answer: B
Question 1019:
What data is stored in the Snowflake storage layer? (Select TWO).
A. Snowflake parameters
B. Micro-partitions
C. Query history
D. Persisted query results
E. Standard and secure view results
Correct Answer: BC
B. Micro-partitions
C. Query history (also stored in the data layer of SNOWFLAKE.USAGE_SCHEMA)
Question 1020:
True or False: A Virtual Warehouse can be resized while suspended.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.