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

문제1

Which command is used to start configuring Snowflake for Single Sign-On (SSO)?

A. CREATE NETWORK RULE

B. CREATE SECURITY INTEGRATION

C. CREATE PASSWORD POLICY

D. CREATE SESSION POLICY

정답: B

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

문제2

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

A. True

B. False

정답: A

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

문제3

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

A. Warehouses that are multi-cluster can have nodes of different sizes.

B. Warehouses can be started and stopped at any time.

C. Warehouses can be resized at any time, even while running.

D. Warehouses can only be used for querying and cannot be used for data loading.

E. Warehouses are billed on a per-minute usage basis.

정답: B,C

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

문제4

Users are responsible for data storage costs until what occurs?

A. Data expires from Time Travel

B. Data expires from Fail-safe

C. Data is truncated from a table

D. Data is deleted from a table

정답: B

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

문제5

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

A. Tasks

B. Streams

C. Pipes

D. Procedures

정답: B

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

문제6

Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?

A. GET

B. COPY INTO <location>

C. PUT

D. CREATE STREAM

정답: C

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

문제7

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

A. An error will occur, as stored objects cannot be cloned.

B. The stored procedures and views will refer to tables in the source database.

C. The cloned views and the stored procedures will reference the cloned tables in the cloned database.

D. An error will occur, as views with qualified references cannot be cloned.

정답: C

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

문제8

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

A. SHOW GRANTS TO USER INQUISITIVE_PERSON

B. SHOW GRANTS OF ROLE DATA_SCIENCE

C. SHOW GRANTS ON ROLE DATA_SCIENCE

D. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

정답: D

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

문제9

Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?

A. End-to-end encryption

B. Multi-Factor Authentication (MFA)

C. Fail-safe

D. Network policies

정답: C

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

문제10

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

A. Data Robot

B. Adobe

C. Informatica

D. Power Bl

정답: A

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

문제11

What role is required to use Partner Connect?

A. SECURITYADMIN

B. ORGADMIN

C. SYSADMIN

D. ACCOUNTADMIN

정답: D

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

문제12

What causes objects in a data share to become unavailable to a consumer account?

A. The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every
24 hours.

B. The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.

C. The consumer account acquires the data share through a private data exchange.

D. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

정답: D

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

문제13

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

A. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

C. grant SELECT on all tables in database DB1 to role MYROLE;

D. grant SELECT on future tables in database DB1 to role MYROLE;

E. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

F. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

정답: A,F

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

문제14

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

A. The clone is created almost instantly.

B. The clone always stays in sync with the original table.

C. The clone saves space by not duplicating storage.

D. The clone will have time travel history from the original table.

E. The clone has better query performance.

정답: A,C

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

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

우리와 연락하기

유용한 링크

최신 업데이트