Snowflake SnowPro Core Certification Practice Exam

test2022-03-08T06:37:48+00:00

Snowflake SnowPro Core Certification demonstrates an individual’s knowledge to apply specific core expertise implementing and migrating to Snowflake. To get your desired SnowPro Core Certification, you must practice with SnowPro Core dumps. FreeTestShare is the only way to get you where you want to go. It enables you to study for the SnowPro Core exam using actual exam questions and pass the first test. Only a week of preparation is required to pass the SnowPro Core exam with flying colors.

This free practice test can now be used to assess your preparation.

Page 1 of 3

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

2. What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

INITTIALLY_SUSPENDED = TRUE/FALSE

START_AFTCR_CREATE = TRUE/FALSE

START_TTIME = 60 // (seconds from now)

STAR

TIME = CURREN

DATE()

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

4. Which of the following statement is true of Snowflake?

It was built specifically for the cloud

it was built as an on-premises solution and then potted 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

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

True

False

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

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

8. When a pipe is recreated using the CREATE on REPLAC 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

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

10. What privileges are required to execute a task?

To execute a task, you need the EXECUTE TAS

A task is an account-level object and can only be executed by the Account Admin role.

Tasks run automatically and do run under any rote.

Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

Page 2 of 3

11. When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

When users will be using compute at different times throughout a 24/7 period

When managing a steady workload

When the compute must be available with no delay or lag time

When you don’t want to have to manually turn on the Warehouse each time a user needs it

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

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

Standard

Premier

Enterprise

Business Critical Edition

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

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

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

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

True

False

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

Auto-drop

Auto resize

Auto-resume

Auto-suspend

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

True

False

20. What are the three layers that make up Snowflake’s architecture? Choose 3 answer

Compute

Tri-Secret Secure

Storage

Cloud Services

Page 3 of 3

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

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

Delimited (CSV, TSV, etc.)

Avro

ISON

ORC

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

True

False

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

True

False

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