Best Preparations of SnowPro-Core Exam 2022 SnowPro Core Unlimited 162 Questions [Q84-Q104]

admin SnowPro-Core Snowflake August 14, 2022

Rate this post

Best Preparations of SnowPro-Core Exam 2022 SnowPro Core Unlimited 162 Questions

Focus on SnowPro-Core All-in-One Exam Guide For Quick Preparation.

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

QUESTION 85
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

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

True

False

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

PUT

COPY INTO

TRANSFER

INSERT

Explanation
You must specify an internal stage in the when uploading files to Snowflake. You must specify the same stage in the COPY INTO <table> command when loading data into a table from the staged files.

QUESTION 88
The fail-safe retention period is how many days?

1 day

7 days

45 days

90 days

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

True

False

QUESTION 90
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

QUESTION 91
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

True

False

QUESTION 92
True or False: Snowflake charges additional fees to Data providers for each share they create.

True

False

QUESTION 93
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

QUESTION 94
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

Explanation/Reference: https://docs.snowflake.com/en/user-guide/resource-monitors.html

QUESTION 95
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

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

True

False

QUESTION 97
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

QUESTION 98
Which of the following statements would be used to export/unload data from Snowflake?

COPY INTO @stage

EXPORT TO @stage

INSERT INTO @stage

EXPORT_TO_STAGE(stage = > @Wage, select = > ‘select * from t1);

QUESTION 99
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

True

False

Explanation
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

QUESTION 100
True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

True

False

QUESTION 101
Fail-safe is unavailable on which table types?

Temporary

Translent

Provisional

Permanent

QUESTION 102
Which of the following are options when creating a Virtual Warehouse?

Auto-suspend

Auto-resume

Local SSD size

User count

QUESTION 103
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

QUESTION 104
Which type of table corresponds to a single Snowflake session?

Temporary

Translent

Provisional

Permanent

Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.

Loading …