Select the Data Science Tools which are known to provide native connectivity to Snowflake?
Mark the Incorrect statements regarding MIN / MAX Functions?
Which of the following cross validation versions may not be suitable for very large datasets with hundreds of thousands of samples?
Which of the following method is used for multiclass classification?
What Can Snowflake Data Scientist do in the Snowflake Marketplace as Consumer?
Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the expression g = df.groupby(df.index.str.len()) do?
There are a couple of different types of classification tasks in machine learning, Choose the Correct Classification which best categorized the below Application Tasks in Machine learning?
· To detect whether email is spam or not
· To determine whether or not a patient has a certain disease in medicine.
· To determine whether or not quality specifications were met when it comes to QA (Quality Assurance).
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?
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?
Which ones are the key actions in the data collection phase of Machine learning included?
Which metric is not used for evaluating classification models?
Which of the following metrics are used to evaluate classification models?
Which of the following is a common evaluation metric for binary classification?
Which one is not the feature engineering techniques used in ML data science world?
Which one of the following is not the key component while designing External functions within Snowflake?
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;
Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share us-ing Which of the following options?
Which one is the incorrect option to share data in Snowflake?
Secure Data Sharing do not let you share which of the following selected objects in a database in your account with other Snowflake accounts?