Snowflake SnowPro Core SnowPro Core Certification Exam Online Training

Passing Snowflake SnowPro Core exam can effectively help you entrench yourself and enhance your status in this competitive IT area. In our Exam4Training you can get the related Snowflake SnowPro Core SnowPro Core Certification Exam Online Training. Our Exam4Training IT experts team will timely provide you the accurate and detailed training materials about SnowPro Core Certification SnowPro Core exam. Through the Snowflake SnowPro Core SnowPro Core Certification Exam Online Training provided by Exam4Training, we can ensure you have a successful challenge when you are the first time to participate in the SnowPro Core Certification Exam exam.

Page 1 of 4

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

True

False

2. True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

True

False

3. Data storage for individual tables can be monitored using which commands and/or object(s)?

Choose 2 answers

SHOW TABLES;

SHOW STORAGE BY TABLE;

Information Schema -> TABLE_STORAGE_METRICS

Information Schema -> TASLE_HISTORY

4. When creating a user it is advisable sable to: Choose 2 answers

Set the user to be initially disabled

Force an immediate password change

Set a default role for the user

Set the number of minutes to unlock to 15 minutes

Set the users access to expire within a specified timeframe

5. 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.

True

false:

6. What is the recommended method for loading data into Snowflake?

Load row by row

Load data in batch

Load data by writing it In the Snowflake Web Interface (UI)

Load data via frequent, angle row DML's

7. True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

True

False

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

True

False

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

VARIANT "nut" values are not the same as SQL Null values

It is recommended to do frequent, single row DMLS

It is recommended to validate the data before loading into the Snowflake target table

It is recommended to use staging tables to manage MERGE statements

10. True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

True

False

Page 2 of 4

11. which of the following are valid approaches to loading data into a snowflake table? select

all the below that apply.

Bulk copy from an External Stage

Continuous load using Snowpipe REST API

The Snowflake Web Interface (UT) data loading wizard

Bulk copy from an Internal Stage

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

Multi-Kilobyte (KB) Range

Multi-Megabyte (MB) Range

Multi-Gigabyte (GB) Range

Multi-Terabyte (TB) Range

13. What is the maximum compressed row size in Snowflake?

8KB

16MB

50MB

4000GB

14. In which layer of its architecture does Snowflake store its metadata statistics?

Storage Layer

Compute Layer

Database Layer

Cloud Service Layer

15. True or False: All Snowflake table types include fail-safe storage.

True

False

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

Java

JavaScript

SQL

Python

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

The primary duster in the virtual warehouse

The entire Virtual Warehouse

The database the Virtual Warehouse resides in

The queries currently being run by the Virtual Warehouse

18. True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

True

False

19. When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

Concurrency

Performance

20. Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

Database

Tables

Warehouses

Worksheets

Page 3 of 4

21. The number of queries that a Warehouse can concurrently process is determined by: Choose 2 answers

The complexity of each query

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

The size of the data required for each query

The tool that s executing the query

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

The object immediately becomes unavailable for all Data Consumers

Any additional data arriving after this point in time will not be visible to Data Consumers

The Data Consumers stop seeing data updates and become responsible for storage charges for the object

A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

23. Which type of table corresponds to a single Snowflake session?

Temporary

Translent

Provisional

Permanent

24. Fail-safe is unavailable on which table types?

Temporary

Translent

Provisional

Permanent

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

Scaling rhythmically

Scaling max

Scaling out

Scaling up

26. Which of the following statements is true of data loading?

Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

The "deal file size for loading is 16MB to match micro-partition size

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

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

Amazon Web Services

Private Virtual Cloud

Oracle Cloud

Microsoft Azure Cloud

28. Which of the following are common use cases for zero-copy cloning? Choose 3 answers

Quick provisioning of Dev and Test/QA environments

Data backups

Point in time snapshots

Performance optimization

29. True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

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

Account -> Schema -> Database -> Table

Account -> Database -> Schema -> Table

Database -> Schema -> Table -> Account

Database -> Table -> Schema -> Account

Page 4 of 4

31. True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

True

False

32. Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Scaling rhythmically

Scaling max

Scaling out

Scaling Up

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

SnowSQL

ODBC

HIVE

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

user authentication

Metadata

Query compilation and optimization

external blob storage

Data security

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

More micro-partitions

Better query scheduling

Double the numbers of servers In the compute duster

Higher storage costs

36. For a multi-cluster Warehouse, the number of credits billed is calculated on:

The number of queries that ran using the Warehouse.

The size of the Warehouse and the number of clusters that ran within a given time period.

The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.

The number of users who accessed the Warehouse.

37. Which of the following are options when creating a Virtual Warehouse?

Auto-suspend

Auto-resume

Local SSD size

User count

38. The FLATEEN function is used to query which type of data in Snowflake?

Structured data

Semi-structured data

Both of the above

None of the above

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

True

False

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

Zero-copy clones objects inherit

All zero-copy clone objects inherit the privileges of their original objects

Zero-copy coning is licensed as an additional Snowflake feature

At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.

Latest SnowPro Core Dumps Valid Version with 100 Q&As

Latest And Valid Q&A | 90 Days Free Update | Once Fail, Full Refund

Get Valid SnowPro Core Exam

Latest SnowPro Core Dumps Valid Version with 100 Q&As

Leave a Reply Cancel reply