Real SnowPro-Core dumps - Real Snowflake dumps PDF in here [Dec-2021]
Realistic Exams4sures SnowPro-Core Dumps PDF - 100% Passing Guarantee
Topics of SnowPro Core Certification
SNOWFLAKE SNOWPRO CORE dumps pdf will include the following topics:
- Data Movement (Loading and Unloading), Data pipelines
- Snowflake Virtual Warehouses Compute, Warehouses
- Snowflake Performance and Tuning, Performance management, Query optimization
- Snowflake Overview and Architecture Business cases, Data sharing, Extensibility
- Snowflake Storage and Protection, Continuous data protection, Storage
- Semi-Structured Data
- Snowflake Cloud services, Migrations, Objects, WebUI
- Snowflake Account and Security, Account and security, Security management
NEW QUESTION 98
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)
- A. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
- B. 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 24 hour period
- C. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
- D. The "24 hour" timer on the precomputed results gets renewed every time the exact query is executed
Answer: B,C
NEW QUESTION 99
Which of the following statements are true of Snowflake releases: (Choose two.)
- A. They roll up and release approximately monthly, but customers can request early release application
- B. They happen approximately weekly
- C. During a release, new customer requests/queries/connections transparently move over to the newer version
- D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
Answer: C,D
NEW QUESTION 100
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.
- A. Continuous load using Snowpipe REST API
- B. Bulk copy from an Internal Stage
- C. The Snowflake Web Interface (UT) data loading wizard
- D. Bulk copy from an External Stage
Answer: A,C,D
NEW QUESTION 101
Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers
- A. SHOW TABLES;
- B. Information Schema -> TABLE_STORAGE_METRICS
- C. Information Schema -> TASLE_HISTORY
- D. SHOW STORAGE BY TABLE;
Answer: A,C
NEW QUESTION 102
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- A. Databases
- B. Users
- C. Tables
- D. Internal Stages
Answer: A,B,C
NEW QUESTION 103
Which of the following commands are not blocking operations?
Choose 2 answers
- A. INSERT
- B. MERGE
- C. COPY
- D. UPDATE
Answer: A,C
NEW QUESTION 104
If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:
- A. The last query using the warehouse completes.
- B. There are no users loaned into Snowflake.
- C. All Snowflake sessions using the warehouse are terminated.
- D. The Warehouse is inactive for a specified period of time.
Answer: D
NEW QUESTION 105
Which of the following terms best describes Snowflake's database architecture?
- A. Columnar shared nothing
- B. Multi-cluster, shared data
- C. Cloud-native shared memory
- D. Shared disk
Answer: D
NEW QUESTION 106
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
- A. Scaling max
- B. Scaling up
- C. Scaling rhythmically
- D. Scaling out
Answer: B
NEW QUESTION 107
True or False: The COPY command must specify a File Format in order to execute.
- A. True
- B. False
Answer: A
NEW QUESTION 108
True or False: An active warehouse is required to run a COPY INTO statement.
- A. True
- B. False
Answer: A
NEW QUESTION 109
In which layer of its architecture does Snowflake store its metadata statistics?
Select one.
- A. Storage Layer
- B. Compute Layer
- C. Database Layer
- D. Cloud Service Layer
Answer: D
NEW QUESTION 110
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 111
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. SQL commands
- B. All of the above
- C. Data integration tools
- D. The Snowflake Web Interface (UI)
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
NEW QUESTION 112
True or False: A single database can exist in more than one Snowflake account.
- A. True
- B. False
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html
NEW QUESTION 113
Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.
- A. Resource Monitor
- B. Credit Consumption Tracker
- C. Warehouse Limit Parameter
- D. Account usage Tracking
Answer: A
NEW QUESTION 114
......
Verified SnowPro-Core dumps Q&As Latest SnowPro-Core Download: https://www.exams4sures.com/Snowflake/SnowPro-Core-practice-exam-dumps.html
Free Snowflake SnowPro-Core Exam Questions & Answer: https://drive.google.com/open?id=1UrCqBsskJksGzBokTnIfWL7fTYVQvQAi