1. You have a slow Map Reduce job. You need to optimize the job to control the number of mapper and runner tasks. Which function should you use?

2. You have a Microsoft SQL Server instance that has R Services (In-Database) installed. The server has a comma-separated values (CSV) file stored in the local file system. For analytic purposes, you need to read the CSV file into a database table in the SQL Server instance. You connect to the SQL Server instance by using SQL Server Management Studio. What should you use from sp_execute_external_script?

3. You need to build a model that looks at the probability of an outcome. You must regulate between L1 and L2. Which classification method should you use?

4. You need to run a large data tree model by using rxDForest. The model must use cross validation. Which rxDForest option should you use?

5. You need to evaluate the significance of coefficients that are produced by using a model that was estimated already. Which function should you use?

6. You have a dataset that contains the physical characteristics of people. You need to visualize a relationship between height and weight for a subset of observations in the dataset. What should you use?

7. You plan to read data from an Oracle database table and to store the data in the file system for later processing by dplyrXdf. The size of the data is larger than the memory on the server to be used for modelling. You need to ensure that the data can be processed by dplyrXdf in the least amount of time possible. How should you transfer the data from the Oracle database?

8. You have one-class support vector machines (SVMs). You have a large dataset, but you do not have enough training time to fully test the model. What is an alternative method to validate the model?

9. You have a Microsoft SQL Server instance that has R Services (In-Database) installed. You need to monitor the R jobs that are sent to SQL Server. Solution: You register an Extended Events package. Does this meet the goal?

10. You have an Apache Hadoop Hive data warehouse. RevoScalerR is not installed. You need to sort the data according to the variables in the dataset. What should you do?

11. You have a data source that is larger than memory. You need to visualize the distribution of the values for a variable in the data source. What should you use?

12. You have a dataset. You need to repeatedly split randomly the dataset so that 80 percent of the data is used as a training set and the remaining 20 percent is used as a test set. Which method should you use?

13. You use dplyrXdf, and you discover that after you exit the session, the output files that were created were deleted. You need to prevent the files from being deleted. Solution: You use dplyrXdf with the persist verb. Does this meet the goal?

14. You have a Microsoft SQL Server instance that has R Services (In-Database) installed. You need to monitor the R jobs that are sent to SQL Server. Solution: You call a function from the RevoPemaR package. Does this meet the goal?

15. You build a model that uses xyz regression. You need to estimate a model that predicts a binary variable. Which function should you use?

16. You have a Microsoft SQL Server instance that has R Services (In-Database) installed. You need to monitor the R jobs that are sent to SQL Server. Solution: You create an events trace configuration file and place the file in the same directory as the BXLServer process. Does this meet the goal?