• support@dumpspool.com
SPECIAL LIMITED TIME DISCOUNT OFFER. USE DISCOUNT CODE TO GET 20% OFF DP2021

PDF Only

$35.00 Free Updates Upto 90 Days

  • SnowPro-Core Dumps PDF
  • 427 Questions
  • Updated On April 08, 2024

PDF + Test Engine

$60.00 Free Updates Upto 90 Days

  • SnowPro-Core Question Answers
  • 427 Questions
  • Updated On April 08, 2024

Test Engine

$50.00 Free Updates Upto 90 Days

  • SnowPro-Core Practice Questions
  • 427 Questions
  • Updated On April 08, 2024
Check Our Free Snowflake SnowPro-Core Online Test Engine Demo.

How to pass Snowflake SnowPro-Core exam with the help of dumps?

DumpsPool provides you the finest quality resources you’ve been looking for to no avail. So, it's due time you stop stressing and get ready for the exam. Our Online Test Engine provides you with the guidance you need to pass the certification exam. We guarantee top-grade results because we know we’ve covered each topic in a precise and understandable manner. Our expert team prepared the latest Snowflake SnowPro-Core Dumps to satisfy your need for training. Plus, they are in two different formats: Dumps PDF and Online Test Engine.

How Do I Know Snowflake SnowPro-Core Dumps are Worth it?

Did we mention our latest SnowPro-Core Dumps PDF is also available as Online Test Engine? And that’s just the point where things start to take root. Of all the amazing features you are offered here at DumpsPool, the money-back guarantee has to be the best one. Now that you know you don’t have to worry about the payments. Let us explore all other reasons you would want to buy from us. Other than affordable Real Exam Dumps, you are offered three-month free updates.

You can easily scroll through our large catalog of certification exams. And, pick any exam to start your training. That’s right, DumpsPool isn’t limited to just Snowflake Exams. We trust our customers need the support of an authentic and reliable resource. So, we made sure there is never any outdated content in our study resources. Our expert team makes sure everything is up to the mark by keeping an eye on every single update. Our main concern and focus are that you understand the real exam format. So, you can pass the exam in an easier way!

IT Students Are Using our SnowPro Core Certification Exam Dumps Worldwide!

It is a well-established fact that certification exams can’t be conquered without some help from experts. The point of using SnowPro Core Certification Exam Practice Question Answers is exactly that. You are constantly surrounded by IT experts who’ve been through you are about to and know better. The 24/7 customer service of DumpsPool ensures you are in touch with these experts whenever needed. Our 100% success rate and validity around the world, make us the most trusted resource candidates use. The updated Dumps PDF helps you pass the exam on the first attempt. And, with the money-back guarantee, you feel safe buying from us. You can claim your return on not passing the exam.

How to Get SnowPro-Core Real Exam Dumps?

Getting access to the real exam dumps is as easy as pressing a button, literally! There are various resources available online, but the majority of them sell scams or copied content. So, if you are going to attempt the SnowPro-Core exam, you need to be sure you are buying the right kind of Dumps. All the Dumps PDF available on DumpsPool are as unique and the latest as they can be. Plus, our Practice Question Answers are tested and approved by professionals. Making it the top authentic resource available on the internet. Our expert has made sure the Online Test Engine is free from outdated & fake content, repeated questions, and false plus indefinite information, etc. We make every penny count, and you leave our platform fully satisfied!

Snowflake SnowPro-Core Sample Question Answers

Question # 1

Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers

A. SnowSQL 
B. ODBC 
C. R 
D. HIVE 

Question # 2

Which of the following roles is recommended to be used to create and manage users and roles?

A. SYSADMIN 
B. SECURITYADMIN 
C. PUBLIC 
D. ACCOUNTADMIN 

Question # 3

What is the recommended method for loading data into Snowflake?

A. Load row by row 
B. Load data in batch 
C. Load data by writing it In the Snowflake Web Interface (UI) 
D. Load data via frequent, angle row DML's 

Question # 4

What is the recommended Snowflake data type to store semi-structured data like JSON?

A. VARCHAR 
B. RAW 
C. LOB 
D. VARIANT 

Question # 5

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A. Custom 
B. Economy 
C. Optimized 
D. Standard 

Question # 6

True or False: Once created, a micro-partition will never be changed.

A. True 
B. False 

Question # 7

True or False: Snowpipe via RFST API can only reference External Stages as source.

A. True 
B. False 

Question # 8

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred? Select one.

A. 1 Hour 
B. 3 Hours 
C. 12 hours 
D. 24 hours 

Question # 9

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

A. The tables are now orphaned 
B. The user that deleted the role 
C. SYSADMIN 
D. The assumed role that dropped the role 

Question # 10

Which of the following statements are true of Snowflake releases: (Choose two.)

A. They happen approximately weekly 
B. They roll up and release approximately monthly, but customers can request early release application 
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 

Question # 11

Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

A. Micro-partitions 
B. Clustering keys 
C. Key partitions 
D. Clustered partitions 

Question # 12

Select the different types of Internal Stages: (Choose three.)

A. Named Stage 
B. User Stage 
C. Table Stage 
D. Schema Stage 

Question # 13

Which of the following statement is true of Snowflake? Select one.

A. It was built specifically for the cloud 
B. it was built as an on-premises solution and then potted to the cloud 
C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud 
D. It was built for Hadoop architecture 
E. It's based on an Oracle Architecture 

Question # 14

True or False: Snowflake charges additional fees to Data providers for each share they create.

A. True 
B. False 

Question # 15

When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

A. When users will be using compute at different times throughout a 24/7 period 
B. When managing a steady workload 
C. When the compute must be available with no delay or lag time 
D. When you don’t want to have to manually turn on the Warehouse each time a user needs it 

Question # 16

What is the most granular object that the Time Travel retention can be defined on? Select one.

A. Account 
B. Database 
C. Schema 
D. Table 

Question # 17

True or false: it is best practice to define a clustering key on every table.

A. True 
B. False 

Question # 18

What is the maximum compressed row size in Snowflake?

A. 8KB 
B. 16MB 
C. 50MB 
D. 4000GB 

Question # 19

What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

A. Installing and configuring hardware 
B. Patching software 
C. Physical security 
D. Maintaining metadata and statists 

Question # 20

True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

A. True 
B. False 

Question # 21

True or False: Pipes can be suspended and resumed.

A. True 
B. False 

Question # 22

On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers

A. Amazon Web Services 
B. Private Virtual Cloud 
C. Oracle Cloud 
D. Microsoft Azure Cloud 

Question # 23

Which of the following statements about data sharing are true? choose 2 answers

A. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts 
B. All database objects can be included In a shared database 
C. Reader Accounts are created and funded by Data Prowlers 
D. Shared databases are read-only 

Question # 24

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement? Select one.

A. INITTIALLY_SUSPENDED = TRUE/FALSE 
B. START_AFTCR_CREATE = TRUE/FALSE 
C. START_TTIME = 60 // (seconds from now) 
D. START.TIME = CURRENT.DATE() 

Question # 25

Which of the following statements would be used to export/unload data from Snowflake?

A. COPY INTO @slage 
B. EXPORT TO @stage 
C. INSERT INTO @stage 
D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1); 

Question # 26

True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

A. True 
B. False 

Question # 27

Select the three types of tables that exist within Snowflake. Choose 3 answers

A. Temporary 
B. Transient 
C. Provisioned 
D. Permanent 

Question # 28

What is the lowest Snowflake edition that offers Time Travel up to 90 days.

A. standard Edition 
B. Premier Edition 
C. Enterprise Edition 
D. Business Critical Edition 

Question # 29

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

A. True 
B. False 

Question # 30

Which type of table corresponds to a single Snowflake session?

A. Temporary 
B. Translent 
C. Provisional 
D. Permanent 

Question # 31

True or False: Users are able to see the result sets of queries executed by other users that share their same role.

A. True 
B. False 

Question # 32

True or False: You can resize a Virtual Warehouse while queries are running.

A. True 
B. False 

Question # 33

Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

A. SHOW TABLES; 
B. SHOW STORAGE BY TABLE; 
C. Information Schema -> TABLE_STORAGE_METRICS 
D. Information Schema -> TASLE_HISTORY 

Question # 34

A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

A. The primary duster in the virtual warehouse 
B. The entire Virtual Warehouse 
C. The database the Virtual Warehouse resides in 
D. The queries currently being run by the Virtual Warehouse 

Question # 35

True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.

A. True 
B. false: 

Question # 36

True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

A. True 
B. False 

Question # 37

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

A. JDBC 
B. SnowSQL 
C. Snowflake Web Interface (UI) 
D. ODBC 
E. Python 
F.18912E1457D5D1DDCBD40AB3BF70D5D 

Question # 38

Which statement best describes Snowflake tables?

A. Snowflake tables are logical representations of underlying physical data 
B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake
C. Snowflake tables require that clustering keys be defined to perform optimally 
D. Snowflake tables are owned by a user 

Question # 39

As a best practice, clustering keys should only be defined on tables of which minimum size?

A. Multi-Kilobyte (KB) Range 
B. Multi-Megabyte (MB) Range 
C. Multi-Gigabyte (GB) Range 
D. Multi-Terabyte (TB) Range 

Question # 40

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

A. True 
B. False 

Question # 41

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? Select one.

A. More micro-partitions 
B. Better query scheduling 
C. Double the numbers of servers In the compute duster 
D. Higher storage costs 

Question # 42

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

A. True 
B. False 

Question # 43

What happens when a Data Provider revokes privileges to a Share on an object in their source database?

A. The object immediately becomes unavailable for all Data Consumers 
B. Any additional data arriving after this point in time will not be visible to Data Consumers 
C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object 
D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts 

Question # 44

Which of the following terms best describes Snowflake’s database architecture?

A. Columnar shared nothing 
B. Shared disk 
C. Multi-cluster, shared data
D. Cloud-native shared memory 

Question # 45

What is the minimum duration charged when starting a virtual warehouse?

A. 1 second 
B. 1 minute 
C. 1 hour 
D. 1 day 

Question # 46

True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.

A. True 
B. False 

Question # 47

Which of the following commands sets the Virtual Warehouse for a session?

A. COPT WAREHOUSE FROM <<Config file> ; 
B. SET warehouse = <<warehouse name>>; 
C. USE WAREHOUSE <<warehouse name>>; 
D. USE VIRTUAL_WAREHOUSE <<warehouse name>>; 

Question # 48

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 

Question # 49

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 

Question # 50

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 explicitlygranted by supported.

A. True 
B. False 

Question # 51

Which of the following statements are true of Snowflake data loading? Choose 3 answers

A. VARIANT "nut" values are not the same as SQL Null values 
B. It is recommended to do frequent, single row DMLS 
C. It is recommended to validate the data before loading into the Snowflake target table 
D. It is recommended to use staging tables to manage MERGE statements 

Question # 52

True or False: You can define multiple columns within a clustering key on a table.

A. True 
B. False 

Question # 53

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? Choose 2 answers

A. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period 
B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period 
C. 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 
D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed 

Question # 54

True or False: A single database can exist in more than one Snowflake account.

A. True 
B. False 

Question # 55

What is the minimum Snowflake edition that provides data sharing?

A. Standard 
B. Premier 
C. Enterprise 
D. Business Critical Edition 

Question # 56

True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

A. True 
B. False 

Question # 57

Which interfaces can be used to create and/or manage Virtual Warehouses?

A. The Snowflake Web Interface (UI) 
B. SQL commands 
C. Data integration tools 
D. All of the above 

Question # 58

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communicationwith Snowflake Support to help troubleshoot issues.

A. True 
B. False 

Question # 59

Which of the following objects is not covered by Time Travel?

A. Tables 
B. Schemas 
C. Databases 
D. Stages 

Question # 60

Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

A. Scaling rhythmically 
B. Scaling max
C. Scaling out 
D. Scaling up 

Question # 61

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

A. Number of users 
B. Warehouse size 
C. Amount of data processed 
D. # of clusters for the Warehouse 

Question # 62

Which of the following statements is true of zero-copy cloning?

A. Zero-copy clones objects inherit 
B. All zero-copy clone objects inherit the privileges of their original objects 
C. Zero-copy coning is licensed as an additional Snowflake feature 
D. At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared. 

Question # 63

Which of the following commands are not blocking operations? Choose 2 answers

A. UPDATE
B. INSERT 
C. MERGE 
D. COPY 

Question # 64

What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

A. On-premise availability 
B. Simplicity 
C. Open source based 
D. Concurrency 
E. Performance 

Question # 65

Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Choose 2 answers

A. Java 
B. JavaScript 
C. SQL 
D. Python 

Question # 66

Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers

A. Temporary Tables 
B. Transient Tables 
C. Provisional Tables 
D. Permanent Tables 

Question # 67

Fail-safe is unavailable on which table types?

A. Temporary 
B. Transient 
C. Provisional 
D. Permanent 

Question # 68

Which of the following is true of Snowpipe via REST API? Choose 2 answers

A. you can only use it on internal Stages 
B. All COPY INTO options are available fluting pipe creation 
C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands 
D. Snowpipe keeps track of which files it has loaded 

Question # 69

Which of the following statements is true of Snowflake micro-partitioning?

A. Micro-partitioning has been known to introduce data skew 
B. Micro-partitioning: requires a partitioning schema to be defined up front 
C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded 
D. Micro-partitioning can be disabled within a Snowflake account 

Question # 70

True or False: It is possible to load data into Snowflake without creating a named File Format object.

A. True 
B. False 

Question # 71

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 

Question # 72

Which statement best describes '' clustering''?

A. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions 
B. The database administrator must define the clustering methodology for each Snowflake table. 
C. The clustering key must be included on the COPV command when loading data into Snowflake. 
D. Clustering can be disabled within a Snowflake account. 

Question # 73

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

A. 60 minutes 
B. 24 hours 
C. 14 days 
D. 30 days 
E. 1 year 

Question # 74

How many shares can be consumed by single Data Consumer?

A. 1 
B. 10 
C. 100, but can be increased by contacting support 
D. Unlimited 

Question # 75

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 

Question # 76

What are the three layers that make up Snowflake’s architecture? Choose 3 answer

A. Compute 
B. Tri-Secret Secure 
C. Storage 
D. Cloud Services 

Question # 77

Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA): Select one:

A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN 
B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN 
C. SECURITYADMIN, ACCOUNTADMIN 
D. ACCOUNTADMIN 

Question # 78

What privileges are required to execute a task?

A. To execute a task, you need the EXECUTE TASK. 
B. A task is an account-level object and can only be executed by the Account Admin role. 
C. Tasks run automatically and do run under any rote. 
D. Tasks are stored in a special database called the utility database and require EXECUTETASK privilege in the utility database. 

Question # 79

Which of the following items does the Cloud services Layer manage? Choose 4 answers

A. user authentication 
B. Metadata 
C. Query compilation and optimization 
D. external blob storage 
E. Data security 

Question # 80

True or False the longer the data retention period, the higher the resulting storage costs.

A. True 
B. False 

Question # 81

Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy? Select one.

A. Account -> Schema -> Database -> Table 
B. Account -> Database -> Schema -> Table 
C. Database -> Schema -> Table -> Account 
D. Database -> Table -> Schema -> Account 

Question # 82

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 

Question # 83

How would you execute a series of SQL statements using Task?

A. 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 .. 
B. 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); 
C. 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(): 
D. 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. 

Question # 84

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

A. To accommodate more queries 
B. To accommodate more users 
C. To accommodate fluctuations in workload 
D. To accommodate a more complex workload 

Question # 85

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

A. Customers can change the size of the Warehouse after creation 
B. A Warehouse can be resized while running 
C. A Warehouse can be configured to suspend after a period of inactivity 
D. A Warehouse can be configured to auto-resume when new queries are submitted