Reading SnowPro Core Exam Questions Helps You Prepare Well

Regina2021-09-22T02:54:55+00:00

By Regina Free Questions Online, Snowflake SnowPro Core, SnowPro Core demo, SnowPro Core exam questions, SnowPro Core free questions, SnowPro Core questions

How to prepare for SnowPro Core certification exam well and pass successfully? Real SnowPro Core exam requires candidates to answer 100 Multiple-Choice questions and True/False items, according to the SnowPro Core exam knowledge points of Snowflake, the Data Platform, we have collected 162 practice exam questions to help you prepare for SnowPro Core Certification Exam well. Reading SnowPro Core exam questions with ITExamShop pdf file can help you more in actual exam. We offer the actual SnowPro Core exam questions with 100% passing guarantee.

Before reading the full version, you can check SnowPro Core free questions as the demo below:

Page 1 of 4

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

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

Named Stage

User Stage

Table Stage

Schema Stage

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

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

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

True

False

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

True

False

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

True

False

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

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

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

Page 2 of 4

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

standard Edition

Premier Edition

Enterprise Edition

Business Critical Edition

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

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

True

False

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

Choose 3 answers

Temporary

Transient

Provisioned

Permanent

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

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

Custom

Economy

Optimized

Standard

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

True

False

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

True

False

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

True

False

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

Page 3 of 4

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

True

False

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

23. Snowflake is designed for which type of workloads? (Choose two.)

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

24. How many shares can be consumed by single Data Consumer?

100, but can be increased by contacting support

Unlimited

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

8KB

16MB

50MB

4000GB

26. True or False: During data unloading, only JSON and CSV files can be compressed.

True

False

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

Micro-partitioning has been known to introduce data skew

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Micro-partitioning can be disabled within a Snowflake account

28. Which of the following are options when creating a virtual Warehouse? Choose 2 answers

Auto-drop

Auto resize

Auto-resume

Auto-suspend

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

True

False

30. How a Snowpipe charges calculated?

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

Page 4 of 4

31. When can a Virtual Warehouse start running queries?

12am-5am

Only during administrator defined time slots

When its provisioning is complete

After replication

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

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

Joins

Fitters

Data type conversions

Column reordering

Aggregates

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

35. True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

True

False

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

True

False

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

1 Hour

3 Hours

12 hours

24 hours

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

Delimited (CSV, TSV, etc.)

Avro

JSON

ORC

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

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

Welcome To Choose Required IT Certification Exams Online

Reading SnowPro Core Exam Questions Helps You Prepare Well

Before reading the full version, you can check SnowPro Core free questions as the demo below:

Author