Which one is the incorrect option to share data in Snowflake?
A. a Direct Marketplace, in which you directly share specific database objects (a share) to another account in your region using Snowflake Marketplace.
B. a Direct Share, in which you directly share specific database objects (a share) to anoth-er account in your region.
C. a Listing, in which you offer a share and additional metadata as a data product to one or more accounts.
D. a Data Exchange, in which you set up and manage a group of accounts and offer a share to that group.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Which metric is not used for evaluating classification models?
A. Recall
B. Precision
C. Accuracy
D. Mean absolute error
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
Mark the incorrect statement regarding usage of Snowflake Stream & Tasks?
A. Streams support repeatable read isolation.
B. An standard-only stream tracks row inserts only.
C. Snowflake ensures only one instance of a task with a schedule (i.e. a standalone task or the root task in a DAG) is executed at a given time. If a task is still running when the next scheduled execution time occurs, then that scheduled time is skipped.
D. Snowflake automatically resizes and scales the compute resources for serverless tasks.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
Which ones are the correct rules while using a data science model created via External function in Snowflake?
A. An external function can appear in any clause of a SQL statement in which other types of UDF can appear.
B. External functions can be overloaded.
C. External functions return a value. The returned value can be a compound value, such as a VARIANT that contains JSON.
D. External functions can accept Model parameters.
正解:A,B,C,D
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
You previously trained a model using a training dataset. You want to detect any data drift in the new data collected since the model was trained.
What should you do?
A. Add the new data to the existing dataset and enable Application Insights for the service where the model is deployed.
B. Retrained your training dataset after correcting data outliers & no need to introduce new data.
C. Create a new dataset using the new data and a timestamp column and create a data drift monitor that uses the training dataset as a baseline and the new dataset as a target.
D. Create a new version of the dataset using only the new data and retrain the model.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
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?
A. OFFSET
B. Stream
C. Delta
D. Dynamic tables
E. Task
F. Tags
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
Hasegawa -
図表を多用して、DSA-C02のわかりにくい概念や仕組みの理解を助ける。しかも広大な試験分野を1冊でカバーしてる!