DELL EMC D-DS-FN-23 Dell Data Science Foundations 2023 Online Training
DELL EMC D-DS-FN-23 Online Training
The questions for D-DS-FN-23 were last updated at Jan 30,2025.
- Exam Code: D-DS-FN-23
- Exam Name: Dell Data Science Foundations 2023
- Certification Provider: DELL EMC
- Latest update: Jan 30,2025
Consider this SQL statement:
SELECT product, prod_cost, avg(prod_cost) OVER (PARTITION BY product)
FROM product_detail
The OVER clause makes this what type of function?
- A . Window function
- B . Aggregate function
- C . System function
- D . User-defined function
In a Student’s t-test, what is the meaning of the p-value?
- A . it is the area under the appropriate tails of the Student’s distribution
- B . it is the "power" of the Student’s t-test
- C . it is the mean of the distribution for the null hypothesis
- D . it is the mean of the distribution for the alternate hypothesis
Consider these itemsets:
(hat, scarf, coat)
(hat, scarf, coat, gloves)
(hat, scarf, gloves)
(hat, gloves)
(scarf, coat, gloves)
What is the confidence of the rule (gloves -> hat)?
- A . 75%
- B . 60%
- C . 66%
- D . 80%
During the data preparation phase, you notice a high correlation between average spend on video games, age of players, and number of science fiction shows watched.
Which technique could you use to address the three correlated variables?
- A . Square the three variables to remove the correlation
- B . Combine the three variables into one new variable
- C . Drop the three variables to improve the model
- D . Use scaling to make the three variables equivalent in size
You are attempting to find the Euclidean distance between two centroids:
Centroid A’s coordinates: (X = 2, Y = 4)
Centroid B’s coordinates (X = 8, Y = 10)
Which formula finds the correct Euclidean distance?
- A . SQRT((2-8)2+(4-10)2) or 8.49
- B . SQRT(((2-8) x 2) + ((4-10) x 2)) or 12.17
- C . ((2-8)2+(4-10)2) or 72
- D . ((2-8) x 2 + (4-10) x 2) or 148
In linear regression modeling, which action can be taken to improve the linearity of the relationship between the dependent and independent variables?
- A . Apply a transformation to a variable
- B . Use a different statistical package
- C . Calculate the R-Squared value
- D . Change the units of measurement on the independent variable
Which chart type is intended to display correlations between sets of numeric data?
- A . Scatterplot
- B . Histogram
- C . Pie chart
- D . Line Chart
What does the Receiver Operating Characteristic (ROC) curve show?
- A . Relationship between p-value and true positive rate
- B . Relationship between p-value and true negative rate
- C . Relationship between true positive rate and false positive rate
- D . Relationship between true positive rate and true negative rate
A fair six-sided die is rolled. Let A denote the event that an odd number is rolled. Let C denote the event that a 1, 2, or 3 is rolled.
What is the value of the conditional probability, P(C|A)?
- A . 2/3
- B . 1/2
- C . 1/3
- D . 1/4
Which word or phrase completes the statement? Business Intelligence is to ad-hoc reporting and dashboards as Data Science is to __________.
- A . Optimization and Predictive Modeling
- B . Alerts and Queries
- C . Structured Data and Data Sources
- D . Sales and profit reporting