Get Snowflake SnowPro-Core Dumps Questions [2021] To Gain Brilliant Result
SnowPro-Core dumps - TestPassKing - 100% Passing Guarantee
NEW QUESTION 54
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.
- A. False
- B. True
Answer: A
NEW QUESTION 55
Which type of table corresponds to a single Snowflake session?
- A. Provisional
- B. Temporary
- C. Translent
- D. Permanent
Answer: B
NEW QUESTION 56
True or False: Data Providers can share data with only the Data Consumer.
- A. True
- B. False
Answer: A
NEW QUESTION 57
Which of the following statement is true of Snowflake?
Select one.
- A. It was built for Hadoop architecture
- B. it was built as an on-premises solution and then potted to the cloud
- C. It's based on an Oracle Architecture
- D. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
- E. It was built specifically for the cloud
Answer: E
NEW QUESTION 58
What are the three layers that make up Snowflake's architecture?
Choose 3 answer
- A. Storage
- B. Tri-Secret Secure
- C. Cloud Services
- D. Compute
Answer: A,C,D
NEW QUESTION 59
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
- A. False
- B. True
Answer: A
NEW QUESTION 60
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 61
True or False: The COPY command must specify a File Format in order to execute.
- A. True
- B. False
Answer: A
NEW QUESTION 62
True or False: You can resize a Virtual Warehouse while queries are running.
- A. True
- B. False
Answer: A
NEW QUESTION 63
The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers
- A. The complexity of each query
- B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- C. The tool that s executing the query
- D. The size of the data required for each query
Answer: A,D
NEW QUESTION 64
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 65
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
- A. True
- B. False
Answer: A
NEW QUESTION 66
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION 67
What happens when a Data Provider revokes privileges to a Share on an object in their source database?
- A. Any additional data arriving after this point in time will not be visible to Data Consumers
- B. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts
- C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
- D. The object immediately becomes unavailable for all Data Consumers
Answer: D
NEW QUESTION 68
When a pipe is recreated using the CREATE on REPLAC PIPE command:
Select one.
- A. The Pipe load history is reset to empty
- B. The REFRESH parameter is set to TRUE
- C. Previously loaded files will be ignored
- D. All of the above
Answer: A
NEW QUESTION 69
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 70
True or False: Pipes can be suspended and resumed.
- A. False
- B. True
Answer: A
NEW QUESTION 71
In which layer of its architecture does Snowflake store its metadata statistics?
- A. Database Layer
- B. Storage Layer
- C. Compute Layer
- D. Cloud Services Layer
Answer: D
Explanation:
Explanation/Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/
NEW QUESTION 72
What is the minimum Snowflake edition that provides data sharing?
- A. Business Critical Edition
- B. Standard
- C. Premier
- D. Enterprise
Answer: B
NEW QUESTION 73
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. True
- B. False
Answer: A
NEW QUESTION 74
......
Get 100% Passing Success With True SnowPro-Core Exam: https://www.testpassking.com/SnowPro-Core-exam-testking-pass.html
Premium Quality Snowflake SnowPro-Core Online dumps: https://drive.google.com/open?id=1BGMpPRYwb21aOEj_S_H454zFI8wD2JJR