Passtcert have a strong It expert team to constantly provide you with an effective training resource. They continue to use their rich experience and knowledge to study the real exam questions of the past few years. Finally Passtcert Microsoft certification 70-761 questions answers pdf have advent, which will give a great help to a lot of people participating in the IT certification exams. You can free download part of Passtcert Microsoft certification 70-761 questions answers pdf as a try.
Share some MCSA 70-761 exam questions and answers below.
Which two database objects should you use? Each correct answer presents a complete solution.
A. a user-defined table-valued function
B. a CRL function
C. a stored procedure
D. a user-defined scalar function
Answer: A,C
You have a table named AuditTrail that tracks modifications to data in other tables. The AuditTrail table is updated by many processes. Data input into AuditTrail may contain improperly formatted date time values. You implement a process that retrieves data from the various columns in AuditTrail, but sometimes the process throws an error when it is unable to convert the data into valid date time values. You need to convert the data into a valid date time value using the en-US format culture code. If the conversion fails, a null value must be returned in the column output. The conversion process must not throw an error. What should you implement?
A. the COALESCE function
B. a view
C. a table-valued function
D. the TRY PARSE function
E. a stored procedure
F. the ISNULL function
G. a scalar function
H. the TRY CONVERT function
Answer: H

No comments:
Post a Comment