- Which predicate can be used when we are looking for the proper version of record in a temporal table?
We can use the FOR SYSTEM_TIME predicate written directly after the temporal table name used in a FROM clause of the query. - Which parameter of the sp_execute_external_script is used to define the parameters passed into the external script?
This is the nvarchar parameter, which is called @params. - What do we need to do with a model stream sent to the sp_execute_external_script stored procedure?
We need to deserialize it.
- Does the PREDICT function work on any predictive model?
No, this function works only with models that are calculated using predictive functions that start with the rx prefix. - Which service is needed for regular model retraining?
The SQL Server Agent. This service is present with any commercial instance of the SQL Server. We should ensure that the...