Free SnowPro Advanced: Data Scientist Certification Exam DSA-C02 Exam Practice Test

Which of the learning methodology applies conditional probability of all the variables with respec- tive the dependent variable?

• Reinforcement learning
• Unsupervised learning
• Artificial learning
• Supervised learning

Which one is not the types of Feature Engineering Transformation?

• Scaling
• Encoding
• Aggregation
• Normalization

Which of the following is a common evaluation metric for binary classification?

• Accuracy
• F1 score
• Mean squared error (MSE)
• Area under the ROC curve (AUC)

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.

• USE ROLE accountadmin;
• CREATE DIRECT SHARE product_s;
• GRANT USAGE ON DATABASE product_db TO SHARE product_s;
• GRANT USAGE ON SCHEMA product_db. product_agg TO SHARE product_s;
• GRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;
• SHOW GRANTS TO SHARE product_s;
• ALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;
• SHOW GRANTS OF SHARE product_s;
• GRANT USAGE ON DATABASE product_db TO SHARE product_s;
• CREATE DIRECT SHARE product_s;
• GRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;
• ALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;

You are training a binary classification model to support admission approval decisions for a college degree program.How can you evaluate if the model is fair, and doesn’t discriminate based on ethnicity?

• Evaluate each trained model with a validation dataset and use the model with the highest accuracy score.
• Remove the ethnicity feature from the training dataset.
• Compare disparity between selection rates and performance metrics across ethnicities.
• None of the above.

Which one is not Types of Feature Scaling?

• Economy Scaling
• Min-Max Scaling
• Standard Scaling
• Robust Scaling

Which ones are the key actions in the data collection phase of Machine learning included?

• Label
• Ingest and Aggregate
• Probability
• Measure

All aggregate functions except ignore null values in their input collection

• Count(attribute)
• Count(*)
• Avg
• Sum

Which object records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data of Data Science Pipelines?

• Task
• Dynamic tables
• Stream
• Tags
• Delta
• OFFSET

What Can Snowflake Data Scientist do in the Snowflake Marketplace as Provider?

• Publish listings for free-to-use datasets to generate interest and new opportunities among the Snowflake customer base.
• Publish listings for datasets that can be customized for the consumer.
• Share live datasets securely and in real-time without creating copies of the data or im-posing data integration tasks on the consumer.
• Eliminate the costs of building and maintaining APIs and data pipelines to deliver data to customers.