DSA-C02試験無料問題集（67題）「Snowflake SnowPro Advanced: Data Scientist Certification 認定」

出題：1

How do you handle missing or corrupted data in a dataset?

A. Drop missing rows or columns

B. Replace missing values with mean/median/mode

C. Assign a unique category to missing values

D. All of the above

正解：D 解答を投票する

出題：2

Which one is not the types of Feature Engineering Transformation?

A. Encoding

B. Aggregation

C. Scaling

D. Normalization

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

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$ROW_ID

B. METADATA$FILE_ID

C. METADATA$ISUPDATE

D. METADATA$DELETE

E. METADATA$ACTION

正解：A,C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which of the following Snowflake parameter can be used to Automatically Suspend Tasks which are running Data science pipelines after specified Failed Runs?

A. SUSPEND_TASK

B. SUSPEND_TASK_AFTER_NUM_FAILURES

C. SUSPEND_TASK_AUTO_NUM_FAILURES

D. There is none as such available.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

A Data Scientist as data providers require to allow consumers to access all databases and database objects in a share by granting a single privilege on shared databases. Which one is incorrect SnowSQL command used by her while doing this task?
Assuming:
A database named product_db exists with a schema named product_agg and a table named Item_agg.
The database, schema, and table will be shared with two accounts named xy12345 and yz23456.
1.USE ROLE accountadmin;
2.CREATE DIRECT SHARE product_s;
3.GRANT USAGE ON DATABASE product_db TO SHARE product_s;
4.GRANT USAGE ON SCHEMA product_db. product_agg TO SHARE product_s;
5.GRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;
6.SHOW GRANTS TO SHARE product_s;
7.ALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;
8.SHOW GRANTS OF SHARE product_s;

A. GRANT USAGE ON DATABASE product_db TO SHARE product_s;

B. CREATE DIRECT SHARE product_s;

C. GRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;

D. ALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

As Data Scientist looking out to use Reader account, Which ones are the correct considerations about Reader Accounts for Third-Party Access?

A. Each reader account belongs to the provider account that created it.

B. Users in a reader account can query data that has been shared with the reader account, but cannot perform any of the DML tasks that are allowed in a full account, such as data loading, insert, update, and similar data manipulation operations.

C. Reader accounts (formerly known as "read-only accounts") provide a quick, easy, and cost-effective way to share data without requiring the consumer to become a Snowflake customer.

D. Data sharing is only possible between Snowflake accounts.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which ones are the type of visualization used for Data exploration in Data Science?

A. Newton AI

B. 2D-Density Plots

C. Feature Distribution by Class

D. Heat Maps

E. Sand Visualization

正解：B,D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

DSA-C02試験無料問題集「Snowflake SnowPro Advanced: Data Scientist Certification 認定」