ExamGecko
Home / Snowflake / SnowPro Core
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 29

Question list
Search

Question 281

Report
Export
Collapse

How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

Create a view.
Create a view.
Cluster a table.
Cluster a table.
Enable the search optimization service.
Enable the search optimization service.
Enable Time Travel.
Enable Time Travel.
Index a table.
Index a table.
Suggested answer: B, C

Explanation:

To optimize query performance in Snowflake, users can cluster a table, which organizes the data in a way that minimizes the amount of data scanned during queries.Additionally, enabling the search optimization service can improve the performance of selective point lookup queries on large tables34.

asked 23/09/2024
Eli Thompson
33 questions

Question 282

Report
Export
Collapse

What can a Snowflake user do with the information included in the details section of a Query Profile?

Determine the total duration of the query.
Determine the total duration of the query.
Determine the role of the user who ran the query.
Determine the role of the user who ran the query.
Determine the source system that the queried table is from.
Determine the source system that the queried table is from.
Determine if the query was on structured or semi-structured data.
Determine if the query was on structured or semi-structured data.
Suggested answer: A

Explanation:

The details section of a Query Profile in Snowflake provides users with various statistics and information about the execution of a query. One of the key pieces of information that can be determined from this section is the total duration of the query, which helps in understanding the performance and identifying potential bottlenecks.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Daniel Yamamoto
43 questions

Question 283

Report
Export
Collapse

How many network policies can be assigned to an account or specific user at a time?

One
One
Two
Two
Three
Three
Unlimited
Unlimited
Suggested answer: A

Explanation:

According to my knowledge, a security administrator can create multiple network policies, but only one network policy can be active for an account or specific user at any given time. This ensures that there is a clear and consistent policy being applied without conflicts.Reference:Based on my internal knowledge as of 2021.

asked 23/09/2024
Aldrin Plata
43 questions

Question 284

Report
Export
Collapse

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

ROW_NUMBER
ROW_NUMBER
TABLE
TABLE
TABULAR
TABULAR
VALUES
VALUES
Suggested answer: B

Explanation:

In Snowflake, a tabular User-Defined Function (UDF) is defined with a return clause that includes the keyword ''TABLE.'' This indicates that the UDF will return a set of rows, which can be used in the FROM clause of a query.Reference:Based on my internal knowledge as of 2021.

asked 23/09/2024
Helania Stevenson
51 questions

Question 285

Report
Export
Collapse

What is the recommended way to change the existing file format type in my format from CSV to JSON?

ALTER FILE FORMAT my_format SET TYPE=JSON;
ALTER FILE FORMAT my_format SET TYPE=JSON;
ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
REPLACE FILE FORMAT my format TYPE-JSON;
REPLACE FILE FORMAT my format TYPE-JSON;
Suggested answer: A

Explanation:

To change the existing file format type from CSV to JSON, the recommended way is to use the ALTER FILE FORMAT command with the SET TYPE=JSON clause. This alters the file format specification to use JSON instead of CSV.Reference:Based on my internal knowledge as of 2021.

asked 23/09/2024
Deshawn Sharpe
38 questions

Question 286

Report
Export
Collapse

What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

B-tree
B-tree
Indexing
Indexing
Map reduce
Map reduce
Pruning
Pruning
Suggested answer: D

Explanation:

Snowflake uses a technique called pruning to limit the number of micro-partitions scanned by each query.Pruning effectively filters out unnecessary micro-partitions based on the query's filter conditions, which can significantly improve query performance by reducing the amount of data scanned1.

asked 23/09/2024
Teste Teste
39 questions

Question 287

Report
Export
Collapse

Which command is used to unload files from an internal or external stage to a local file system?

COPY INTO
COPY INTO
GET
GET
PUT
PUT
TRANSFER
TRANSFER
Suggested answer: B

Explanation:

The command used to unload files from an internal or external stage to a local file system in Snowflake is the GET command.This command allows users to download data files that have been staged, making them available on the local file system for further use23.

asked 23/09/2024
David Looby
37 questions

Question 288

Report
Export
Collapse

Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

Authy
Authy
Duo Security
Duo Security
One Login
One Login
RSA SecurlD Access
RSA SecurlD Access
Suggested answer: B

Explanation:

Snowflake integrates Duo Security to support Multi-Factor Authentication (MFA).This feature provides increased login security for users connecting to Snowflake, and it is managed completely by Snowflake without the need for users to sign up separately with Duo4.

asked 23/09/2024
Anthony Zaborski
48 questions

Question 289

Report
Export
Collapse

If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

Auto-scale mode
Auto-scale mode
Maximized mode
Maximized mode
Economy scaling policy
Economy scaling policy
Standard scaling policy
Standard scaling policy
Suggested answer: A

Explanation:

In Snowflake, when queries begin to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately if the warehouse is set to auto-scale mode.This mode allows Snowflake to automatically add or resume additional clusters as soon as the workload increases, and similarly, shut down or pause the additional clusters when the load decreases

asked 23/09/2024
Kurt Onal
43 questions

Question 290

Report
Export
Collapse

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

Resource monitor
Resource monitor
Account_usage. query_history
Account_usage. query_history
Information_schema.warehouse_load_history
Information_schema.warehouse_load_history
Information schema.warehouse metering history
Information schema.warehouse metering history
Suggested answer: C

Explanation:

The Snowflake object that helps evaluate virtual warehouse performance impacted by query queuing is the Information_schema.warehouse_load_history.This view provides historical data about the load on a warehouse, including the average number of queries that were running or queued within a specific interval, which can be used to assess performance and identify potential issues with query queuing3.

asked 23/09/2024
Kristian Michael Matias
44 questions
Total 627 questions
Go to page: of 63