SQL Server 2016 REF 70-761 question

Question

SQL Server 2016 REF 70-761 question

windmolinos

Valued Member

Points: 61
More actions
April 4, 2018 at 3:18 am

#410384

Hi guys, I'm new here. Nice to meet you all.
I'm preparing certifications 70-761 and 70-762.
I found some exams in the web, for example this one:
https://issuu.com/passleader_dumps/docs/2017_passleader_70-761_dumps_with_v_78af2bf0d381e1/17
But, seriously, I really don't understand some of the solutions given.
For example, question 55, do you agree with the answer G?
Thanks in advance.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Joe Torre SSChampion Points: 10248 More actions · Answer 1

I would have chosen H as DateCreated would tell you when the row was added but only if it is set properly as it has no default and is defined as NOT NULL.

ScottPletcher SSC Guru Points: 101202 More actions · Answer 2

Ethically, I don't like commenting at all on test dumps.

But G isn't right either, no matter what MS says. The valid datetime comparison for the year of 2014 is:
date >= '20140101' AND date < '20150101' /* not <=/BETWEEN */
The BETWEEN method allows an answer on 20150101 at exactly midnight to count toward both 2014 and 2015, which is clearly incorrect.

Edit: G could be the "most right" of the answers presented (I've only looked at G and H), but it isn't completely correct. H is more wrong because it misses anything past midnight for Dec 31, 2014 (A datetime of '20141231' has a time of midnight, by default.)

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

windmolinos Valued Member Points: 61 More actions · Answer 3

ScottPletcher - Wednesday, April 4, 2018 1:22 PM
Ethically, I don't like commenting at all on test dumps.
But G isn't right either, no matter what MS says. The valid datetime comparison for the year of 2014 is:
date >= '20140101' AND date < '20150101' /* not <=/BETWEEN */
The BETWEEN method allows an answer on 20150101 at exactly midnight to count toward both 2014 and 2015, which is clearly incorrect.
Edit: G could be the "most right" of the answers presented (I've only looked at G and H), but it isn't completely correct. H is more wrong because it misses anything past midnight for Dec 31, 2014 (A datetime of '20141231' has a time of midnight, by default.)

Thanks for your answer, but notice that the question is about the creation date, while G is showing all records that were active (not created).
Or maybe I'm confussed. :doze: