New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake DSA-C02 Exam - Topic 1 Question 11 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 11
Topic #: 1
[All DSA-C02 Questions]

All aggregate functions except _____ ignore null values in their input collection

Show Suggested Answer Hide Answer
Suggested Answer: A, B

Model versioning in a way involves tracking the changes made to an ML model that has been previously built. Put differently, it is the process of making changes to the configurations of an ML Model. From another perspective, we can see model versioning as a feature that helps Machine Learning Engineers, Data Scientists, and related personnel create and keep multiple versions of the same model.

Think of it as a way of taking notes of the changes you make to the model through tweaking hyperparameters, retraining the model with more data, and so on.

In model versioning, a number of things need to be versioned, to help us keep track of important changes. I'll list and explain them below:

Implementation code: From the early days of model building to optimization stages, code or in this case source code of the model plays an important role. This code experiences significant changes during optimization stages which can easily be lost if not tracked properly. Because of this, code is one of the things that are taken into consideration during the model versioning process.

Data: In some cases, training data does improve significantly from its initial state during model op-timization phases. This can be as a result of engineering new features from existing ones to train our model on. Also there is metadata (data about your training data and model) to consider versioning. Metadata can change different times over without the training data actually changing. We need to be able to track these changes through versioning

Model: The model is a product of the two previous entities and as stated in their explanations, an ML model changes at different points of the optimization phases through hyperparameter setting, model artifacts and learning coefficients. Versioning helps take record of the different versions of a Machine Learning model.

MLFlow & Pachyderm are the tools used to manage ML lifecycle & Model versioning.


Contribute your Thoughts:

0/2000 characters
Blossom
3 months ago
Wait, are we sure about that? Sounds off to me.
upvoted 0 times
...
Cathrine
3 months ago
Definitely Count(*)! It counts everything.
upvoted 0 times
...
Lizbeth
4 months ago
I thought Avg would include nulls too, but I guess not!
upvoted 0 times
...
Joesph
4 months ago
Yeah, I think Count(attribute) is the one that ignores them.
upvoted 0 times
...
Wilbert
4 months ago
Count(*) includes nulls, right?
upvoted 0 times
...
Alisha
4 months ago
I'm leaning towards Count(attribute) because it seems to be the only one that might consider nulls, but I could be wrong.
upvoted 0 times
...
Sylvie
4 months ago
I feel like Avg might be the answer since it calculates the average, but I can't recall if it counts nulls or not.
upvoted 0 times
...
Allene
4 months ago
I remember practicing a question like this, and I think Count(*) includes all rows, even nulls.
upvoted 0 times
...
Laurel
5 months ago
I think Count(attribute) is the one that counts nulls, but I'm not entirely sure.
upvoted 0 times
...
Gussie
5 months ago
I'm feeling good about this one. The question says "except", so the answer has to be the aggregate function that doesn't ignore nulls. That's gotta be Count(*).
upvoted 0 times
...
An
5 months ago
Okay, I've got this. Count(attribute) ignores nulls, but Count(*) counts everything, including nulls. So the answer must be B. Count(*).
upvoted 0 times
...
Leah
5 months ago
Hmm, I'm a bit confused on this one. I know the aggregate functions like Avg and Sum ignore nulls, but I can't remember if Count(*) does too. I'll have to think this through carefully.
upvoted 0 times
...
Kristofer
5 months ago
I'm pretty sure the answer is B. Count(*) is the only aggregate function that doesn't ignore null values.
upvoted 0 times
...
Margarett
5 months ago
This looks like a pretty straightforward question. I think I can handle this one.
upvoted 0 times
...
Lorrine
5 months ago
Okay, I've got this. The Deny Write List function can be used to prevent users from modifying certain files, and to deny access to the SYS volume. Those are the two correct answers here.
upvoted 0 times
...
Mabel
9 months ago
I'm just here for the free snacks. Oh, the question? Uh, let's see... B) Count(*), because counting is fun, even with nulls!
upvoted 0 times
Stevie
8 months ago
Counting everything with Count(*) does seem like the best choice here.
upvoted 0 times
...
Lilli
8 months ago
I'm not sure, but I think Count(*) is the way to go for this question.
upvoted 0 times
...
Alison
8 months ago
I agree, counting all values with Count(*) is more inclusive.
upvoted 0 times
...
Quentin
8 months ago
I think B) Count(*) is the correct answer because it counts all values, even nulls.
upvoted 0 times
...
...
Troy
9 months ago
Ah, the age-old question of which aggregate function ignores nulls. I'm feeling lucky, so I'll go with A) Count(attribute). Gotta love a good old-fashioned count, am I right?
upvoted 0 times
Kaitlyn
9 months ago
I remember learning that it's C) Avg, that's the aggregate function that ignores null values.
upvoted 0 times
...
Twanna
9 months ago
I'm pretty sure it's D) Sum, that's the one that ignores nulls.
upvoted 0 times
...
Selene
9 months ago
I think it's actually B) Count(*), that one ignores null values.
upvoted 0 times
...
...
Ernestine
10 months ago
Hmm, this is a tricky one. I'm going to go with D) Sum. I mean, who doesn't love a good sum, even with those pesky null values?
upvoted 0 times
...
Vincenza
10 months ago
I'm pretty sure the correct answer is C) Avg. It's the only one that doesn't ignore null values in the input collection.
upvoted 0 times
...
Tony
10 months ago
I think the answer is B) Count(*) because it counts all rows, including those with null values. The other aggregate functions like Avg and Sum ignore nulls.
upvoted 0 times
Arthur
8 months ago
No, it's actually B) Count(*), Sum ignores null values.
upvoted 0 times
...
Xochitl
8 months ago
I think it's D) Sum because it adds up all values, including nulls.
upvoted 0 times
...
Rana
9 months ago
I agree, Count(*) includes null values in the count.
upvoted 0 times
...
...
Altha
10 months ago
Hmm, that makes sense too. I guess it depends on how you interpret the question.
upvoted 0 times
...
Josefa
10 months ago
I disagree, I believe the answer is D) Sum because it adds up all values, even if some are null.
upvoted 0 times
...
Altha
10 months ago
I think the answer is B) Count(*) because it counts all rows, including null values.
upvoted 0 times
...
Sonia
10 months ago
Hmm, that makes sense too. I guess it depends on how you interpret the question.
upvoted 0 times
...
Gerardo
11 months ago
I disagree, I believe the answer is D) Sum because it adds up all values, even if some are null.
upvoted 0 times
...
Sonia
11 months ago
I think the answer is B) Count(*) because it counts all rows, including null values.
upvoted 0 times
...

Save Cancel