Use Real Snowflake Achieve the SnowPro-Core Dumps - 100% Exam Passing Guarantee
Verified SnowPro-Core Q&As - Pass Guarantee SnowPro-Core Exam Dumps
NEW QUESTION # 89
What is the recommended Snowflake data type to store semi-structured data like JSON?
- A. VARCHAR
- B. VARIANT
- C. LOB
- D. RAW
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html
NEW QUESTION # 90
True or False: During data unloading, only JSON and CSV files can be compressed.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html
NEW QUESTION # 91
True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.
- A. True
- B. False
Answer: B
NEW QUESTION # 92
How a Snowpipe charges calculated?
- A. Total storage bucket size
- B. Per-second/per-core granularity
- C. Number of Pipes in account
- D. Per-second/per Warehouse size
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html
NEW QUESTION # 93
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
- A. Via Virtual Warehouses
- B. Via the data_share=true parameter
- C. Via the Snowflake Web Interface (Ul)
- D. Via SQL commands
Answer: C,D
NEW QUESTION # 94
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers
- A. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
- B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
- C. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
- D. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
Answer: A,B
Explanation:
The results cache will only be used if it's the same query AND the same role executing the query
NEW QUESTION # 95
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
- A. REPLACE_INVALID_CHARACTERS
- B. SKIP_BYTE_ORDER_MARK
- C. VALIDATION_MODE
- D. STRIP_NULL_VALUES
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
NEW QUESTION # 96
What happens when a cloned table is replicated to a secondary database? (Select TWO)
- A. Metadata pointers to cloned tables are replicated
- B. A read-only copy of the cloned tables is stored.
- C. Additional costs for storage are charged to a secondary account
- D. The replication will not be successful.
- E. The physical data is replicated
Answer: C,E
Explanation:
Explanation
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-replication-considerations.html#:~:text=Replication%20and%
NEW QUESTION # 97
What role is required to use Partner Connect?
- A. SYSADMIN
- B. ACCOUNTADMIN
- C. ORGADMIN
- D. SECURITYADMIN
Answer: D
NEW QUESTION # 98
What column type does a Kafka connector store formatted information in a single column?
- A. OBJECT
- B. VARIANT
- C. ARRAY
- D. VARCHAR
Answer: D
NEW QUESTION # 99
What is the maximum compressed row size in Snowflake?
- A. 50MB
- B. 4000GB
- C. 16MB
- D. 8KB
Answer: C
NEW QUESTION # 100
True or False: Pipes can be suspended and resumed.
- A. True
- B. False
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 101
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.
- A. False
- B. True
Answer: B
Explanation:
Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/
NEW QUESTION # 102
Which of the following statements describes a schema in Snowflake?
- A. A uniquely identified Snowflake account within a business entity
- B. A logical grouping of objects that belongs to multiple databases
- C. A logical grouping of objects that belongs to a single database
- D. A named Snowflake object that includes all the information required to share a database
Answer: C
NEW QUESTION # 103
Which of the following commands cannot be used within a reader account?
- A. ALTER WAREHOUSE
- B. SHOW SCHEMAS
- C. DROP ROLE
- D. CREATE SHARE
- E. DESCRBE TABLE
Answer: A
Explanation:
Explanation
A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.
NEW QUESTION # 104
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A. True
- B. False
Answer: B
Explanation:
A reader account can only consume data from the provider account that created it.
NEW QUESTION # 105
Which of the following statements about data sharing are true?
choose 2 answers
- A. All database objects can be included In a shared database
- B. Shared databases are read-only
- C. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts
- D. Reader Accounts are created and funded by Data Prowlers
Answer: B,D
NEW QUESTION # 106
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
- A. Information Schema -> TABLE_FUNCTION
- B. SHOW STORAGE BY TABLE;
- C. SHOW TABLES;
- D. Information Schema -> TABLE_STORAGE_METRICS
- E. Information Schema -> TABLE_HISTORY
Answer: C,D
NEW QUESTION # 107
Where can a user find and review the failed logins of a specific user for the past 30 days?
- A. The LOGIN_HISTORY view in ACCOUNT_USAGE
- B. The ACCESS_HISTORY view in ACCOUNT_USAGE
- C. The SESSIONS view in ACCOUNT_USAGE
- D. The USERS view in ACCOUNT_USAGE
Answer: A
NEW QUESTION # 108
What feature can be used to reorganize a very large table on one or more columns?
- A. Clustered partitions
- B. Micro-partitions
- C. Clustering keys
- D. Key partitions
Answer: C
Explanation:
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
NEW QUESTION # 109
How long is Snowpipe data load history retained?
- A. 14 days
- B. 64 days
- C. Until the pipe is dropped
- D. As configured in the create pipe settings
Answer: B
Explanation:
Bulk data load
Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%20data%20load&text=Stored%20in%20the%20metadata%20of,statement%20as%20the%20statement%20output.&text=Stored%20in%20the%20metadata%20of%20the%20pipe%20for%2014%20days.
NEW QUESTION # 110
Select the different types of Internal Stages: (Choose three.)
- A. Named Stage
- B. Schema Stage
- C. User Stage
- D. Table Stage
Answer: A,C,D
Explanation:
Reference:
Named-Stage
NEW QUESTION # 111
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
- A. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
- B. A Data Exchange allows groups of accounts to share data privately among the accounts.
- C. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
- D. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
- E. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
Answer: B
NEW QUESTION # 112
Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:
- A. Clustered partitions
- B. Micro-partitions
- C. Clustering keys
- D. Key partitions
Answer: C
NEW QUESTION # 113
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
- A. False
- B. True
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html
NEW QUESTION # 114
......
Check the Free demo of our SnowPro-Core Exam Dumps with 339 Questions: https://www.examslabs.com/Snowflake/SnowPro-Core/best-SnowPro-Core-exam-dumps.html
Clear your concepts with SnowPro-Core Questions Before Attempting Real exam: https://drive.google.com/open?id=11pk0Admh33ST_NgbQVcd2L5jUL_9ucb7