Does this meet the goal?

Note: This question is part of a series of Questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, whale others might not have a correct solution-After you answer a question in this section, you will NOT be able to return to it- As a result, these questions will not appear in the review screen.

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 remove all instances of the file.remove method.

Does this meet the goal?
A . Yes
B . No

Answer: B

Does this meet the goal?

Note: This question is part of a series of Questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, whale others might not have a correct solution-After you answer a question in this section, you will NOT be able to return to it- As a result, these questions will not appear in the review screen.

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?
A . Yes
B . No

Answer: B

Does this meet the goal?

Note: This question is part of a series of Questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, whale others might not have a correct solution-After you answer a question in this section, you will NOT be able to return to it- As a result, these questions will not appear in the review screen.

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?
A . Yes
B . No

Answer: B

What should you use from sp_execute_external_script?

You have a Microsoft SQI 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?
A . RxSqIServerData and specify the CSV file path in the connecting string.
B . rxDataStep and specify the CSV lite path as the inFile argument
C . rxImportToXdf and specify the CSV file as the input
D . read.csv and specify the CSV file path as the parameter.

Answer: D

Does this meet the goal?

Note: This question is part of a series of Questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, whale others might not have a correct solution-After you answer a question in this section, you will NOT be able to return to it- As a result, these questions will not appear in the review screen.

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 rxSetComputeContext with the local parameter before performing operations that save results.

Does this meet the goal?
A . Yes
B . No

Answer: B

Does this meet the goal?

Note: This question is part of a series of Questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, whale others might not have a correct solution-After you answer a question in this section, you will NOT be able to return to it- As a result, these questions will not appear in the review screen.

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?
A . Yes
B . No

Answer: B

Does this meet the goal?

Note: This question is part of a series of Questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, whale others might not have a correct solution-After you answer a question in this section, you will NOT be able to return to it- As a result, these questions will not appear in the review screen.

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 rxSetComputeContext with the local parameter before performing operations that save results.

Does this meet the goal?
A . Yes
B . No

Answer: B

Which R code segment should you use?

DRAG DROP

You are using rxPredict for a logistic regression model.

You need to obtain prediction standard errors and confidence intervals.

Which R code segment should you use?

To answer, drag the .impropriate values to the correct targets. Each value may be used once, more than once, or not .You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Answer:

How should you transfer the data from the Oracle database?

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 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?
A . Define a data source to the Oracle database server by using RxOdbcData. Use rxlmport to save the data to a comma separated values (CSV) file.
B . Use the RODBC library, connect to the Oracle database server by using odbcConnect. and then use rxDataStep to export the data to a comma-separated values (CSV) file.
C . Define a data source to the Oracle database server by using RxOdbcData, and then use rxlmport to save the data to an XDF file.
D . Use the RODBC library, connect to the Oracle database server by using odbcConnect. and then use rxSplit to save the data to multiple comma-separated values (CSV) files.

Answer: C