SnowPro-Core Training & Certification Get Latest SnowPro Core Updated on Sep 28, 2021
Certification Training for SnowPro-Core Exam Dumps Test Engine
NEW QUESTION 80
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
- A. True
- B. False
Answer: A
NEW QUESTION 81
True or False: You can define multiple columns within a clustering key on a table.
- A. True
- B. False
Answer: A
NEW QUESTION 82
Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)?
(Choose two.)
- A. ODBC
- B. HIVE
- C. SnowSQL
- D. R
Answer: A,C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/connecting.html
NEW QUESTION 83
Which statement best describes "clustering"?
- A. Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
- B. The clustering key must be included on the COPY command when loading data into Snowflake
- C. The database administrator must define the clustering methodology for each Snowflake table
- D. Clustering can be disabled within a Snowflake account
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
NEW QUESTION 84
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A. True
- B. False
Answer: A
NEW QUESTION 85
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Select one.
- A. 1 Hour
- B. 3 Hours
- C. 24 hours
- D. 12 hours
Answer: C
NEW QUESTION 86
True or false: it is best practice to define a clustering key on every table.
- A. False
- B. True
Answer: A
NEW QUESTION 87
Which of the following statements is true of zero-copy cloning?
- A. Zero-copy clones increase storage costs as cloning the table requires storing its data twice
- B. At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared
- C. Zero-copy cloning is licensed as an additional Snowflake feature
- D. All zero-copy clone objects inherit the privileges of their original objects
Answer: B
Explanation:
Explanation/Reference: https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data
NEW QUESTION 88
What is the recommended Snowflake data type to store semi-structured data like JSON?
- A. LOB
- B. RAW
- C. VARIANT
- D. VARCHAR
Answer: C
NEW QUESTION 89
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
- A. False
- B. True
Answer: A
NEW QUESTION 90
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A. True
- B. False
Answer: A
NEW QUESTION 91
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:
- A. SECURITYADMIN, ACCOUNTADMIN
- B. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
- C. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
- D. ACCOUNTADMIN
Answer: C
NEW QUESTION 92
What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers
- A. On-premise availability
- B. Open source based
- C. Simplicity
- D. Concurrency
- E. Performance
Answer: C,D,E
NEW QUESTION 93
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
- A. Scaling up
- B. Scaling max
- C. Scaling out
- D. Scaling rhythmically
Answer: A
NEW QUESTION 94
When loading data into Snowflake, the COPY command supports:
Choose 2 answers
- A. Aggregates
- B. Fitters
- C. Joins
- D. Column reordering
- E. Data type conversions
Answer: D,E
NEW QUESTION 95
Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:
- A. Micro-partitions
- B. Clustered partitions
- C. Key partitions
- D. Clustering keys
Answer: D
Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Snowflake-What-the-Cluster
NEW QUESTION 96
What command is used to load files into an Internal Stage within Snowflake? Select one.
- A. COPY INTO
- B. INSERT
- C. TRANSFER
- D. PUT
Answer: D
NEW QUESTION 97
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A. True
- B. False
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html
NEW QUESTION 98
In which layer of its architecture does Snowflake store its metadata statistics?
Select one.
- A. Cloud Service Layer
- B. Database Layer
- C. Storage Layer
- D. Compute Layer
Answer: A
NEW QUESTION 99
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
- A. False
- B. True
Answer: A
NEW QUESTION 100
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
- A. False
- B. True
Answer: A
NEW QUESTION 101
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Standard
- B. Premier
- C. Business Critical Edition
- D. Enterprise
Answer: C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
NEW QUESTION 102
What is the recommended method for loading data into Snowflake?
- A. Load data via frequent, angle row DML's
- B. Load data in batch
- C. Load data by writing it In the Snowflake Web Interface (UI)
- D. Load row by row
Answer: B
NEW QUESTION 103
Which statement best describes Snowflake tables?
- A. Snowflake tables are the physical instantiation of data loaded into Snowflake
- B. Snowflake tables are owned by a user
- C. Snowflake tables require that clustering keys be defined to perform optimally
- D. Snowflake tables are logical representations of underlying physical data
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html
NEW QUESTION 104
True or False: Snowflake charges additional fees to Data Providers for each Share they create.
- A. True
- B. False
Answer: A
Explanation:
Explanation/Reference: https://1amiydhcmj36tz3733v94f15-wpengine.netdna-ssl.com/wp-content/uploads/2017/08/ Enabling-new-products-and-services-with-Snowflake-Data-Sharing.pdf
NEW QUESTION 105
......
Step by Step Guide to Prepare for SnowPro-Core Exam: https://www.real4dumps.com/SnowPro-Core_examcollection.html
SnowPro Core SnowPro-Core Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=1_f51e574BTnYj68nPCECTJoAGzHXWzQs
