2021 New Updated SnowPro Core Exam Dumps Questions

dumps2021-09-28T07:15:59+08:00

SnowPro Core exam is a hot one of Snowflake certification tests. The new updated SnowPro Core exam dumps questions can make sure you pass the test easily. SnowPro Core exam is designed for you to test the knowledge of Snowflake, the Data Platform. Free Snowflake SnowPro Core exam updated dumps questions are available below.

Page 1 of 4

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

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

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

True

False

3. When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Concurrency

Performance

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

The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period

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

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

The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed

5. True or False: You can query the files in an External Stage directly without having to load the data into a table.

True

False

6. How would you determine the size of the virtual warehouse used for a task?

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

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

8. Which of the following best describes where Snowflake’s metadata is stored?

Within the data files

Inside the Virtual Warehouses

In the Cloud Services Layer

within the drivers

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

Tables

Named File Formats

Schemas

Databases

Users

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

True

False

11. What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Via the Snowflake Web Interface (Ul)

Via the data_share=true parameter

Via SQL commands

Via Virtual Warehouses

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

True

False

13. What privileges are required to create a task?

The global privilege create task is required to create a new task.

Tasks are created at the Application level and can only be created by the Account Admin role.

Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

The role must have access to the target schema and the create task privilege on the schema itself.

14. True or False: A Virtual Warehouse can be resized while suspended.

True

False

15. True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

True

False

16. True or False: Snowflake supports federated authentication in all editions.

True

False

17. What is the default File Format used in the COPY command if one is not specified?

JSON

Parquet

XML

18. True or False: Fail-safe can be disabled within a Snowflake account.

True

False

19. What is the minimum Snowflake edition that provides data sharing?

Standard

Premier

Enterprise

Business Critical Edition

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

Page 2 of 4

21. Snowflake provides a mechanism for its customers to override its clustering algorithms.

This method is:

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

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

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

True

False

24. True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

True

False

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

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

128

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

Auto-suspend

Auto-resume

Local SSD size

User count

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

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

Account usage Tracking

Resource Monitor

Warehouse Limit Parameter

Credit Consumption Tracker

30. Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)

Choose 2 answers

SnowSQL

ODBC

HIVE

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

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

Columnar shared nothing

Shared disk

Multi-cluster, shared data

Cloud-native shared memory

33. True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

True

False

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

Concurrency

Performance

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

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

60 minutes

24 hours

14 days

30 days

1 year

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

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

39. True or False: An active warehouse is required to run a COPY INTO statement.

True

False

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

Page 3 of 4

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

The tables are now orphaned

The user that deleted the role

SYSADMIN

The assumed role that dropped the role

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

True

False

43. When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.

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

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

Named Stage

User Stage

Table Stage

Schema Stage

45. Which statement best describes Snowflake tables?

Snowflake tables are logical representations of underlying physical data

Snowflake tables ate the physical instantiation of data loaded Into Snowflake

Snowflake tables require that clustering keys be defined to perform optimally

Snowflake tables are owned by a user

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

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

True

False

48. True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

True

False

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

True

False

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

New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts

All database objects can be included In a shared database

Reader Accounts are created and funded by Data Prowlers

Shared databases are read-only

51. Which of the following statements is true of Snowflake?

It was built specifically for the cloud

It was built as an on-premises solution and then ported to the cloud

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

It was built for Hadoop architecture

It's based on an Oracle Architecture

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

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

standard Edition

Premier Edition

Enterprise Edition

Business Critical Edition

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

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

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

True

False

56. Select the three types of tables that exist within Snowflake.

Choose 3 answers

Temporary

Transient

Provisioned

Permanent

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

SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

SECURITYADMIN ACCOUNTADMIN, SYSADMIN

SECURITYADMIN, ACCOUNTADMIN

ACCOUNTADMIN

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

Custom

Economy

Optimized

Standard

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

True

False

60. True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

True

False

Page 4 of 4

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

True

False

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

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

True

False

64. Which statement best describes '' clustering''?

Clustering represents the way data is grouped together and stored within snowflake's micro-partitions

The database administrator must define the clustering methodology for each Snowflake table.

The clustering key must be included on the COPV command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

2021 New Updated SnowPro Core Exam Dumps Questions

2021 New Updated SnowPro Core Exam Dumps Questions

Share this post

Leave a Reply Cancel reply

Related Posts

Actual Questions for Snowflake SnowPro Advanced Architect Exam

New SnowPro Core Certification Exam COF-C02 Study Materials

Snowflake SnowPro Advanced Architect ARA-C01 Exam Questions

SnowPro Advanced Administrator ADA-C01 Exam Free Dumps

DSA-C02 SnowPro Advanced: Data Scientist Certification Exam Dumps

SnowPro Advanced Data Engineer Certification DEA-C01 Exam Questions

ARA-R01 SnowPro Advanced: Architect Recertification Exam Dumps