MS SQL Server - 98 - Machine Learning MCQ

98 – Machine Learning MCQ

1 / 25

1. What is the primary purpose of SQL Server Machine Learning Services?

C. To perform data analysis and machine learning

D. To generate reports

A. To manage databases

B. To automate data entry

2 / 25

2. Which language is commonly used for writing machine learning scripts in SQL Server?

D. Ruby

B. Java

A. Python

C. C++

3 / 25

3. In SQL Server Machine Learning Services, what is the purpose of the “R” in R Services?

B. Regression

A. Reporting

D. Relevance

C. Redundancy

4 / 25

4. What is the primary function of the “PREDICT” function in SQL Server Machine Learning?

B. To make predictions based on a trained model

C. To calculate statistical measures

D. To display data visualization

A. To generate random numbers

5 / 25

5. Which SQL Server edition(s) support the use of Machine Learning Services?

C. Developer Edition only

B. Express Edition only

D. All editions

A. Standard Edition and Enterprise Edition

6 / 25

6. What is the primary difference between supervised and unsupervised machine learning?

B. Unsupervised learning requires labeled data, while supervised learning does not.

C. Supervised learning is faster than unsupervised learning.

D. Unsupervised learning is more accurate than supervised learning.

A. Supervised learning requires labeled data, while unsupervised learning does not.

7 / 25

7. In SQL Server, what is a common use case for clustering algorithms in machine learning?

C. Grouping similar data points

D. Data summarization

B. Classification of data

A. Predicting numeric values

8 / 25

8. What is the purpose of the “TRAIN” statement in SQL Server Machine Learning?

B. To calculate statistical measures

D. To generate SQL queries

C. To create and train a machine learning model

A. To evaluate model performance

9 / 25

9. In SQL Server Machine Learning, which function is used to split data into training and testing sets?

C. SPLIT

B. TRAIN_TEST_SPLIT

D. PARTITION

A. SPLIT_DATA

10 / 25

10. What is a key advantage of using SQL Server Machine Learning Services over standalone machine learning platforms?

C. SQL Server is more cost-effective.

B. SQL Server can perform machine learning directly on database data.

D. SQL Server requires less computational resources.

A. SQL Server offers more advanced machine learning algorithms.

11 / 25

11. In SQL Server, what is the primary use of the “PERSISTED” option in machine learning models?

D. To reduce model complexity

C. To persist the model in the database

B. To store the model in memory

A. To improve model accuracy

12 / 25

12. What is the primary function of the “SCORE” function in SQL Server Machine Learning?

D. To apply a trained machine learning model to new data

A. To score the performance of a machine learning model

B. To calculate statistical measures

C. To display data visualization

13 / 25

13. What is the purpose of feature engineering in machine learning?

C. To evaluate model performance

B. To remove features from the dataset

D. To select the best machine learning algorithm

A. To create new features from existing data

14 / 25

14. In SQL Server Machine Learning Services, which library is commonly used for deep learning?

A. scikit-learn

C. pandas

B. TensorFlow

D. NumPy

15 / 25

15. What is cross-validation in the context of machine learning?

B. A method for validating machine learning models using different algorithms

D. A process of checking data quality before training a model

A. A technique to divide data into training and testing sets

C. A way to evaluate model performance by splitting data multiple times

16 / 25

16. In SQL Server Machine Learning, what is the purpose of the “REVO_RUNR” function?

C. To create machine learning models

A. To execute R scripts

B. To calculate statistical measures

D. To visualize data

17 / 25

17. What is the primary goal of feature selection in machine learning?

A. To create new features from existing data

B. To improve model accuracy

C. To reduce model complexity

D. To calculate statistical measures

18 / 25

18. In SQL Server Machine Learning Services, which function is used to evaluate the performance of a machine learning model?

B. SCORE

D. PREDICT

C. TRAIN

A. EVALUATE

19 / 25

19. Which algorithm is commonly used for regression tasks in machine learning?

B. k-means

A. Decision tree

C. Naive Bayes

D. Linear regression

20 / 25

20. What is the primary purpose of ensemble learning in machine learning?

D. To visualize data

A. To train models on large datasets

C. To create deep learning models

B. To improve model performance by combining multiple models

21 / 25

21. In SQL Server, what is a common use case for time series forecasting in machine learning?

D. Data summarization

B. Predicting future stock prices

A. Image recognition

C. Clustering similar data points

22 / 25

22. What is the main advantage of using SQL Server Machine Learning for real-time scoring of models?

C. It supports only batch scoring.

B. It allows models to be deployed and scored within the database.

D. It is not suitable for real-time scoring.

A. It requires less computational resources.

23 / 25

23. What is transfer learning in machine learning?

A. A technique for transferring data between databases

D. A process of transferring models from one platform to another

C. A way to transfer data from a legacy system to a modern database

B. A method for transferring knowledge from one machine learning task to another

24 / 25

24. What is the primary goal of anomaly detection in machine learning?

D. To visualize data

C. To calculate statistical measures

A. To identify unusual patterns or outliers in data

B. To create machine learning models

25 / 25

25. In SQL Server Machine Learning Services, what is the purpose of the “LANGUAGE” option in the “R” and “Python” functions?

A. To specify the database language

B. To set the default language for the database

C. To specify the language of the script to be executed

D. To define the language for the user interface

Your score is

MS SQL Server – 98 – Machine Learning MCQ