70-461 exam and date formats

Question

question

AubreyLove asked Apr 15, '19

70-461 exam and date formats

I am studying for the 70-461 exam and was wondering a few things.

First and foremost,

how much emphasis does the exam put on knowledge of the DateTime formats?

for example:

by the book, the date format command to return the date in a mm/dd/yyyy format is

 
SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS 'Date 10-101';

However;

I know that I can get the same results using this condensed version:

 
SELECT CONVERT(CHAR, GETDATE(), 101) AS 'Date 101';

For test purposes, does it matter how I get the results?

Also, do I need to memorize all the date formats or just key ones?

In my day-to-day work, I use my basic date formats. But, if I need the date returned in a specific format, I reference a chart I have made.

Any suggestions would be greatly appreciated.

I’m not looking for answers to the test, just little details about what to expect on the test, like this.

Thanks.

exam-question

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-04-16T11:04:37Z

Lukasz8519 answered Apr 16, '19

i passed 70-761 and i can tell you that i dont rembember question like yours, they are asking about correct funtion definition, sp definition, view definition, you have to build complex queries after reading a requirements

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2019-04-16T14:39:12Z

AubreyLove answered Apr 16, '19

Thanks for the response.

I was wondering about the date format issue. I work with stored procedures and views on a daily basis, but I should get more familiar with them for the test. (Broaden my horizons on these concepts beyond my daily tasks.)

Does anyone know where there is a reliable practice test environment? I have the “Exam 70-461 Querying Microsoft SQL Server 2012” book and the CD that came with it, but I have been told that is nothing like the real test. This test is all “multiple-choice” and as I understand it, the real test has very little multiple-choice questions and a lot of code writing involved.

Is this true?

Thank you.

P.S. I am not a very good test taker, that's why I am asking.

I can perform my duties day-to-day as a DBA, but tests make me nervous and I vapor lock and often read to much into the question. Hence the need for as many practice tests as I can get.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2019-04-19T10:13:56Z

Lukasz8519 answered Apr 19, '19

some people using exam dumps, if you write in google 70-461 exam dums You get many page, where you can check your knowlegde and see what types of question may be in exam,

i wish you good luck on exam

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question