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?
A.
RxSqlServerData and specify the CSV file path in the connection string
B.
rxDataStep and specify the CSV file path as the inFile argument
C.
rxImportToXdf and specify specify the CSV file as the input
D.
read.csv and specify the CSV file path as the parameter
New 70-773 Exam Questions and Answers Updated Recently (27/Dec/2017):
NEW QUESTION 1
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
NEW QUESTION 2
You have a dataset. You need to repeatedly split randomly the dataset so that 80% of the data is used as a training set and the remaining 20% is used as a test set. Which method should you use?
A. threshold
B. binary classification
C. imputation
D. cross validation
E. pruning
Answer: D
NEW QUESTION 3
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?
A. Yes
B. No
Answer: A
NEW QUESTION 4
You need to calculate a measure of central tendency and variability for the variables in a dataset that is grouped by using another categorical variable. What should you use?
A. the Describe package
B. the rxHistogram function
C. the rxSummary function
D. the rxQuantile function
E. the rxCube function
F. the summary function
G. the rxCrossTabs function
H. the ggplot2 package
Answer: C
NEW QUESTION 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?
A. rxPredict
B. rxLogit
C. summary
D. rxLinMod
E. rxTweedie
F. stepAic
G. rxTransform
H. rxDataStep
Answer: D
NEW QUESTION 6
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
NEW QUESTION 7
You need to use the ScaleR distributed processing in an Apache Hadoop environment. Which data source should you use?
A. Microsoft SQL Server database
B. XDF data files
C. ODBC data
D. Teradata database
Answer: B
NEW QUESTION 8
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?
A. RxComputeContext
B. RxHadoopMR
C. RxExec
D. RxLocalParallel
Answer: C
NEW QUESTION 9
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?
A. Two-Class Neutral Network
B. Two-Class Support Vector Machine
C. Two-Class Decision Forest
D. Two-Class Logistic Regression
Answer: D
NEW QUESTION 10
You are planning the compute contexts for your environment. You need to execute rx-function calls in parallel. What are three possible compute contexts that you can use to achieve this goal? (Each correct answer presents a complete solution. Choose three.)
A. Local parallel
B. Spark
C. Local sequential
D. Map Reduce
E. SQL
Answer: ABD
NEW QUESTION 11
……
P.S. These New 70-773 Exam Questions Were Just Updated From The Real 70-773 Exam, You Can Get The Newest 70-773 Dumps In PDF And VCE From — https://www.passleader.com/70-773.html (45q VCE and PDF)
Good Luck!
Besides, part of that new 45Q 70-773 dumps are available here:
https://drive.google.com/open?id=11Ck4s9emCR_yMAeYu58_vudOR32OfJXY
Best Regards!