최신 SnowPro-Core 무료덤프 - Snowflake SnowPro Core Certification

문제1

What does a table with a clustering depth of 1 mean in Snowflake?

A. The table has no overlapping micro-partitions.

B. The table has only 1 micro-partition.

C. The table has 1 overlapping micro-partition.

D. The table has no micro-partitions.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제2

Which Snowflake command can be used to unload the result of a query to a single file?

A. Use COPY INTO <external stage> followed by a GET command to download the file.

B. Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.

C. Use COPY INTO <internal stage> followed by a put command to download the file.

D. Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제3

Which activities are included in the Cloud Services layer? {Select TWO).

A. User authentication

B. Dynamic data masking

C. Partition scanning

D. Infrastructure management

E. Data storage

정답: A,D

설명: (DumpTOP 회원만 볼 수 있음)

문제4

When unloading to a stage, which of the following is a recommended practice or approach?

A. Use OBJECT_CONSTRUCT ( * ) when using Parquet

B. Set SINGLE: = true for larger files

C. Avoid the use of the CAST function

D. Define an individual file format

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제5

The fail-safe retention period is how many days?

A. 90 days

B. 1 day

C. 45 days

D. 7 days

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제6

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

A. True

B. False

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제7

What happens when a virtual warehouse is resized?

A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C. Users who are trying to use the warehouse will receive an error message until the resizing is complete

D. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Which file formats are supported for unloading data from Snowflake? (Choose two.)

A. ORC

B. JSON

C. Delimited (CSV, TSV, etc.)

D. Avro

E. XML

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제9

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

A. Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

B. Review the granted privileges to the database object.

C. Review the row access policy for the database object.

D. Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제10

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A. Snowflake leverages a Role-Based Access Control (RBAC) model.

B. All data in Snowflake is compressed.

C. Snowflake requires a user to configure an IAM user to connect to the database.

D. All data in Snowflake is encrypted.

E. Snowflake can run within a user's own Virtual Private Cloud (VPC).

정답: A,D

설명: (DumpTOP 회원만 볼 수 있음)

문제11

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A. GET

B. INSERT

C. PUT

D. COPY

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제12

Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

A. Directory

B. Pre-signed

C. File

D. Scoped

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제13

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

A. Metadata Management

B. Cloud Services

C. Query Processing

D. Database Storage

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제14

Which data types optimally store semi-structured data? (Select TWO).

A. STRING

B. ARRAY

C. VARCHAR

D. VARIANT

E. CHARACTER

정답: B,D

설명: (DumpTOP 회원만 볼 수 있음)

최신 SnowPro-Core 무료덤프 - Snowflake SnowPro Core Certification

우리와 연락하기

유용한 링크

최신 업데이트