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 4 Question 35 Discussion

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

Select the Correct Statements regarding Normalization?

Show Suggested Answer Hide Answer
Suggested Answer: D

All are correct except a standard-only stream tracks row inserts only.

A standard (i.e. delta) stream tracks all DML changes to the source object, including inserts, up-dates, and deletes (including table truncates).


Contribute your Thoughts:

0/2000 characters
Colene
3 months ago
Yeah, outliers can really skew the results in normalization.
upvoted 0 times
...
Major
3 months ago
Wait, normalization is affected by outliers? That’s surprising!
upvoted 0 times
...
Alyce
3 months ago
Scikit-Learn has a Normalizer, but not a RecommendedScaler.
upvoted 0 times
...
Oretha
4 months ago
I thought it was mean and standard deviation for scaling?
upvoted 0 times
...
Marylou
4 months ago
Normalization definitely uses min and max values!
upvoted 0 times
...
Leslie
4 months ago
I feel like normalization and standardization are often confused, but I do remember that normalization can be influenced by outliers.
upvoted 0 times
...
Izetta
4 months ago
I practiced a question similar to this, and I think normalization typically uses mean and standard deviation, but I might be mixing it up with standardization.
upvoted 0 times
...
Pearly
4 months ago
I think normalization is definitely affected by outliers, but I can't recall if Scikit-Learn has a specific transformer called RecommendedScaler.
upvoted 0 times
...
Loreta
5 months ago
I remember that normalization often involves scaling data, but I'm not sure if it's specifically about min and max values or something else.
upvoted 0 times
...
Erasmo
5 months ago
Wait, I'm confused. I thought normalization was about scaling the data, not just the model. I'll have to review my notes on this before answering.
upvoted 0 times
...
Merilyn
5 months ago
Okay, I think I've got this. Normalization uses mean and standard deviation, and Scikit-Learn has a transformer called StandardScaler that does this. I'll select options B and C.
upvoted 0 times
...
Arthur
5 months ago
Hmm, I'm a bit unsure about this. I remember something about normalization being affected by outliers, but I can't recall the details. I'll have to think this through carefully.
upvoted 0 times
...
Renea
5 months ago
I'm pretty confident about this one. I know normalization uses mean and standard deviation, not min and max values, so I'll select option B.
upvoted 0 times
...
Iola
10 months ago
Normalization? More like Abnormalization, am I right? *chuckles* Okay, I'll see myself out.
upvoted 0 times
Gertude
9 months ago
Normalization techniques are important for data preprocessing.
upvoted 0 times
...
Deangelo
9 months ago
C) Scikit-Learn provides a transformer RecommendedScaler for Normalization.
upvoted 0 times
...
Michell
9 months ago
A) Normalization technique uses minimum and max values for scaling of model.
upvoted 0 times
...
...
Annabelle
10 months ago
A? Really? Normalization has nothing to do with min and max values. Sounds like someone needs to go back to their machine learning basics.
upvoted 0 times
Mike
10 months ago
D) Normalization got affected by outliers.
upvoted 0 times
...
Shayne
10 months ago
C) Scikit-Learn provides a transformer RecommendedScaler for Normalization.
upvoted 0 times
...
Marquetta
10 months ago
B) Normalization technique uses mean and standard deviation for scaling of model.
upvoted 0 times
...
...
Jettie
10 months ago
D is definitely true. Normalization can be affected by outliers in the data, so we need to be careful about that.
upvoted 0 times
...
Edda
10 months ago
Option C is interesting, but I'm not sure if that's the correct answer. I'll have to double-check the documentation.
upvoted 0 times
...
Billye
10 months ago
I believe option D) Normalization got affected by outliers is also important to consider, as outliers can skew the normalization process.
upvoted 0 times
...
Annett
10 months ago
I think option B is the correct statement. Normalization uses mean and standard deviation for scaling the data.
upvoted 0 times
Veda
9 months ago
Yes, option B is the correct statement. Normalization technique uses mean and standard deviation for scaling of model.
upvoted 0 times
...
Theola
9 months ago
I agree, option B is correct. Normalization uses mean and standard deviation for scaling.
upvoted 0 times
...
...
Johnna
11 months ago
I agree with Narcisa, because using mean and standard deviation helps in maintaining the distribution of data.
upvoted 0 times
...
Narcisa
11 months ago
I think the correct statement is B) Normalization technique uses mean and standard deviation for scaling of model.
upvoted 0 times
...

Save Cancel