최신 DSA-C02 무료덤프 - Snowflake SnowPro Advanced: Data Scientist Certification

문제1

Which of the following method is used for multiclass classification?

A. one vs rest

B. one vs another

C. loocv

D. all vs one

정답: A

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

문제2

Which of the Following is not type of Windows function in Snowflake?

A. Window frame functions.

B. Association functions.

C. Aggregation window functions.

D. Rank-related functions.

정답: B,C

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

문제3

Which one of the following is not the key component while designing External functions within Snowflake?

A. UDF Service

B. Proxy Service

C. API Integration

D. Remote Service

정답: A

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

문제4

Which ones are the known limitations of using External function?

A. Currently, external functions cannot be shared with data consumers via Secure Data Sharing.

B. External functions have more overhead than internal functions (both built-in functions and internal UDFs) and usually execute more slowly

C. An external function accessed through an AWS API Gateway private endpoint can be accessed only from a Snowflake VPC (Virtual Private Cloud) on AWS and in the same AWS region.

D. Currently, external functions must be scalar functions. A scalar external function re-turns a single value for each input row.

정답: A,B,C,D

문제5

Data Scientist used streams in ELT (extract, load, transform) processes where new data inserted in-to a staging table is tracked by a stream. A set of SQL statements transform and insert the stream contents into a set of production tables. Raw data is coming in the JSON format, but for analysis he needs to transform it into relational columns in the production tables. which of the following Data transformation SQL function he can used to achieve the same?

A. METADATA$ACTION ()

B. Transpose()

C. He could not apply Transformation on Stream table data.

D. lateral flatten()

정답: D

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

문제6

Which of the following Functions do Support Windowing?

A. LISTAGG

B. EXTRACT

C. ENCRYPT

D. HASH_AGG

정답: A

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

문제7

Which are the following additional Metadata columns Stream contains that could be used for creating Efficient Data science Pipelines & helps in transforming only the New/Modified data only?

A. METADATA$FILE_ID

B. METADATA$ACTION

C. METADATA$ISUPDATE

D. METADATA$DELETE

E. METADATA$ROW_ID

정답: B,C,E

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

최신 DSA-C02 무료덤프 - Snowflake SnowPro Advanced: Data Scientist Certification

우리와 연락하기

유용한 링크

최신 업데이트