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 8

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

True

False

2. Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

Their default role should be set to SYSTEMADMIN (the lower of the two)

They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so

They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

They should use the SYSADMIN role to perform administrative work on database objects

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

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

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

True

False

6. If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium

Warehouse?

128

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

Scaling rhythmically

Scaling max

Scaling out

Scaling Up

8. What command is used to load files into an Internal Stage within Snowflake? Select one.

PUT

COPY INTO

TRANSFER

INSERT

9. When loading data into Snowflake, the COPY command supports: Choose 2 answers

Joins

Fitters

Data type conversions

Column reordering

Aggregates

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

Database

Tables

Warehouses

Worksheets

Page 2 of 8

11. Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Is available to all Snowflake Editions

Is only available to customers with Business Critical Edition

Restricts or enables access to specific IP addresses

Is activated using an “ALTER DATABASE” command

12. Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

MIN(< < column value>>)

COPY

SUM(<< column value >>)

UPDATE

13. When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

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

True

False

15. Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

16. Which are true of Snowflake roles?

All grants to objects are given to roles, and never to users

In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation

The public role controls at other roles

Roles are a subset of users and users own objects In Snowflake

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

Select one.

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.

18. To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Configure the Maximum Clusters setting to “Auto-Scale”

Set the Warehouse type to “Auto”

Set the Minimum Clusters and Maximum Clusters settings to the same value

Set the Minimum Clusters and Maximum Clusters settings to the different values

19. True or False: Snowflake charges a premium for storing semi-structured data.

True

False

20. Which object allows you to limit the number of credits consumed within a Snowflake account?

Select one.

Account usage Tracking

Resource Monitor

Warehouse Limit Parameter

Credit Consumption Tracker

Page 3 of 8

21. True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

True

False

22. Which statements are true of micro-partitions? Choose 2 answers

They are approximately 16MB in size

They are stored compressed only if COMPRESS=TRUE on Table

They are Immutable

They are only encrypted in the Enterprise edition and above

23. True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

True

False

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

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

True

False

26. Which item in the Data Warehouse migration process does not apply in Snowflake>

Migrate Users

Migrate Schemas

Migrate Indexes

Build the Data pipeline

27. When can a Virtual Warehouse start running queries?

12am-5am

Only during administrator defined time slots

When its provisioning is complete

After replication

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

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

Concurrency

Performance

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

Page 4 of 8

31. Account-level storage usage can be monitored via:

The snowflake wet Interface (UI) in the Databases section.

The Snowflake web interface (UI) in the Account -> Billing a usage section

The Information Schema -> ACCOUNT_USAGE_HISTORY View

The Account usage Schema - > ACCOUNT_USAGE_METRICS View

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

True

False

33. Which formats are supported for unloading data from Snowflake? Choose 2 answers

Delimited (CSV, TSV, etc.)

Avro

ISON

ORC

34. The PUT command: (Choose two.)

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

35. Which of the following objects can be cloned? (Choose four.)

Tables

Named File Formats

Schemas

Databases

Users

36. If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

All Snowflake sessions using the warehouse are terminated.

The last query using the warehouse completes.

There are no users loaned into Snowflake.

The Warehouse is inactive for a specified period of time.

37. True or False: The COPY command must specify a File Format in order to execute.

True

False

38. Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A multi-cluster Warehouse can add clusters automatically based on query activity

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

A multi-cluster Warehouse can scale down when query activity slows

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

39. True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

True

False

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

Auto-suspend

Auto-resume

Local SSD size

User count

Page 5 of 8

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

True

False

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

True

False

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

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

45. 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:

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

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

True

False

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

True

False

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

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

True

False

Page 6 of 8

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

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

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

8KB

16MB

50MB

4000GB

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

Storage Layer

Compute Layer

Database Layer

Cloud Service Layer

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

True

False

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

Java

JavaScript

SQL

Python

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

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

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

Concurrency

Performance

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

Database

Tables

Warehouses

Worksheets

Page 7 of 8

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

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

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

Temporary

Translent

Provisional

Permanent

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

Temporary

Translent

Provisional

Permanent

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

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

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

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

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

True

False

70. 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 8 of 8

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

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

Scaling rhythmically

Scaling max

Scaling out

Scaling Up

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

SnowSQL

ODBC

HIVE

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

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

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

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

Auto-suspend

Auto-resume

Local SSD size

User count

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

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

True

False

80. 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 132 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 132 Q&As

Leave a Reply Cancel reply