SnowPro-Core Tested & Approved SnowPro Core Study Materials
Validate your Skills with Updated SnowPro Core Exam Questions & Answers and Test Engine
The SnowPro-Core certification exam is divided into three basic categories: fundamentals, core concepts, and popular use cases. At the fundamental level, learners get to understand the fundamental concepts of Snowflake’s architecture, the Snowflake account, users, and databases. They also learn how to use SnowSQL, which is an essential tool for querying data.
NEW QUESTION # 83
Which of the following DML commands isn't supported by Snowflake?
- A. MERGE
- B. TRUNCATE TABLE
- C. UPSERT
- D. UPDATE
Answer: C
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html
NEW QUESTION # 84
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A. Set the Minimum Clusters and Maximum Clusters settings to the same value
- B. Set the Warehouse type to "Auto"
- C. Configure the Maximum Clusters setting to "Auto-Scale"
- D. Set the Minimum Clusters and Maximum Clusters settings to the different values
Answer: D
Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse
NEW QUESTION # 85
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.
- A. false
- B. True
Answer: A
NEW QUESTION # 86
True or False: All Snowflake table types include fail-safe storage.
- A. True
- B. False
Answer: B
NEW QUESTION # 87
What are supported file formats for unloading data from Snowflake? (Choose three.)
- A. CSV
- B. Parquet
- C. XML
- D. ORC
- E. AVRO
- F. JSON
Answer: A,B,F
NEW QUESTION # 88
How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
- A. Enable Time Travel.
- B. Index a table.
- C. Enable the search optimization service.
- D. Create a view.
- E. Cluster a table.
Answer: C,E
NEW QUESTION # 89
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. True
- B. False
Answer: B
Explanation:
Explanation
"The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."
NEW QUESTION # 90
Which of the following significantly improves the performance of selective point lookup queries on a table?
- A. Search Optimization Service
- B. Zero-copy Cloning
- C. Clustering
- D. Materialized Views
Answer: C
NEW QUESTION # 91
What can be used to view warehouse usage over time? (Select Two).
- A. The load HISTORY view
- B. The Query history view
- C. The WAREHOUSE_METERING__HISTORY View
- D. The show warehouses command
- E. The billing and usage tab in the Snowflake web Ul
Answer: C,E
NEW QUESTION # 92
What privileges are required to create a task?
- A. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
- B. Tasks are created at the Application level and can only be created by the Account Admin role.
- C. The role must have access to the target schema and the create task privilege on the schema itself.
- D. The global privilege create task is required to create a new task.
Answer: D
NEW QUESTION # 93
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate fluctuations in workload
- B. To accommodate more queries
- C. To accommodate a more complex workload
- D. To accommodate more users
Answer: B
NEW QUESTION # 94
How can a user change which columns are referenced in a view?
- A. Use the ALTER VIEW command to update the view
- B. Materialize the view to perform the changes
- C. Modify the columns in the underlying table
- D. Recreate the view with the required changes
Answer: A
NEW QUESTION # 95
When unloading to a stage, which of the following is a recommended practice or approach?
- A. Set SINGLE: = true for larger files
- B. Define an individual file format
- C. Avoid the use of the CAST function
- D. Use OBJECT_CONSTRUCT ( * ) when using Parquet
Answer: C
NEW QUESTION # 96
True or False: The COPY command must specify a File Format in order to execute.
- A. True
- B. False
Answer: A
Explanation:
Explanation/Reference: https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-into-snowflake/
NEW QUESTION # 97
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A. True
- B. False
Answer: A
Explanation:
Explanation
You can experiment the same with snowflake UI.
NEW QUESTION # 98
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. True
- B. False
Answer: A
Explanation:
Explanation
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.
NEW QUESTION # 99
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html
NEW QUESTION # 100
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
- A. Pruning
- B. Map reduce
- C. Indexing
- D. B-tree
Answer: B
NEW QUESTION # 101
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Compute can be scaled up or down without the requirement to add more storage
- B. Storage expands without the requirement to add more compute
- C. Multiple compute clusters can access stored data without contention
- D. Growth of storage and compute are tightly coupled together
Answer: A,B,C
Explanation:
Reference:
https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt- separate-storage-and-compute-65d2dffd450f
NEW QUESTION # 102
Which Snowflake feature is used for both querying and restoring data?
- A. Cluster keys
- B. Time Travel
- C. Cloning
- D. Fail-safe
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%
NEW QUESTION # 103
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A. True
- B. False
Answer: B
Explanation:
Explanation
NEW QUESTION # 104
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
- A. Schemas
- B. Stored Procedures
- C. Tables
- D. Secure User-Defined Functions (UDFs)
- E. Secure Views
- F. Roles
Answer: C,D,E
NEW QUESTION # 105
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
- A. ROLES
- B. QUERY_HISTORY
- C. POLICY_REFERENCES
- D. ACCESS_HISTORY
- E. RESOURCE_MONIT ORS
Answer: B,C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING%
NEW QUESTION # 106
......
SnowPro-Core [Feb-2024] Newly Released] SnowPro-Core Exam Questions For You To Pass: https://www.actualtests4sure.com/SnowPro-Core-test-questions.html
For your comfort, Actualtests4sure provides you the convenience of free SnowPro Core braindumps demo: https://drive.google.com/open?id=1ngl8pAaRVSYXYV8g3nLBGaKDCK8DfyeZ
