Dell EMC D-DS-FN-23 Exam Questions Instant Access

Question 1

Consider this SQL statement: SELECT product, avg(prod_cost) FROM product_detail GROUP BY product. The GROUP BY clause implies what type of function?

ASystem function

BAggregate function

CUser defined function

DWindow function

Answer : B

Question 2

Which R function plots a distribution of a single variable along two different axes?

Atable()

BsummaryQ

Cdensity ()

Drug()

Answer : D

Question 3

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?

AModel building

BCommunicate results

COperationalize

DModel planning

Answer : D

Question 4

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

AProject management and administrative skills

BProficient in Microsoft Project and Excel

CSkeptical and critical thinking

DAccounting and regulatory skills

Answer : C

Question 5

In a user-defined aggregate function, what is FFUNC?

AOptional final calculation function

BWindow function

CState transition function

DSegment-level calculation function

Answer : A

Question 6

What converts SQL-like commands into either Tez, Spark, or MapReduce jobs that are submitted to the Hadoop cluster?

APig

BHBase

CHive

DMahout

Answer : C

Question 7

A decision tree is being built. An internal node is being evaluated for partitioning on variables A and B. The entropy of the internal node is 0.8. The entropy for each of the variables is as follows:

Variable A: 0.5

Variable B: 0.4

Which variable will be used to partition the data and what is the information gain?

AVariable B; information gain is 0.1

BVariable B; information gain is 0.4

CVariable A; information gain is 0.1

DVariable A; information gain is 0.5

Answer : B

Dell EMC Dell Certified Data Science Foundations D-DS-FN-23 Exam Questions