최신 DSA-C02 무료덤프 - Snowflake SnowPro Advanced: Data Scientist Certification
Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. What does the ex-pression df[lambda x : x.index.str.endswith('3')] do?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
Which metric is not used for evaluating classification models?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
Which of the following cross validation versions is suitable quicker cross-validation for very large datasets with hundreds of thousands of samples?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
Skewness of Normal distribution is ___________
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
Which of the Following is not type of Windows function in Snowflake?
정답: B,C
설명: (DumpTOP 회원만 볼 수 있음)
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;
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;
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
Mark the Incorrect understanding of Data Scientist about Streams?
정답: A,D
설명: (DumpTOP 회원만 볼 수 있음)