Unique Top-selling SnowPro-Core Exams - New 2022 Snowflake Pratice Exam
SnowPro Core Dumps SnowPro-Core Exam for Full Questions - Exam Study Guide
NEW QUESTION 138
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers
- A. Oracle Cloud
- B. Private Virtual Cloud
- C. Microsoft Azure Cloud
- D. Amazon Web Services
Answer: C,D
NEW QUESTION 139
Fail-safe is unavailable on which table types?
- A. Permanent
- B. Provisional
- C. Transient
- D. Temporary
Answer: C,D
NEW QUESTION 140
Which statements are true of micro-partitions?
Choose 2 answers
- A. They are stored compressed only if COMPRESS=TRUE on Table
- B. They are approximately 16MB in size
- C. They are Immutable
- D. They are only encrypted in the Enterprise edition and above
Answer: B,C
Explanation:
Reference:
731ddc983c69
NEW QUESTION 141
What is the maximum compressed row size in Snowflake?
- A. 16MB
- B. 50MB
- C. 8KB
- D. 4000GB
Answer: A
Explanation:
MAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.
NEW QUESTION 142
Which type of table corresponds to a single Snowflake session?
- A. Permanent
- B. Provisional
- C. Translent
- D. Temporary
Answer: D
Explanation:
Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.
NEW QUESTION 143
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
- A. Incoming data can be joined with other tables
- B. Columns can be omitted
- C. Row level access can be defined
- D. Columns can be reordered
- E. Data can be filtered by an optional where clause
Answer: B,D
NEW QUESTION 144
What privileges are required to execute a task?
- A. A task is an account-level object and can only be executed by the Account Admin role.
- B. To execute a task, you need the EXECUTE TASK.
- C. Tasks run automatically and do run under any rote.
- D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.
Answer: B
NEW QUESTION 145
Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)?
(Choose two.)
- A. ODBC
- B. HIVE
- C. R
- D. SnowSQL
Answer: A,D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/connecting.html
NEW QUESTION 146
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.
- A. Better query scheduling
- B. Higher storage costs
- C. More micro-partitions
- D. Double the numbers of servers In the compute duster
Answer: D
NEW QUESTION 147
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
- A. ARRAY
- B. VARCHAR
- C. XML
- D. BLOB
- E. VARIANT
Answer: A,E
Explanation:
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
NEW QUESTION 148
Which item in the Data Warehouse migration process does not apply in Snowflake>
- A. Build the Data pipeline
- B. Migrate Schemas
- C. Migrate Indexes
- D. Migrate Users
Answer: C
NEW QUESTION 149
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. False
- B. True
Answer: A
NEW QUESTION 150
When creating a user it is advisable sable to:
Choose 2 answers
- A. Set the user to be initially disabled
- B. Set the number of minutes to unlock to 15 minutes
- C. Set the users access to expire within a specified timeframe
- D. Set a default role for the user
- E. Force an immediate password change
Answer: D,E
NEW QUESTION 151
A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?
- A. Query against a virtual warehouse cache
- B. Query against the result set cache
- C. Query against the most-recently created micro-partition
- D. Query against the metadata excite
Answer: D
NEW QUESTION 152
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A. False
- B. True
Answer: A
Explanation:
A reader account can only consume data from the provider account that created it.
NEW QUESTION 153
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION 154
True or False: Pipes can be suspended and resumed.
- A. False
- B. True
Answer: A
NEW QUESTION 155
Which copy INTO command outputs the data into one file?
- A. SINGLE=TRUE
- B. FILE_NUMBER=1
- C. MAX_FILE_NUMBER=1
- D. MULTIPLE=FAISE
Answer: C
NEW QUESTION 156
Where would a Snowflake user find information about query activity from 90 days ago?
- A. information__schema - query history_by_ses s i on view
- B. account__usage.query__history__archive View
- C. account__usage . query history view
- D. information__schema . cruery_history view
Answer: C
NEW QUESTION 157
What are ways to create and manage data shares in Snowflake? (Select TWO)
- A. Through the Snowflake web interface (Ul)
- B. Using the CREATE SHARE AS SELECT * TABLE command
- C. Through the DATA_SHARE=TRUE parameter
- D. Through the enable__share=true parameter
- E. Through SQL commands
Answer: D,E
NEW QUESTION 158
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
- A. Permanent Tables
- B. Provisional Tables
- C. Temporary Tables
- D. Transient Tables
Answer: C,D
NEW QUESTION 159
In which layer of its architecture does Snowflake store its metadata statistics?
Select one.
- A. Storage Layer
- B. Database Layer
- C. Cloud Service Layer
- D. Compute Layer
Answer: C
NEW QUESTION 160
True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
- A. False
- B. True
Answer: A
NEW QUESTION 161
......
Best way to practice test for Snowflake SnowPro-Core: https://www.vceprep.com/SnowPro-Core-latest-vce-prep.html
SnowPro-Core Dump Ready - Exam Questions and Answers: https://drive.google.com/open?id=1kYAjikZT5bn6O_d7bDYU66WE3pZw_vtH