DSA-C02 Real Exam Questions
65 questions available · Page 1 of 7
Updated Exam DumpsVerified AnswersPass Guarantee
All aggregate functions except _____ ignore null values in their input collection
Correct answer: B
Explanation:
Count(*)
* is used to select all values including null.
Which one is the incorrect option to share data in Snowflake?
Correct answer: B
Explanation:
Options for Sharing in Snowflake
You can share data in Snowflake using one of the following options: a Listing, in which you offer a share and additional metadata as a data product to one or more ac-counts, a Direct Share, in which you directly share specific database objects (a share) to another account in your region, a Data Exchange, in which you set up and manage a group of accounts and offer a share to that group.
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?
Correct answer: D
Explanation:
It will Filters the row labelled r3.
Which ones are the known limitations of using External function? Choose all apply.
Correct answers: A, B, C, D
Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share us-ing.
Which of the following options? Choose 2.
Correct answers: B, C
Explanation:What is a Share?
Shares are named Snowflake objects that encapsulate all of the information required to share a database.
Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share using either or both of the following options: Option 1: Grant privileges on objects to a share via a database role. Option 2: Grant privileges on objects directly to a share. You choose which accounts can consume data from the share by adding the accounts to the share.
After a database is created (in a consumer account) from a share, all the shared objects are accessible to users in the consumer account. Shares are secure, configurable, and controlled completely by the provider account: New objects added to a share become immediately available to all consumers, providing real-time access to shared data.
Access to a share (or any of the objects in a share) can be revoked at any time.
Which of the following is a Python-based web application framework for visualizing data and analyzing results in a more efficient and flexible way?
Correct answer: B
Explanation:
Streamlit is a Python-based web application framework for visualizing data and analyzing results in a more efficient and flexible way. It is an open source library that assists data scientists and academics to develop Machine Learning (ML) visualization dashboards in a short period of time. We can build and deploy powerful data applications with just a few lines of code.
Why Streamlit?
Currently, real-world applications are in high demand and developers are developing new libraries and frameworks to make on-the-go dashboards easier to build and deploy. Streamlit is a library that reduces your dashboard development time from days to hours. Following are some reasons to choose the Streamlit: It is a free and open-source library.
Installing Streamlit is as simple as installing any other python package It is easy to learn because you won't need any web development experience, only a basic under-standing of Python is enough to build a data application. It is compatible with almost all machine learning frameworks, including Tensorflow and Pytorch, Scikit-learn, and visualization libraries such as Seaborn, Altair, Plotly, and many others.
Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10'].
What does the aggregate method shown in below code do?
g = df.groupby(df.index.str.len())
Correct answer: C
Explanation:
Computes length of column A and Sum of Column B values of each group
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? Choose 3.
Correct answers: A, C, E
Explanation:
A stream stores an offset for the source object and not any actual table columns or data. When que-ried, a stream accesses and returns the historic data in the same shape as the source object (i.e. the same column names and ordering) with the following additional columns: METADATA$ACTION Indicates the DML operation (INSERT, DELETE) recorded.
METADATA$ISUPDATE
Indicates whether the operation was part of an UPDATE statement. Updates to rows in the source object are represented as a pair of DELETE and INSERT records inthe stream with a metadata column
METADATA$ISUPDATE values set to TRUE. Note that streams record the differences between two offsets. If a row is added and then updated in the current offset, the delta change is a new row. The METADATA$ISUPDATE row records a FALSE value.
METADATA$ROW_ID
Specifies the unique and immutable ID for the row, which can be used to track changes to specific rows over time.
Which of the following is a useful tool for gaining insights into the relationship between features and predictions?
Correct answer: C
Explanation:
Partial dependence plots (PDP) is a useful tool for gaining insights into the relationship between features and predictions. It helps us understand how different values of a particular feature impact model's predictions.
What is the formula for measuring skewness in a dataset?
Correct answer: C
Explanation:
Since the normal curve is symmetric about its mean, its skewness is zero. This is a theoretical expla-nation for mathematical proofs, you can refer to books or websites that speak on the same in detail.