Free Dell Certified Data Science Foundations Exam D-DS-FN-23 Exam Practice Test

In which programming language is Hadoop written?

• C++
• Scala
• Java
• Python

MapReduce is designed to process data in which way?

• A few large files split into blocks processed in parallel across multiple machines
• Many small files processed serially on one machine
• A few large files split into blocks processed serially on one machine
• Many small files processed in parallel across multiple machines

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

• Project management and administrative skills
• Proficient in Microsoft Project and Excel
• Skeptical and critical thinking
• Accounting and regulatory skills

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

• Building training and testing datasets
• Identifying relationships and correlations among variables
• Deploying the model and monitoring its performance
• Cleaning the data, normalizing datasets. and performing transformations

Which analytic technique would be appropriate to estimate home sale price in U.S. dollars as a function of square footage, number of bedrooms, and lot size?

• Time series analysis
• Linear regression
• Naive Bayesian classification
• K-means clustering

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

• System function
• Aggregate function
• User defined function
• Window function

In association rules, given items X and Y, what does lift measure?

• Percentage of transactions that contain an itemset with X
• Percentage of transactions with Xthat also contain Y
• Difference in the probability ofX and Y appearing together compared with expectations as if they were statistically independent
• How many times more often X and Y occur together than expected if they were statistically independent, expressed as a ratio

What is the primary role of a business intelligence analyst on an analytics project?

• Extracts business data from source systems
• Ensures business milestones are met
• Provides business-domain expertise
• Defines business goals for the analytics project

What are three built-in data types in the R programming language?

• Boolean, integer, and character
• Boolean, table, and character
• Boolean, table, and integer
• List, array, and integer

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

• EXCEPT
• UNION
• UNION ALL
• INTERSECT