SQL Server 2016 Runner's Test

What is the maximum number of cores supported by a database engine instance of SQL Server 2016 Standard?

Which of the following security features is NOT new to SQL Server 2016?

Always Encrypted

Dynamic Data Masking

Transparent Data Encryption

Row Level Security

What value will be displayed for string value 'SQLDay' after using Dynamic Data Masking with function partial(1, 'peedwa', 1)

PeedwaQLday

Speedway

PeedwaSQLDay

Which stored procedure allows to run R scripts inside the SQL Server 2016 database engine?

Sp_execute_r_script

Sp_runr

Sp_execute_script

Sp_execute_external_script

How many rows will the following query produce in SQL Server 2016?

SELECT STRING_SPLIT('SQLDay 2016 rocks!', ' ');

How many replicas are supported by Basic Availability Group feature in SQL Server 2016 Standard Edition?

Which of the following scalar functions is NOT new in SQL Server 2016?

STRING_ESCAPE

SESSION_CONTEXT

COMPRESS

CONTEXT_INFO

How many instances of SQL Server 2016 PolyBase service can run on a single server?

Can Live Query Statistics feature of SQL Server 2016 work with SQL Server 2014 instance?

YES

Which function available in SQL Server 2016 can compress data using GZip algorithm?

COMPRESS

PACK

GZIP

ZIP

What is the purpose of the following statement in SQL Server 2016?

ALTER TABLE dbo.Product SET (SYSTEM_VERSIONING = ON);

Turn on CDC feature

Turn on Change Tracking feature

Turn on data versioning for Temporal Table feature

This is not a valid statement

In what year was the Polish SQL Server User Group (PLSSUG) founded?

2000

2006

2007

2010

Which system view does allow to view database options set with ALTER DATABASE SCOPED CONFIGURATION statement in SQL Server 2016?

Sys.databases

Sys.database_scoped_configurations

Sys.database_configurations

Sys.configurations

What DMV can be used in SQL Server 2016 to show wait stats for a single session?

Sys.dm_exec_session_wait_stats

Sys.dm_exec_sessions

Sys.dm_os_session_wait_stats

Sys.dm_os_wait_stats

Which feature of SQL Server 2016 allows efficient operational analytics?

In-memory OLTP

ColumnStore Indexes

Query Store

Live Query Statistics

Which property has to be used in a predicate function for Row Level Security in SQL Server 2016?

ENCRYPTION

SCHEMABINDING

READONLY

EXTERNAL

SQL Server 2016 Runner's Test

More Quizzes