[Q45-Q68] Best Quality SnowPro-Core Exam Questions Snowflake Test To Gain Brilliante Result!

4.5/5 - (2 votes)

Best Quality SnowPro-Core Exam Questions Snowflake Test To Gain Brilliante Result!

Preparations of SnowPro-Core Exam 2023 SnowPro Core Unlimited 415 Questions

Q45. What is the minimum Snowflake edition required to use Dynamic Data Masking?

Standard

Enterprise

Business Critical

Virtual Private Snowflake (VPC)

Q46. What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Data is hashed by the cluster key to facilitate fast searches for common data values

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Smaller micro-partitions are created for common data values to allow for more parallelism

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

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

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

True

False

Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

Q49. Which of the following accurately describes shares?

Tables, secure views, and secure UDFs can be shared

Shares can be shared

Data consumers can clone a new table from a share

Access to a share cannot be revoked once granted

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

Q51. True or False: Data Providers can share data with only the Data Consumer.

True

False

Q52. In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Bytes scanned

Bytes sent over the network

Number of partitions scanned

Percentage scanned from cache

External bytes scanned

Q53. Network policies can be set at which Snowflake levels? (Choose two.)

Role

Schema

User

Database

Account

Tables

Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies

Q54. True or False: A single database can exist in more than one Snowflake account.

True

False

Explanation/Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

Q55. Which statement is true about running tasks in Snowflake?

A task can be called using a CALL statement to run a set of predefined SQL commands.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task allows a user to execute a set of SQL commands on a predefined schedule.

A task can be executed using a SELECT statement to run a predefined SQL command.

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

True

False

Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

Q57. Which statement MOST accurately describes clustering in Snowflake?

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

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

The clustering key must be included in the COPY command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

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

Custom

Economy

Optimized

Standard

Q59. Which cache type is used to cache data output from SQL queries?

Metadata cache

Result cache

Remote cache

Local file cache

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

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

Scaling rhythmically

Scaling max

Scaling out

Scaling Up

Q61. How would you execute a series of SQL statements using Task?

include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..
INSERT INTO target2 SELECT .. FROM stream .s1 where ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask…. AS call stored_prc1(); call stored_proc2t);

A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask…. AS call stored_proc_multiple_statements_inside():

Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

Q62. When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

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

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

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

Q64. Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Schemas

Roles

Secure Views

Stored Procedures

Tables

Secure User-Defined Functions (UDFs)

Q65. Which of the following statements is true of data loading?
Select one.

Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

The “deal file size for loading is 16MB to match micro-partition size

Marry files in the 10-lOOMB range tend to land In the ‘sweet spot” for load parallelism

Once loaded, there is no option to force a reload of an already loaded file

Q66. Which of the following significantly improves the performance of selective point lookup queries on a table?

Clustering

Materialized Views

Zero-copy Cloning

Search Optimization Service

Q67. Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Compute resources

Query execution

Authentication

Data storage

Metadata

Explanation
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.
Services managed in this layer include:
* Authentication
* Infrastructure management
* Metadata management
* Query parsing and optimization
* Access control

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

Loading …