2024 DELL EMC D-DS-FN-23 Exam Dumps Questions

1. Which activity is performed in the Operationalize phase of the data analytics lifecycle?

2. What are categorized as data ingestion tools for Hadoop?

3. Determine the frequency of calls by both product type and customer language.

Which goals are suitable to be completed with MapReduce?

4. 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?

5. What tasks need to be completed when designing an analytic sandbox?

6. In addition to quantitative and technical skills, what is a key aspect of the profile of a data scientist?

7. In association rules, given X -> Y, what is confidence?

8. Your organization has a website where visitors randomly receive one of two coupons. It is also possible that visitors to the website will not receive a coupon.

You have been asked to determine if offering a coupon to visitors to your website has any impact on their purchase decision.

Which analysis method should you use?

9. You fit a Logistic Regression model to your training data and notice that the variable X has an infinite magnitude coefficient.

What does this indicate?

10. Refer to the exhibit.





Click on the calculator icon in the upper left corner.

You are given a list of predefined association rules:

A) RENTER => BAD CREDIT

B) RENTER => GOOD CREDIT

C) HOME OWNER => BAD CREDIT

D) HOME OWNER => GOOD CREDIT

E) FREE HOUSING => BAD CREDIT

F) FREE HOUSING => GOOD CREDIT

For your next analysis, you must limit your dataset based on rules with confidence greater than 60%.

Which of the rules will be kept in the analysis?

11. Which key role for a successful analytic project can consult and advise the project team on the value of end results and how these will be used on a day-to-day basis?

12. You build a decision tree to classify five different types of customers based on their browsing history from a sample of 500. The resulting decision tree has 17 layers. One of the leaf nodes has only three customers.

What do you conclude?

13. You have been assigned to run a Logistic Regression model for 100 countries each. All data is currently stored in a PostgreSQL database.

Which tool/library should be used to produce these models with the least effort?

14. Which relationship holds for a confusion matrix?

15. If distributed Item-based Collaborative Filtering is an algorithm supported by Mahout, what is the use case category of the algorithm?

16. Variable D is not significantly impacting the dependent variable.

After seeing your findings, the majority of your team agreed that variable B should be positively impacting the dependent variable.

What is a possible reason the coefficient for variable B was negative and not positive?

17. What describes a true property of Logistic Regression method?

18. In the Map Reduce framework, what is the purpose of the Map Function?

19. You are provided four different datasets. Initial analysis on these datasets show that they have identical mean, variance and correlation values.

What should your next step in the analysis be?

20. Which phase of the data analytic lifecycle includes conducting project sponsor interviews and drafting a problem statement?

21. Consider the example of an analysis for fraud detection on credit card usage. You will need to ensure higher-risk transactions that may indicate fraudulent credit card activity are retained in your data for analysis, and not dropped as outliers during pre-processing.

What will be your approach for loading data into the analytical sandbox for this analysis?

22. Consider the following SQL query:

SELECT product_id FROM supplier_A

UNION

SELECT product_id FROM supplier_B;

What is the expected result?

23. Which key role for a successful analytic project can provide business domain expertise with a deep understanding of the data and key performance indicators?

24. What is the reason for using LOESS?

25. Only three variables A, B, and C have significant correlation with sales

You build a linear regression model on the dependent variable of sales with the independent variables of A, B, and C. The results of the regression are seen in the exhibit. You cannot request additional data.

What is a way that you could try to increase the R2 of the model without artificially inflating it?

26. Since R factors are categorical variables, they are most closely related to which data classification level?

27. Which word or phrase completes the statement; “A data scientist would consider a RDBMS is to a table as R is to a_____.”?

28. You have numeric data for more than 500 observations. You are interested in identifying linear relationships among these numeric variables.

Which R function should you employ to get the best visualization?

29. Which term is used to describe separating a database into separate parts that can be processed in parallel?

30. In the data preparation phase of the data analytics lifecycle, what does the term “data conditioning” refer to?

31. Which R data structure allows elements to have different data types?

32. 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 (hat, scarf) => gloves?

33. Before you build an ARMA model, how can you tell if your time series is weakly stationary?

34. Your colleague, who is new to Hadoop, approaches you with a question. They want to know how best to access their data. This colleague has previously worked extensively with SQL and databases.

Which query interface would you recommend?

35. If R factors are categorical variables, which data classification level are they most closely related?

36. You have been assigned to run a logistic regression model for each of 100 countries, and all the data is currently stored in a PostgreSQL database.

Which tool/library would you use to produce these models with the least effort?

37. You are testing two new weight-gain formulas for puppies. The test gives the results: Control group: 1% weight gain Formula A. 3% weight gain Formula B. 4% weight gain A one-way ANOVA returns a p-value = 0.027

What can you conclude?

38. To ensure a successful analytic project, which key role can provide business domain expertise with a deep understanding of the data and key performance indicators?

39. Refer to the exhibit.





The graph represents an ROC space with four classifiers labelled A through D.

Which point in the graph represents a perfect classification?

40. In time series analysis, what function is examined to identify the order of the autoregressive component of an ARIMA model?

41. How is HDFS defined?

42. When is the GROUP BY ROLLUP clause used in an OLAP query?

43. What would be considered "Big Data"?

44. On analyzing the results of a K-means clustering output, you noticed that splits on variables you expected to see were not observed.

What actions should be taken?

45. Refer to the exhibit.





The exhibit shows four graphs labeled as Fig A thorough Fig D.

Which figure represents the entropy function relative to a Boolean classification and is represented by the formula shown in Exhibit?

46. Which chart type is the most effective way to show trends over time?

47. Which data asset is an example of unstructured data?

48. A data scientist wants to predict the probability of death from heart disease based on three risk factors: age, gender, and blood cholesterol level.

What is the most appropriate method for this project?

49. What does a branch represent in a decision tree?

50. You have completed your model and are handing it off to be deployed in production.

What should you deliver to the production team, along with your commented code?

51. After which phase of the data analytics lifecycle should you determine if the model needs any recalibration?

52. In R, functions like plot() and hist() are known as what?

53. A data scientist is investigating a new database column that needs to be integrated into their model. The column contains 10,000 labels with 300 unique values.

Which data structure should be used when working in R?

54. In which lifecycle stage are initial hypotheses formed?

55. Based on the exhibit, the table shows the values for the input Boolean attributes A, B, and C. In addition, the exhibit shows the values for the output attribute "class".





Which decision tree is valid for the data?

56. Assume you are performing an analysis to determine fraud detection on credit card usage. You will need to ensure higher-risk transactions. These may indicate that fraudulent credit card activity is retained in your data for analysis and not dropped as outliers during pre- processing.

What is the approach for loading data into the analytical sandbox for this analysis?

57. A logistic regression model is built to determine the probability of a credit card borrower defaulting on a credit loan. A threshold value of 0.3 is selected.

Which statement can be used to predict a borrower will default?

58. Which word or phrase completes the statement; “Discovering relationships is to Association Rules as generating forecasts is to __________.”?

59. Which clause is required by all window functions?

60. Which characteristic applies mainly to Data Science as opposed to Business Intelligence?

61. Refer to the exhibit.





In the exhibit, the x-axis represents the derived probability of a borrower defaulting on a loan. Also in the exhibit, the pink represents borrowers that are known to have not defaulted on their loan, and the blue represents borrowers that are known to have defaulted on their loan.

Which analytical method could produce the probabilities needed to build this exhibit?

62. Based on the exhibit, what is a likely issue with the data?

63. What is a business driver for Big Data analytics adoption?

64. You have been assigned to perform a study of the daily revenue effect of a pricing model of online transactions. When is the analytics lifecycle considered completed?

65. Which SQL set operator returns rows that exist in the first SELECT statement answer set but not in the second SELECT statement?

66. You have created a scatter plot using R from household income and education data as shown in the graphic.





What can be done to improve the visualization?

67. Refer to the exhibit, which shows pairwise counts for items purchased together.





Consider the following association rules:

- Milk -> Eggs

- Eggs -> Milk

- Bread -> Milk

- Milk -> Bread

Which rule has a confidence higher than 70%?

68. What is the output of the K-means clustering algorithm?

69. You are using k-means clustering to classify heart patients for a hospital. You have chosen Patient Sex, Height, Weight, Age and Income as measures and have used 3 clusters.

When you create a pair-wise plot of the clusters, you notice that there is significant overlap between the clusters.

What should you do?

70. There are three criterions for big data analytics projects which include:

- Decision speed

- Analysis flexibility

What is the additional criteria?

71. Imagine you are trying to hire a Data Scientist for your team. In addition to technical ability and quantitative background, which additional essential trait would you look for in people applying for this position?

72. Refer to the exhibit.





Which type of data issue would you suspect based on the exhibit?

73. What action occurs during feature selection in the model building phase of the data analytics lifecycle?

74. You have been given a task to improve sales force compensation of your organization. As a result of a study, your team decides to classify personnel as follows:

● Did not meet quota

● Met quota

● Exceeded 150% of quota

In which data analytics lifecycle phase should you define these categories for analysis purposes?

75. Which type of numeric value does a logistic regression model estimate?

76. Which function shown in the exhibit is used to calculate the sample variance?

77. Which functionality do regular expressions provide?

78. You are given 10, 000, 000 user profile pages of an online dating site in XML files, and they are stored in HDFS. You are assigned to divide the users into groups based on the content of their profiles.

You have been instructed to try K-means clustering on this data. How should you proceed?

79. Refer to the exhibit.





Click on the calculator icon in the upper left corner. You are going into a meeting where you know your manager will have a question on your dataset -- specifically relating to customers that are classified as renters with good credit status.

In order to prepare for the meeting, you create a rule: RENTER => GOOD CREDIT.

What is the confidence of the rule?

80. You are analyzing data in order to build a classifier model. You discover non-linear data and discontinuities that will affect the model.

Which analytical method would you recommend?

81. What is the output format from the Map function of MapReduce?

82. Refer to the exhibit.





You have created a density plot of purchase amounts from a retail website as shown.

What should you do next?

83. You have used k-means clustering to classify behavior of 100, 000 customers for a retail store. You decide to use household income, age, gender and yearly purchase amount as measures.

You have chosen to use 8 clusters and notice that 2 clusters only have 3 customers assigned.

What should you do?

84. Your risk analysis team has access to new customer financial data. You want to use this data to improve your prediction of credit default. Previously, the team was using only credit bureau scores, loan size, and customer income to assess risk of default.

What is the null hypothesis that should be used to evaluate the model?

85. Based on the graphic, what should be done to begin addressing chart junk?

86. What is the similarity between the matrix and array data structures in R?

87. Which of the following is an example of quasi-structured data?

88. Refer to Exhibit.





To predict whether or not a customer will renew their annual property insurance policy, an insurance company built and operationalized a naïve Bayes classification model. In the model, there are two class labels, renewal and non-renewal, that are assigned to each customer based on their attributes.

A subset of the key attributes, their values, and corresponding conditional probabilities are provided in the exhibit.

A customer has the following attributes:

● Age is greater than 65 years

● Owns their own home

● Renewal month is August

If 20% of customers do not renew the police every year, what is the score for a renewal in the naïve Bayesian model for the customer described above?

89. You have created a scatterplot of two continuous variables for 2000 records. You want to add a line to the scatterplot to check linearity of the data.

Which function would best address this need?

90. What is Hadoop?

91. You have an automotive database containing numeric characteristics such as engine size, horsepower, and top speed.

Which technique could you use to group similar cars together?

92. You have been assigned to perform a study of the daily revenue effect of a pricing model of online transactions. All the data currently available has been loaded into an analytics database.

This data includes revenue data, pricing data, and online transaction data. You have completed a thorough univariate analysis of all data and have decided that there are three different models you want to test. Preliminary results show that all models have equally effective results.

What is the next step?

93. Refer to the graphic.





How would you run the MADlib kmeans function?

94. A major health care company with 2,500 hospitals acquired a company with 1,500 hospitals. In the year following the company merger, all the health care records have been digitized and loaded into a new centralized data warehouse.

Each individual’s health record now includes all doctor’s notes and medical images taken. There are currently hundreds of models and reports in production that were built in the original data warehouse.

Since the merger, these models have become outdated and need to be re-evaluated. You have been assigned to update the models that predict the hospital visitation pattern and resource usage of individuals with chronic diseases.

Which steps of the analytic project should be performed in the database?

95. How is dimensionality defined in a "bag of words" document representation?

96. A data scientist plans to classify the sentiment polarity of 10, 000 product reviews collected from the Internet.

What is the most appropriate model to use? Suppose labeled training data is available.

97. Which SQL OLAP grouping extension returns a result for each output row with 1 identifying a summary row and 0 identifying grouped rows?

98. What is part of the model output for a linear regression?

99. What is required in a presentation for business analysts?

100. Refer to the Exhibit.





You are working on creating an OLAP query that outputs several rows of with summary rows of subtotals and grand totals in addition to regular rows that may contain NULL as shown in the exhibit.

Which function can you use in your query to distinguish the row from a regular row to a subtotal row?

101. In time series analysis, what is an indication of a stationary sequence?

102. What is a distinct property of Logistic Regression compared with Linear Regression?

103. Data has been collected on visitors' viewing habits at a bank's website.

Which technique is used to identify pages commonly viewed during the same visit to the website?

104. What is a recommended use case for regular expressions?