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 Nov 01,2025.
- Exam Code: D-DS-FN-23
 - Exam Name: Dell Data Science Foundations 2023
 - Certification Provider: DELL EMC
 - Latest update: Nov 01,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