A Review Of 100% Guarantee SnowPro-Core Prep

NEW QUESTION 1

Which of the following are characteristics of security in Snowflake?

• A. Account and user authentication is only available with the Snowflake Business Critical edition.
• B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
• C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
• D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Answer: C

NEW QUESTION 2

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

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

NEW QUESTION 3

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

• A. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts
• B. All database objects can be included In a shared database
• C. Reader Accounts are created and funded by Data Prowlers
• D. Shared databases are read-only

Answer: CD

NEW QUESTION 4

Which command is used to unload data from a Snowflake table into a file in a stage?

• A. COPY INTO
• B. GET
• C. WRITE
• D. EXTRACT INTO

Answer: A

Explanation:
https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%2

NEW QUESTION 5

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

• A. Growth of storage and compute are tightly coupled together
• B. Storage expands without the requirement to add more compute
• C. Compute can be scaled up or down without the requirement to add more storage
• D. Multiple compute clusters can access stored data without contention

Answer: BCD

Explanation:
Reference:
https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt
separate-storage-and-compute-65d2dffd450f

NEW QUESTION 6

When should a multi-cluster warehouse be used in auto-scaling mode?

• A. When it is unknown how much compute power is needed
• B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
• C. If the runtime of the executed query is very slow
• D. When a large number of concurrent queries are run on the same warehouse

Answer: D

NEW QUESTION 7

Which minimum Snowflake edition allows for a dedicated metadata store?

• A. Standard
• B. Enterprise
• C. Business Critical
• D. Virtual Private Snowflake

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html

NEW QUESTION 8

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

• A. Compute resources
• B. Query execution
• C. Authentication
• D. Data storage
• E. Metadata

Answer: CE

NEW QUESTION 9

What feature can be used to reorganize a very large table on one or more columns?

• A. Micro-partitions
• B. Clustering keys
• C. Key partitions
• D. Clustered partitions

Answer: B

Explanation:
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

NEW QUESTION 10

True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

• A. True
• B. False

Answer: B

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

NEW QUESTION 11

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

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .

NEW QUESTION 12

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

• A. UPDATE TABLE FROM STREAM
• B. SELECT FROM STREAM
• C. INSERT INTO TABLE SELECT FROM STREAM
• D. ALTER TABLE AS SELECT FROM STREAM
• E. BEGIN COMMIT

Answer: CD

NEW QUESTION 13

Which are true of Snowflake roles?

• A. All grants to objects are given to roles, and never to users
• B. 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
• C. The public role controls at other roles
• D. Roles are a subset of users and users own objects In Snowflake

Answer: AB

NEW QUESTION 14

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

• A. CREATE_SHARE on the account
• B. SHARE on databases and schemas
• C. SELECT on tables used by the secure view
• D. REFERENCE_USAGE on databases

Answer: C

NEW QUESTION 15

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

• A. True
• B. False

Answer: B

Explanation:
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.

NEW QUESTION 16

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

• A. 1 Hour
• B. 3 Hours
• C. 12 hours
• D. 24 hours

Answer: D

Explanation:
Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

NEW QUESTION 17

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

• A. Scaling rhythmically
• B. Scaling max
• C. Scaling out
• D. Scaling Up

Answer: C

Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out
"Scale out by adding warehouses to a multi-cluster warehouse"

NEW QUESTION 18

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

NEW QUESTION 19

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

• A. No virtual warehouse will be used, data will be read from the result cache.
• B. No virtual warehouse will be used, data will be read from the local disk cache.
• C. The default virtual warehouse will be used to read all data.
• D. The virtual warehouse that is defined at the session level will be used to read all data.

Answer: A

NEW QUESTION 20
......