Practice for 70-463 exams with real Questions

In Wisconsin, around the world wide web instructors need to whole thirty many several hours of professional enhancement meant to place together a trainer for to the online education. K-12 colleges a great deal much more furthermore much extra are beginning to contain on-line lessons into their class selections. It could be now furnished in forty eight states which happens to be expanding speedily. Plenty of persons feel that on-line mastering will not be as considerable as learning in a classroom.The nice ingredient about around the world wide web lessons would be the undeniable fact that is Microsoft MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform 70-463 Paper Implementing a Data Warehouse with Microsoft SQL Server 2012 teaches school pupils to be impartial. Pupils specializing in classwork and participation in digital lessons can “go to school” on their own have time and understand to manage their time thoroughly and obtain assignments performed by a certain time. They can relax within their possess location, possess the capability to have lunch nevertheless carrying out schoolwork, don a warmth blanket and hear to music if that could support them concentrate. They can tailor their acquiring out all-natural environment to some thing which precisely suits them. This could trigger additional good results in school plus the wish to Microsoft Exam BrainDumps MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform 70-463 Online Implementing a Data Warehouse with Microsoft SQL Server 2012 learn more.

70-463 Exam Bundle

70-463 exam bundle
Vendor Microsoft
Certification MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform
Exam 70-463
Exam Name Implementing a Data Warehouse with Microsoft SQL Server 2012
Product 70-463 Exam Bundle
Discount 30%
Exam Price $97
Purchase

Microsoft 70-463 Exam Sample Questions

Question: 2

You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night.

The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.

If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.

The current setting for the Fuzzy Lookup similarity threshold is 0.50.

Many values are incorrectly matched.

You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.

What should you do?

  1. Change the Exhaustive property to True.
  2. Change the similarity threshold to 0.55.
  3. Change the similarity threshold to 0.40.
  4. Increase the maximum number of matches per lookup.


Answer: B

Explanation:

http://msdn.microsoft.com/en-us/library/ms137786.aspx

Question: 2

You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night.

The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.

If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.

The current setting for the Fuzzy Lookup similarity threshold is 0.50.

Many values are incorrectly matched.

You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.

What should you do?

  1. Change the Exhaustive property to True.
  2. Change the similarity threshold to 0.55.
  3. Change the similarity threshold to 0.40.
  4. Increase the maximum number of matches per lookup.


Answer: B

Explanation:

http://msdn.microsoft.com/en-us/library/ms137786.aspx

70-463 Exam Bundle Contains

Microsoft 70-463 Exam Preparation Products Features 70-463 questions pdf 70-463 practice test
70-463 Product Demo available available
70-463 Exam Free Updates available available
Special Discount on 70-463 Preparation Material available available
Security and Privacy available available
70-463 Practice Test Engine available available
70-463 PDF Questions & Answers available available
100% Money Back on 70-463 VCE available available
24/7 Support available available
Price $69 $69
Add to Cart

Lets’ facial area it, homeschooling is messy! It will make for merely a messy dwelling, messy children, and an all spherical messier existence. Will not all of us, as homeschool moms, drive for that picture excellent day like inside of a Norman Rockwell painting– a cozyhouse loaded with Microsoft 70-463 exam vce new confronted, bare-footed very little Implementing a Data Warehouse with Microsoft SQL Server 2012 ones, diligently doing away at their schoolwork though the aroma on MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform the pumpkin candle and in addition the appear of Mozart fills the air. Though the majority of us would enjoy for homeschool to seem to be that each day, the simple truth Examcollection 70-463 Engine is, people moments just you should not come about that Implementing a Data Warehouse with Microsoft SQL Server 2012 usually.

24/7

Together with the homeschool mother, motherhood is much more than Microsoft Exam BrainDumps the common “full time job”,it can be 24/7. When my pretty first MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform little one was basically an infant , I comprehended without the need of a doubt,I’d been Microsoft 70-463 exam vce most likely to homeschool. My head was filled with thosehappy minor ones, classical new music, Implementing a Data Warehouse with Microsoft SQL Server 2012 pumpkin-candle visuals. But similar to a mother who worries recognize her sweet, cuddlynewborn will probably be a great deal of operate, I soon realized my image of homeschooling was only a little distinctive MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform Examcollection 70-463 Vce than I initially imagined .

Managed chaos

Within the just before quite a while of homeschooling, I might noticeably considerably less variables Implementing a Data Warehouse with Microsoft SQL Server 2012 which generated for considerably less chaos, which intended additional Norman Rockwell days. Nevertheless, as our relatives expanded and my small Microsoft Exam BrainDumps children grew much more experienced the variables have 70-463 Study exponentially enhanced. Homeschool moms usually should really contend everyday that has a house that continuously will MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform get messy , additional laundry, shuttling children to things Implementing a Data Warehouse with Microsoft SQL Server 2012 to carry out (homeschool topic visits, science fairs and sporting actions), church and shopping–all the though trying to educate, nurture and instruct our 70-463 Study children. And if which is not plenty of to take care of any common person’s head spinning, lots of stay-at-home mothers, like myself, throw a home organization to the blend!

Can Implementing a Data Warehouse with Microsoft SQL Server 2012 it be MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform perfectly really worth it?

The outdated stating, “nothing ventured, basically almost nothing gained” may be a fantastic 70-463 Mock motto for any homeschool mom. The reality is, you would possibly want Microsoft to put it in just the fridge for just a reminder it genuinely is all nicely worthy of it. When there exists no Implementing a Data Warehouse with Microsoft SQL Server 2012 assures in everyday life, there may be certainly a very good possibility that MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform Microsoft 70-463 exam vce every one your hard work,perseverance and sacrifice pays off, not just in your little ones, even so, you likewise.

Mom’s university

For people challenging instances after you aren’t in a position to regulate to get away from your pajamas until eventually midday Implementing a Data Warehouse with Microsoft SQL Server 2012 and almost nothing seems to be going correct, Examcollection 70-463 Vce take into consideration that you are also currently getting “schooled” in the home. Every single day MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform , excellent or detrimental , offers the opportunity to extend and increase along with your little Microsoft ones. The chaos which includes to become managed, the temper which has to Implementing a Data Warehouse with Microsoft SQL Server 2012 become managed and Examcollection 70-463 Vce sacrifice of private wants and wantsis a recipe for a”seasoned” mother and hopefully , a noticeably wiser lady.

Inside your young children, those people non-perfect, anxiety stuffed days express with it a design MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform of “real life’. The good news?Both you and your youthful kids can accomplish by way of 70-463 Mock these difficulties Implementing a Data Warehouse with Microsoft SQL Server 2012 jointly for the kin.Every day, regardless of if loaded with chaos or peace is frequently a treasured gem that only arrives about with the time. So irrespective of whether you’re possessing a still-in-your-pajamas-at-noon operating working day or perhaps a pumpkin candle/Norman Rockwell doing the job day,just MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform Examcollection 70-463 Vce choose a second to Microsoft Exam BrainDumps stop and fully Implementing a Data Warehouse with Microsoft SQL Server 2012 grasp that you’ll be investingmemories and time employing your small types and each day is basically a blessing. …regardless how messy.

Question: 1

You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to download sales transaction data.

You create project parameters to store the username and password that are used to access the FTP site.

You need to ensure that the username and password values are encrypted when they are deployed.

What should you do?

  1. Set the Sensitive property of the parameters to True.
  2. Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.
  3. Change the parameters to package parameters.
  4. Change the project to the Legacy Deployment model.


Answer: A

The moment you select to dwelling faculty, a different product on the mind could be “What am I desiring to use to property college or university?” While it’d be very simple 70-463 Guide to freak out right now and never invest in something at all because you never know MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform where by to start, it genuinely is just as easy to go out and expend Examcollection 70-463 vce an incredible total of cash of money pondering you could possibly need to get the most expensive computer software. Neither amongst these eventualities should be the case when selecting domestic college Microsoft Examcollection 70-463 vce Implementing a Data Warehouse with Microsoft SQL Server 2012 curriculum MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform and publications.

Hands down, among the biggest considerations about homeschooling would be the dread that homeschool learners will not be mastering successful social capabilities or aren’t remaining the right way socialized. The presumption is, just Examcollection Microsoft 70-463 Exams one with the easiest approaches to socialize your son or daughter is always to get it performed Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012 through substantial gatherings of same-age friends, and without the will need of possessing these standard interactions, 70-463 Engine very little ones will one way or the other be lacking out on important learning activities. Wherever by does the truth fulfill up with the presumption, and specifically how does homeschooling truly influence Examcollection 70-463 Mock a Microsoft MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform Implementing a Data Warehouse with Microsoft SQL Server 2012 kid’s social competencies?

When most father and mother want to mail their minor kinds to highschool, there are many who favor homeschooling. Educating your youngster in the satisfaction with the personal home could be described as a wonderful notion having said that it does have Examcollection 70-463 Engine its own professionals Implementing a Data Warehouse with Microsoft SQL Server 2012 and downsides. It could be crucial that you choose MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform to decide on to give a variety of aspects of homeschooling a significant imagined just before you compromise in for a similar.

You have for becoming huge structured before you decide 70-463 Dump & Study to start out homeschooling in your Implementing a Data Warehouse with Microsoft SQL Server 2012 quite minimal sorts. Your each individual day regimen will have to be correctly structured with noticeable distinctions relating MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform to Microsoft personal time and schooling time. If you will not make these distinctions lucid in excess of adequate, Examcollection 70-463 Engine your education may perfectly not be as thriving once Implementing a Data Warehouse with Microsoft SQL Server 2012 you would like it for currently being.

Another transfer might be to ascertain the curriculum towards your youngster. You will discover essentially several issues that you’ve got bought MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform to show your kid. The purely real 70-463 questions natural way, you’d wish to teach your son or daughter critical reading Implementing a Data Warehouse with Microsoft SQL Server 2012 by, developing and also arithmetic. But, you will explore a terrific range of other things that you just have to educate your child about.

Restricting the youthful one’s syllabus simply to Microsoft 70-463 exam the bookish recognition will never support MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform during the Microsoft Exam BrainDumps minimum. It really is similarly as really Implementing a Data Warehouse with Microsoft SQL Server 2012 critical to assist make your son or daughter abreast though utilizing the functions all around. For this, you can possibly get into account introducing topics like atmosphere, real 70-463 questions standard knowledge, history and tradition inside your kid’s syllabus. And what exactly is a great deal more? Chances MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform Implementing a Data Warehouse with Microsoft SQL Server 2012 are you will educate your toddler with regards to the great importance of well being and health and fitness and different over-all health circumstances Microsoft 70-463 exam like yeast an infection. Whenever your baby is battling an analogous difficulty, you may assume about working with Yeastrol Yeast Infection Implementing a Data Warehouse with Microsoft SQL Server 2012 Remedy to set the situation straight as soon as MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform for all.

In combination Microsoft with concentrating on academic information, moreover, you actually must Examcollection 70-463 Engine give some rate to added curricular routines. Have a while allotted to entertaining steps which include things like experiencing recreation titles, portray or incorporating Implementing a Data Warehouse with Microsoft SQL Server 2012 any interest course within the examine prepare. You may even practice yoga for any facet of this kind MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform Examcollection 70-463 Engine of enjoyable routines. It really is planning to not just current your young children the specified rest but additionally offer you a number of health and fitness Implementing a Data Warehouse with Microsoft SQL Server 2012 pros.

When finding homeschooling, you ought to be chosen that you choose to simply just make 70-463 Mock a surroundings which is surely related to highschool. Designate a particular spot MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform in the property for Microsoft education only. Have all useless interruptions off from this education spot. Be sure that Implementing a Data Warehouse with Microsoft SQL Server 2012 you just manage your pet canine significantly from this location considerably much real 70-463 questions too else your younger kinds will never take care of to concentration on just what is acquiring taught. Developing a significant surroundings will make MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform sure that the kids will likely not think about Implementing a Data Warehouse with Microsoft SQL Server 2012 that they are not probable to substantial college.

Homeschooling isn’t real 70-463 questions truly a bad considered in any respect. In reality, if used whilst from the very best way it might establish to get efficient when compared to the normal instruction. But, it can be essentially essential that MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform Implementing a Data Warehouse with Microsoft SQL Server 2012 you get ready for it Microsoft Exam BrainDumps well Microsoft 70-463 exam else you’re planning to not deal with to impart top of the range education and learning and studying for the young only one.

Question: 3

You install a SQL Server 2012 database engine instance on a production server. A month later, you install SQL Server 2012 Integration Services (SSIS).

You must develop an SSIS project and deploy it to the server by using the Project Deployment model.

Operations Log records that are outside the configured retention period must be cleaned automatically.

You need to create the SSIS catalog on the production server.

What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  1. Enable XP Command Shell.
  2. Enable CLR Integration.
  3. Enable OLE Automation.
  4. Start the SQL Server Browser service.
  5. Enable Cross Database Ownership Chaining
  • Start the SQL Server Agent service
  • Enable Ad Hoc Remote Queries.

  • Answer: B, F

    Just in case you actually undoubtedly are a high-achieving highschool college university student, you have most likely been recommended sooner or later to “take the toughest classes your college offers.”It’s possible you’ll have go through, “Colleges want a scholar who took Subtle Placement courses and received A-‘s or B’s much more than a pupil who bought A’s but took only straightforward classes. They prefer to see that you have MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform challenged your self.”There may be unquestionably a motive elite schools love to see you have challenged your self in highschool: It can be for the reason that college or university classes are on the full much additional difficult than highschool classes. In the event you haven’t been completely prepared for your issue of Advanced Placement classes, how will you be all set for that dilemma with the noticeably more Microsoft MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform Microsoft 70-463 exam Implementing a Data Warehouse with Microsoft SQL Server 2012 difficult university classes?

    With far more moreover additional corporations making their entrance on earth marketplace, levels of competitors for patrons is fiercer than previously previous to. It’s received that’s why arrive at be Examcollection 70-463 Sheets essential for each government, supervisor, and enterprise entity to accomplish each individual detail they Implementing a Data Warehouse with Microsoft SQL Server 2012 can be able to aid maintain an edge in the present aggressive existing industry. A technique 70-463 Tests to try and do that is via MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform the main MBA application. Who enrolls in this particular system and what has designed it so common?

    Almost all individuals who enroll Implementing a Data Warehouse with Microsoft SQL Server 2012 in Microsoft the Examcollection 70-463 Sheets govt MBA process are people today who are now in management or govt positions in addition to have been performing operate for the duration of the modest company sector in 70-463 exam vce your essential stretch of your time. These folks have labored their way Implementing a Data Warehouse with Microsoft SQL Server 2012 close to MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform these placement from lesser positions much more than the numerous years and have the abilities and 70-463 Tests techniques to assist you to make the businesses they can be connected with lucrative.

    However, with new graduates coming in fresh away from master’s plans wherein they Implementing a Data Warehouse with Microsoft SQL Server 2012 may have Microsoft discovered one Examcollection 70-463 Tests of the most up-to-date firm theories and management practices moreover the altering deal with from your business planet these attempted and MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform correct gurus have taken the massive phase to up Examcollection 70-463 Exact their activity and obtain their very own MBA degree to Implementing a Data Warehouse with Microsoft SQL Server 2012 have the ability to convey added into your desk than ever before ahead of.

    The majority of the persons enrolling from 70-463 Tests your the main MBA programs are speedy paced executives, normally people today with ten or even much more many yrs little enterprise expertise who’ll Implementing a Data Warehouse with Microsoft SQL Server 2012 be looking for Microsoft advancement MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform or trying 70-463 exam vce to get to take care of the intense edge. These individuals today cannot pay for to disappear their occupations they have applied decades building so as to pursue their degree 70-463 exam vce and so critical a process that may fulfill Implementing a Data Warehouse with Microsoft SQL Server 2012 equally of individuals their operate and educational calls for.

    That could be why the supervisor MBAs packages are so well-known they enable folks Examcollection 70-463 Sheets that are now functioning with MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform the organization issue to hold on functioning entire time whilst getting the added schooling they require that Implementing a Data Warehouse with Microsoft SQL Server 2012 may assist them go Microsoft on to attain inside Examcollection 70-463 Guide the professions they adore. These apps also present firms a method to give their valued and advantageous employees members the minimum much more schooling they need to aid the business Examcollection 70-463 Tests maximize to new heights.

    By giving these Implementing a Data Warehouse with Microsoft SQL Server 2012 college students a flexible timetable or MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform perhaps the choice to decide on the classes on the net these programs enable it to be possible Examcollection 70-463 Exact for performing perform business males and women to generate their MBA diploma whilst nonetheless supplying treasured administration techniques to their Implementing a Data Warehouse with Microsoft SQL Server 2012 providers. Additionally, the manager MBA Microsoft program will permit executives to Examcollection 70-463 Guide bolster their negotiation abilities, produce new management skills and also to sharpen these abilities they have already got.

    During this MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform earth, where ever compact small business enterprises go total entire world 70-463 exam vce big, possessing the experience Implementing a Data Warehouse with Microsoft SQL Server 2012 competencies and determination to correctly be a chief and aid opt for your group to your up coming degree is very important. Owning the education and 70-463 Tests learning and learning to productively execute people today options is of significant really worth in the present fast Implementing a Data Warehouse with Microsoft SQL Server 2012 paced whole planet. The chief MBA Microsoft program offers MCSE Business Intelligence/MCSA/MCSA SQL Server 2012/Microsoft SQL Server/MCTS/MCSM/MCSA 2012/MCSE Data Platform these pros decided to Examcollection 70-463 Tests sharpen their methods the devices they should compete that features a youthful era on an equal footing.

    Question: 2

    You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night.

    The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.

    If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.

    The current setting for the Fuzzy Lookup similarity threshold is 0.50.

    Many values are incorrectly matched.

    You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.

    What should you do?

    1. Change the Exhaustive property to True.
    2. Change the similarity threshold to 0.55.
    3. Change the similarity threshold to 0.40.
    4. Increase the maximum number of matches per lookup.


    Answer: B

    Explanation:

    http://msdn.microsoft.com/en-us/library/ms137786.aspx

    Question: 2

    You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night.

    The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.

    If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.

    The current setting for the Fuzzy Lookup similarity threshold is 0.50.

    Many values are incorrectly matched.

    You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.

    What should you do?

    1. Change the Exhaustive property to True.
    2. Change the similarity threshold to 0.55.
    3. Change the similarity threshold to 0.40.
    4. Increase the maximum number of matches per lookup.


    Answer: B

    Explanation:

    http://msdn.microsoft.com/en-us/library/ms137786.aspx