Tested Material Used To SnowPro-Core Test Engine Exam Questions in here [Aug-2021]
Penetration testers simulate SnowPro-Core exam PDF
NEW QUESTION 83
What is the maximum compressed row size in Snowflake?
- A. 16MB
- B. 8KB
- C. 50MB
- D. 4000GB
Answer: A
Explanation:
Explanation
NEW QUESTION 84
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 85
Which of the following commands sets the Virtual Warehouse for a session?
- A. SET warehouse = <<warehouse name>>;
- B. USE VIRTUAL_WAREHOUSE <<warehouse name>>;
- C. USE WAREHOUSE <<warehouse name>>;
- D. COPT WAREHOUSE FROM <<Config file> ;
Answer: C
NEW QUESTION 86
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Storage expands without the requirement to add more compute
- B. Growth of storage and compute are tightly coupled together
- C. Multiple compute clusters can access stored data without contention
- D. Compute can be scaled up or down without the requirement to add more storage
Answer: A,C,D
NEW QUESTION 87
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 88
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. True
- B. False
Answer: A
NEW QUESTION 89
If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:
- A. There are no users loaned into Snowflake.
- B. The Warehouse is inactive for a specified period of time.
- C. The last query using the warehouse completes.
- D. All Snowflake sessions using the warehouse are terminated.
Answer: B
NEW QUESTION 90
Which of the following statements about data sharing are true?
choose 2 answers
- A. Reader Accounts are created and funded by Data Prowlers
- B. Shared databases are read-only
- C. All database objects can be included In a shared database
- D. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts
Answer: A,B
NEW QUESTION 91
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A. False
- B. True
Answer: A
Explanation:
Explanation
NEW QUESTION 92
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
- A. True
- B. False
Answer: A
NEW QUESTION 93
Which of the following best describes where Snowflake's metadata is stored?
- A. Within the data files
- B. Inside the Virtual Warehouses
- C. In the Cloud Services Layer
- D. within the drivers
Answer: C
NEW QUESTION 94
For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.
- A. The number of queries that ran using the Warehouse.
- B. The number of users who accessed the Warehouse.
- C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
- D. The size of the Warehouse and the number of clusters that ran within a given time period.
Answer: D
NEW QUESTION 95
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. Data integration tools
- B. The Snowflake Web Interface (UI)
- C. All of the above
- D. SQL commands
Answer: D
NEW QUESTION 96
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.
- A. Bulk copy from an External Stage
- B. Continuous load using Snowpipe REST API
- C. Bulk copy from an Internal Stage
- D. The Snowflake Web Interface (UT) data loading wizard
Answer: A,B,C,D
NEW QUESTION 97
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION 98
......
Authentic Best resources for SnowPro-Core Online Practice Exam: https://www.examslabs.com/Snowflake/SnowPro-Core/best-SnowPro-Core-exam-dumps.html
Get the superior quality SnowPro-Core Dumps with explanations waiting just for you, get it now: https://drive.google.com/open?id=1XEwTxNgo7BdWA2I0oBUUdzl95URrXtQ9