2025 DumpsTorrent EMC D-DS-FN-23 Dumps and Exam Test Engine [Q146-Q163]

NO.146 What provides the means for matching and manipulating text strings in SQL?

NO.147 Which word or phrase completes the statement? Data-ink ratio is to data visualization as _________.

NO.148 Consider the following SQL statement:
SELECT employee_id, year, salary, avg(salary)
OVER
(PARTITION BY employee_id ORDER BY year ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) as result_1 FROM employee ORDER BY employee_id, year For each employee_id, what is returned as result_1?

NO.149 You do a Student’s t-test to compare the average test scores of sample groups from populations A and B.
Group Aaveraged 10 points higher than group B.
You find that this difference is significant, with a p-value of 0.03.
What does that mean?

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

NO.151 The average purchase size from your online sales site is $17, 200. The customer experience team believes a certain adjustment of the website will increase sales.
A pilot study on a few hundred customers showed an increase in average purchase size of $1.47, with a significance level of p=0.1. The team runs a larger study, of a few thousand customers.
The second study shows an increased average purchase size of $0.74, with a significance level of 0.03.
What is your assessment of this study?

NO.152 You are using the Apriori algorithm to determine the likelihood that a person who owns a home has a good credit score. You have determined that the confidence for the rules used in the algorithm is > 75%. You calculate lift = 1.011 for the rule, “People with good credit are homeowners”.
What can you determine from the lift calculation?

NO.153 In which phase of the analytic lifecycle would you expect to spend most of the project time?

NO.154 You are provided with a dataset with the following attributes:
1. Customer ID
2. Gender flag
3. Amount spent in last four quarters
4. Age
5. Number of purchases made in last four quarters
6. Store credit card flag
7. Elite program member flag
Based on the attributes provided, your task is to find an alternate set of rules that helps to define which customers are more or less likely to become “Elite program members”.
Which analytical method would produce the desired rule set?

NO.155 Refer to the exhibit.

Click on the calculator icon in the upper left corner. An analyst is searching a corpus of documents for the topic “solid state disk”.
In the Exhibit, Table A provides the inverse document frequency for each term across the corpus. Table B provides each term’s frequency in four documents selected from corpus.
Which of the four documents is most relevant to the analyst’s search?

NO.156 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?

NO.157 What does “MAD” in MADlib stand for?

NO.158 What is a key consideration when preparing a presentation intended for analysts?

NO.159 In which phase of the data analytics lifecycle do Data Scientists spend the most time in a project?

NO.160 Amajor 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?

NO.161 You have been assigned to do a study of the daily revenue effect of a pricing model of online transactions.
All the data currently available to you has been loaded into your analytics database; revenue data, pricing data, and online transaction data.
You find that all the data comes in different levels of granularity. The transaction data has timestamps (day, hour, minutes, seconds), pricing is stored at the daily level, and revenue data is only reported monthly.
What is your next step?

NO.162 The web analytics team uses Hadoop to process access logs. They now want to correlate this data with structured user data residing in a production single-instance JDBC database. They collaborate with the production team to import the data into Hadoop.
Which tool should they use?

NO.163 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%?