Vendor
: Microsoft
Exam Code : 70-463
Version: Demo
Cheat-Test, help you pass any IT exam!
Cheat-Test.com - The Worldwide Renowned IT Certification Material Provider! The safer, easier way to help you pass any IT Certification exams.
We provide high quality IT Certification exams practice questions and answers (Q&A). Especially Cisco, Microsoft, HP, IBM, Oracle, CompTIA, Adobe, Apple, Citrix, EMC, Isaca, Avaya, SAP and so on. And help you pass an IT Certification exams at the first try.
Cheat-Test product Features: •
Verified Answers Researched by Industry Experts
•
Questions updated on regular basis
•
Like actual certification exams our product is in multiple-choice questions (MCQs).
•
Our questions and answers are backed by our GUARANTEE.
7x24 online customer service: contact@cheat-test.com
Click Here to get more Free Cheat-Test Certification exams!
http://www.Cheat-Test.com
Q: 1 You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing the Fuzzy Lookup transformation. Which of the following is TRUE with regards to the Fuzzy Lookup similarity threshold setting? (Choose all that apply.) A. Increasing the threshold can improve the speed of matching. B. Increasing the threshold can deteriorate the speed of matching. C. The nearer the value is to 1, the nearer the resemblance of the lookup value to the source value must be to qualify as a match. D. The nearer the value is to 1, the further the resemblance of the lookup value to the source value must be to qualify as a match. Answer: A,C Q: 2 You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. You have recently installed Microsoft SQL Server 2012, with SQL Server Integration Services (SSIS), in ABC.com’s environment. You are preparing to install the SSISDB catalog on the SSIS server. Which of the following is TRUE with regards to the SSISDB catalog? (Choose all that apply.) A. You can make use of SQL Server Management Studio to create the SSISDB catalog. B. You can make use of SQL Server Data Tools to create the SSISDB catalog. C. You can make use of Solution Explorer to create the SSISDB catalog. D. You can make use of Windows PowerShell to create the SSISDB catalog programmatically. Answer: A,D Q: 3 You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. ABC.com has a SQL Server Integration Services (SSIS) package that is currently deployed on the file system. The package is configured to interact work together with an outside vendor data feed. It has been reported that the outside vendor data feed is erratic as a result of network failures and slow response times. You have been instructed to investigate the problem. Your solution must include information about the Start Time, End Time, Execution Result, and Execution Duration of the package. You start by creating a new project and adding the package to it. You then deployed the package to the msdb database. Which of the following actions should you take NEXT? A. You should consider querying the ExecutionlLog table. B. You should consider viewing the SSISDB catalog. C. You should consider viewing the SQL Agent Error Log. D. You should consider viewing the SQL Server Log. Answer: A Q: 4 You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing a tool that executes scheduled administrative tasks in SQL Server 2012.
Which of the following is the tool you are discussing? A. Object Explorer B. SQL Server Agent C. Template Explorer D. Solution Explorer Answer: B Q: 5 You work as a senior database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing an event handler provided by Integration Services that is raised by an executable to establish if it should stop running. Which of the following is the event handler you are discussing? A. The OnPostExecute event handler B. The OnQueryCancel event handler C. The OnError event handler D. The OnProgress event handler Answer: B