SnowPro-Core Dumps PDF 2024 Strategy Your Preparation Efficiently
Latest Verified & Correct Snowflake SnowPro-Core Questions
The SnowPro-Core Certification Exam is offered online and can be taken from anywhere in the world. SnowPro-Core exam is proctored, and candidates must have a webcam and a reliable internet connection to take the exam. Snowflake also offers preparation courses and study materials to help candidates prepare for the exam and ensure their success.
NEW QUESTION # 12
Which object allows you to limit the number of credits consumed within a Snowflake account?
- A. Account Usage Tracking
- B. Warehouse Limit Parameter
- C. Resource Monitor
- D. Credit Consumption Tracker
Answer: C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/resource-monitors.html
NEW QUESTION # 13
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 14
What are the three layers that make up Snowflake's architecture?
Choose 3 answer
- A. Compute
- B. Cloud Services
- C. Tri-Secret Secure
- D. Storage
Answer: A,B,D
NEW QUESTION # 15
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 16
Which of the following objects is not covered by Time Travel?
- A. Tables
- B. Stages
- C. Schemas
- D. Databases
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html
NEW QUESTION # 17
How would you execute a series of SQL statements using Task?
- A. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():
- B. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..
INSERT INTO target2 SELECT .. FROM stream .s1 where .. - C. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.
- D. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);
Answer: A
NEW QUESTION # 18
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Explanation
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 19
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
- A. COPY
- B. INSERT
- C. GET
- D. PUT
Answer: A
NEW QUESTION # 20
Which stage type can be altered and dropped?
- A. User stage
- B. Database stage
- C. Table stage
- D. External stage
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages
NEW QUESTION # 21
Which type of table corresponds to a single Snowflake session?
- A. Transient
- B. Permanent
- C. Temporary
- D. Provisional
Answer: C
NEW QUESTION # 22
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?
- A. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
- B. Use auto-ingest Snowpipes to load large files in a serverless model.
- C. Produce the largest files possible, reducing the overall number of files to process.
- D. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
Answer: C
NEW QUESTION # 23
A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).
- A. Submit listings for approval/publishing.
- B. Modify incoming listing access requests.
- C. Delete provider profiles.
- D. Modify listings properties.
- E. Rename listings.
Answer: A,D
NEW QUESTION # 24
Which of the following are options when creating a virtual Warehouse?
Choose 2 answers
- A. Auto-drop
- B. Auto resize
- C. Auto-resume
- D. Auto-suspend
Answer: C,D
NEW QUESTION # 25
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
- A. IBM Cloud
- B. Oracle Cloud
- C. Microsoft Azure Cloud
- D. Amazon Web Services
- E. Docker
- F. Google Cloud Platform
Answer: C,E,F
NEW QUESTION # 26
Which of the following statements is true of data loading?
Select one.
- A. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
- B. The "deal file size for loading is 16MB to match micro-partition size
- C. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
Answer: C
NEW QUESTION # 27
True or False: You can define multiple columns within a clustering key on a table.
- A. True
- B. False
Answer: A
NEW QUESTION # 28
Snowflake is designed for which type of workloads? (Choose two.)
- A. On-premise workloads
- B. Concurrent workloads
- C. OLAP (Analytics) workloads
- D. OLTP (Transactional) workloads
Answer: B,C
Explanation:
Reference: https://blog.couchbase.com/its-the-workload-stupid/
https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing
NEW QUESTION # 29
As a best practice, clustering keys should only be defined on tables of which minimum size?
- A. Multi-Terabyte (TB) Range
- B. Multi-Gigabyte (GB) Range
- C. Multi-Kilobyte (KB) Range
- D. Multi-Megabyte (MB) Range
Answer: A
NEW QUESTION # 30
Which data type can be used to store geospatial data in Snowflake?
- A. Variant
- B. Geography
- C. Object
- D. Geometry
Answer: B
Explanation:
https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point
NEW QUESTION # 31
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A. True
- B. False
Answer: B
Explanation:
Explanation
A reader account can only consume data from the provider account that created it.
NEW QUESTION # 32
The fail-safe retention period is how many days?
- A. 7 days
- B. 1 day
- C. 90 days
- D. 45 days
Answer: A
NEW QUESTION # 33
What can be used to view warehouse usage over time? (Select Two).
- A. The billing and usage tab in the Snowflake web Ul
- B. The WAREHOUSE_METERING__HISTORY View
- C. The Query history view
- D. The show warehouses command
- E. The load HISTORY view
Answer: A,B
NEW QUESTION # 34
What feature can be used to reorganize a very large table on one or more columns?
- A. Micro-partitions
- B. Clustered partitions
- C. Key partitions
- D. Clustering keys
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
NEW QUESTION # 35
Which of the following commands cannot be used within a reader account?
- A. DROP ROLE
- B. SHOW SCHEMAS
- C. DESCRBE TABLE
- D. ALTER WAREHOUSE
- E. CREATE SHARE
Answer: D
Explanation:
A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.
NEW QUESTION # 36
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
- A. Query execution
- B. Authentication and access control
- C. Security
- D. Data loading
- E. Time Travel data
Answer: C,D
NEW QUESTION # 37
......
SnowPro-Core PDF Dumps Are Helpful To produce Your Dreams Correct QA's: https://pass4lead.newpassleader.com/Snowflake/SnowPro-Core-exam-preparation-materials.html