Snowflake SnowPro-Core Exam Dumps

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 

Show Answer

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 

Show Answer

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 

Show Answer

Question # 4

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

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

Show Answer

Question # 5

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

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

Show Answer

Question # 6

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

A. True 
B. False 

Show Answer

Question # 7

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

A. True 
B. False 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

Question # 12

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

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

Show Answer

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 

Show Answer

Question # 14

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

A. True 
B. False 

Show Answer

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 

Show Answer

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 

Show Answer

Question # 17

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

A. True 
B. False 

Show Answer

Question # 18

What is the maximum compressed row size in Snowflake?

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

Show Answer

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 

Show Answer

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 

Show Answer

Question # 21

True or False: Pipes can be suspended and resumed.

A. True 
B. False 

Show Answer

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 

Show Answer

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 

Show Answer

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() 

Show Answer

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); 

Show Answer

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 

Show Answer

Question # 27

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

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

Show Answer

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 

Show Answer

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 

Show Answer

Question # 30

Which type of table corresponds to a single Snowflake session?

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

Show Answer

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 

Show Answer

Question # 32

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

A. True 
B. False 

Show Answer

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 

Show Answer

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 

Show Answer

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: 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

Question # 40

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

A. True 
B. False 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

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>>; 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

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 

Show Answer

Question # 52

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

A. True 
B. False 

Show Answer

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 

Show Answer

Question # 54

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

A. True 
B. False 

Show Answer

Question # 55

What is the minimum Snowflake edition that provides data sharing?

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

Show Answer

Question # 56

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

A. True 
B. False 

Show Answer

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 

Show Answer

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 

Show Answer

Question # 59

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

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

Show Answer

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 

Show Answer

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 

Show Answer