Strange. I selected the right answer but I declared me that my choice was wrong!

SELECT SERVERPROPERTY('productversion') as ProductVersion, SERVERPROPERTY('productlevel') as ProductLevel, SERVERPROPERTY('edition') as Edition, SERVERPROPERTY('ProductMajorVersion') as ProductMajorVersion, SERVERPROPERTY('ProductMinorVersion') as ProductMinorVersion

This feature is awesome!

Though I scored correctly but eager to know if there is any specific logic behind not to have alter statements in place instead of Delete and Create!!

Had a doubt between option # 2 and 4...but I finally decided to go by option # 4 (Rows with 20 or less characters are passed through to the output....

Is Part 2 of the same topic published?

Ha.Ha. 🙂

I thought all 4 are required to make the password strong.

It must contain uppercase letters.

It must contain lowercase letters.

It must contain numbers.

It must contain non-alphanumeric characters; for example, #, %,...

Why not option 2?

Per the link : "http://www.sqlshack.com/the-dbas-guide-to-stretch-database/"

Below are the data types which are not supported:

filestream

timestamp

sql_variant

XML

geometry

geography

hierarchyid

CLR user-defined types (UDTs)

-- Considering this I was thinking why not "dateoffset", in place of text/image?

Good Question. I did a lot of research before answering to this question (which I never do mostly). Perhaps, scored 1 mark. Typically, I found that this is the normal...

https://technet.microsoft.com/en-us/library/ms144275(v=sql.110).aspx

Got it directly from here.

https://msdn.microsoft.com/en-us/library/bb933866.aspx

By the way, I used to have under impression that IO is not controlled via RG.

Resource management is limited to the SQL Server Database Engine. Resource Governor can not be used for Analysis Services, Integration Services, and Reporting Services.

Yep, got 1 mark!

JSON is supported in SQL 2016, but could not find such restriction with a mix of JSON with In Memory OLTP. It is in the beginning stage to tick the...

Quite logical that why the semi-colon is available...