PC0-001 Related Links

PC0-001 Dropmark  |  
Go through Pass4sure PEOPLECERT PC0-001 Q A before test - brothelowner

I want real Questions of PC0-001 examination.

PC0-001 sample questions | PC0-001 practice exam | PC0-001 prep questions | PC0-001 test prep | PC0-001 boot camp - brothelowner.com



PC0-001 - ITIL 2011 Foundation - Dump Information

Vendor : PEOPLECERT
Exam Code : PC0-001
Exam Name : ITIL 2011 Foundation
Questions and Answers : 131 Q & A
Updated On : December 15, 2017
PDF Download Mirror : [PC0-001 Download Mirror]
Get Full Version : Pass4sure PC0-001 Full Version

Pass4sure PC0-001 Practice Tests with Real Questions


If you are looking for PC0-001 Practice Test containing Real Test Questions, you are at right place. We have compiled database of questions from Actual Exams in order to help you prepare and pass your exam on the first attempt. All training materials on the site are Up To Date and verified by our experts.

Killexams.com provide latest and updated Practice Test with Actual Exam Questions and Answers for new syllabus of PEOPLECERT PC0-001 Exam. Practice our Real Questions and Answers to Improve your knowledge and pass your exam with High Marks. We ensure your success in the Test Center, covering all the topics of exam and build your Knowledge of the PC0-001 exam. Pass 4 sure with our accurate questions.

100% Pass Guarantee

Our PC0-001 Exam PDF contains Complete Pool of Questions and Answers and Brain dumps checked and verified including references and explanations (where applicable). Our target to assemble the Questions and Answers is not only to pass the exam at first attempt but Really Improve Your Knowledge about the PC0-001 exam topics.

PC0-001 exam Questions and Answers are Printable in High Quality Study Guide that you can download in your Computer or any other device and start preparing your PC0-001 exam. Print Complete PC0-001 Study Guide, carry with you when you are at Vacations or Traveling and Enjoy your Exam Prep. You can access updated PC0-001 Exam Q&A from your online account anytime.

nside seeing the bona fide exam substance of the mind dumps at killexams.com you can without a lot of an extend develop your claim to fame. For the IT specialists, it is basic to enhance their capacities as showed by their work need. We make it basic for our customers to carry certification exam with the help of killexams.com affirmed and honest to goodness exam material. For an awesome future in its domain, our mind dumps are the best decision. A best dumps creating is a basic segment that makes it straightforward for you to take PEOPLECERT accreditations. In any case, PEOPLECERT braindumps PDF offers settlement for candidates. The IT assertion is a critical troublesome endeavor if one doesn't find genuine course as obvious resource material. Thus, we have genuine and invigorated substance for the arranging of affirmation exam. It is fundamental to collect to the guide material in case one needs toward save time. As you require packs of time to look for revived and genuine examination material for taking the IT accreditation exam. If you find that at one place, what could be better than this? It's simply killexams.com that has what you require. You can save time and maintain a strategic distance from trouble in case you buy Adobe IT accreditation from our site.

Killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for all exams on website
PROF17 : 10% Discount Coupon for Orders greater than $69
DEAL17 : 15% Discount Coupon for Orders greater than $99
DECSPECIAL : 10% Special Discount Coupon for All Orders


Download your ITIL 2011 Foundation Study Guide immediately after buying and Start Preparing Your Exam Prep Right Now!


Killexams.com Discount Coupon, Killexams Promo Codes, PC0-001 vce, Free PC0-001 vce, Download Free PC0-001 dumps, Free PC0-001 braindumps, pass4sure PC0-001, PC0-001 practice test, PC0-001 practice exam, killexams.com PC0-001, PC0-001 real questions, PC0-001 actual test, PC0-001 PDF download, Pass4sure PC0-001 Download, PC0-001 help, PC0-001 examcollection, Passleader PC0-001, exam-labs PC0-001, Justcertify PC0-001, certqueen PC0-001, PC0-001 testking

View Full Exam »



It is unbelieveable, but PC0-001 Actual Questions are availabe here.

candidates spend months seeking to get themselves organized for his or her PC0-001 assessments however for me it changed into all just a days paintings. you would wonder how a person could be able to finish this type of awesome venture in only a day let me let you know, all I needed to do turned into sign up my

it's miles unbelieveable, but PC0-001 today's Braindumps are availabe right here.

Passing the PC0-001 exam turned into quite hard for me until i was added with the query & solution through killexams. a number of the topics appeared very hard to me. tried plenty to study the books, however failed as time was quick. subsequently, the sell off helped me understand the topics and wrap up my instruction in 10 days time. amazing guide, killexams. My heartfelt way to you.

preparing PC0-001 exam is rely of some hours now.

PC0-001 exam was really tough for me as I was not getting enough time for the preparation. Finding no way out, I took help from the dump. I also took help from Official Certification Guide. The dump was amazing. It dealt with all the topics in an easy and friendly manner. Could get through most of them with little effort. Answered all the question in just 81 minutes and got 97 mark. Felt really satisfied. Thanks a lot to killexams.com for their priceless guidance.

I put all my efforts on Internet and found killexams PC0-001 real question bank.

I will suggest you to come here to remove all fears related to PC0-001 certification because this is a great platform to provide you with assured goods for your preparations. I was worried for PC0-001 exam but all thanks to killexams.com who provided me with great products for my preparation. I was really worried about my success but it was only PC0-001 exam engine that increased my success confidence and now I am feeling pleasure on this unconditional help. Hats off to you and your unbelievable services for all students and professionals!

i'm very glad with PC0-001 exam manual.

yes, very beneficial and i was capable of score eighty two% in the PC0-001 examination with 5 days coaching. particularly the facility of downloading as PDF documents for your package gave me an amazing room for effective practice coupled with on line tests - no constrained tries limit. solutions given to each question by way of you is a hundred% accurate. thanksloads.

found maximum PC0-001 Questions in real exam that I prepared.

extraordinarily beneficial. It helped me bypass PC0-001 , specially the examination simulator. Im glad i was prepared for these hints. thanks killexams.com.

How a whole lot PC0-001 examination and prep manual fee?

Have exceeded PC0-001 examination with killexams.com questions solutions. killexams.com is a hundred% reliable, most of the questions had been similar to what I were given on the exam. I neglected some questions just because I went blankand didnt consider the solution given within the set, but in view that I got the rest proper, I passed with top rankings. So my recommendation is to research everything you get on your training p.c. from killexams.com, this is all you want to pass PC0-001.

brief, complete and genuine Q&A bank of PC0-001 examination.

best PC0-001 exam training i've ever come across. I passed PC0-001 exam hassle-free. No pressure, no issues, and no frustrations all through the exam. I knew the entirety I had to realize from this killexams.com PC0-001 Questions set. The questions are legitimate, and i heard from my pal that their money lower back guarantee works, too. They do provide you with the money lower back if you fail, however the component is, they make it very easy to skip. ill use them for my nextcertification assessments too.

attempt out those real PC0-001 modern-day Braindumps.

Being a network expert, I notion appearing for PC0-001 exam might honestly assist me in my profession. but, due to time restrains education for the examination have become truly difficult for me. i was seeking out a study manual that could make things higher for me. killexams.com Q&A dumps labored like wonders for me as that is a scientific solution for greater special study. all of sudden, with its assist, I controlled to finish the examination in only 70 minutes that's certainly a shocking. thanks to killexams.com substances.

exam questions are modified, where am i able to locate new questions and answers?

i am very happy right now. You ought to be questioning why i'm so glad, properly the purpose is quite easy, I just got my PC0-001 take a look at results and i've made it through them quite without problems. I write over here because it become this killexams.com that taught me for PC0-001 check and i cant go on with out thanking it for being so generous and helpful to me at some point of.

See more PEOPLECERT dumps

PC0-006 | CMS7 | PC0-001 | 150-230 |

Latest Exams added on brothelowner

1Z0-453 | 210-250 | 300-210 | 500-205 | 500-210 | 70-765 | 9A0-409 | C2010-555 | C2090-136 | C9010-260 | C9010-262 | C9020-560 | C9020-568 | C9050-042 | C9050-548 | C9050-549 | C9510-819 | C9520-911 | C9520-923 | C9520-928 | C9520-929 | C9550-512 | CPIM-BSP | C_TADM70_73 | C_TB1200_92 | C_TBW60_74 | C_TPLM22_64 | C_TPLM50_95 | DNDNS-200 | DSDPS-200 | E20-562 | E20-624 | E_HANABW151 | E_HANAINS151 | JN0-1330 | JN0-346 | JN0-661 | MA0-104 | MB2-711 | NSE6 | OMG-OCRES-A300 | P5050-031 |

See more dumps on brothelowner

HP0-D15 | 9L0-612 | 1Z0-023 | EC1-350 | C2030-283 | 920-110 | HP5-B04D | C9060-509 | HP2-B112 | 156-915-1 | 1Z0-807 | 000-014 | 000-704 | 000-060 | 920-334 | 000-959 | E22-258 | 300-209 | 000-M70 | C5050-285 | LOT-916 | HP0-263 | HP0-J65 | C2180-278 | HP0-450 | 62-193 | 00M-513 | 310-400 | 000-N24 | 00M-236 | 1Z0-528 | HP0-632 | TM1-101 | 70-696 | 650-312 | 00M-246 | 190-738 | 000-564 | HP0-281 | 190-847 | EX0-001 | HH0-380 | HP0-S20 | CAT-060 | C4040-123 | CFP | 000-062 | 301 | 0B0-107 | 642-736 |

PC0-001 Questions and Answers

PC0-001


Answer: D


QUESTION: 119

The remediation plan should be evaluated at what point in the change lifecycle?


  1. Before the change is approved

  2. Immediately after the change has failed and needs to be backed out

  3. After implementation but before the post implementation review

  4. After the post implementation review has identified a problem with the change


Answer: A


QUESTION: 120

Which of the following statements MOST correctly identifies the scope of design coordination activities?


  1. Only changes that introduce new services

  2. It is mandatory that all changes are subject to design coordination activity

  3. Only changes to business critical systems

  4. Any change that the organization believes could benefit


Answer: D


QUESTION: 121

What is the PRIMARY process for strategic communication with the service provider's customers?


  1. Service catalogue management

  2. Service portfolio management

  3. Service desk

  4. Business relationship management


Answer: D


QUESTION: 122

Which one of the following is NOT an aim of the change management process?


  1. To ensure the impact of changes are understood

  2. To ensure that changes are recorded and evaluated

  3. To ensure that all changes to configuration items (CIs) are recorded in the configuration management system (CMS)

  4. To deliver and manage IT services at agreed levels to business users


Answer: D


QUESTION: 123

What are customers of IT services who work in the same organization as the service provider known as?


  1. Strategic customers

  2. External customers

  3. Valued customers

  4. Internal customers


Answer: D


QUESTION: 124

Access management is closely related to which other process?


  1. Capacity management only

  2. 3rd line support

  3. Information security management

  4. Change management


Answer: C


QUESTION: 125

In which core ITIL publication can you find detailed descriptions of service catalogue management, information security management, and supplier management?


  1. Service strategy

  2. Service design

  3. Service transition

  4. Service operation


Answer: B


QUESTION: 126

Which of the following is the BEST reason for categorizing incidents?


  1. To establish trends for use in problem management and other IT service management (ITSM) activities

  2. To ensure service levels are met and breaches of agreements are avoided

  3. To enable the incident management database to be partitioned for greater efficiency

  4. To identify whether the user is entitled to log an incident for this particular service


Answer: A


QUESTION: 127

A known error has been created after diagnosis of a problem was complete but before a workaround has been found. Is this a valid approach?


  1. Yes: for information purposes, a known error record can be created at any time it is prudent to do so

  2. No: the Known Error should be created before the problem is logged

  3. No: a known error record is created when the original incident is raised

  4. No: a known error record should be created with the next release of the service


    Answer: A


    QUESTION: 128

    Which of the following provide value to the business from service strategy?

    1. Enabling the service provider to have a clear understanding of what levels of service will make their customers successful

    2. Enabling the service provider to respond quickly and effectively to changes in the business environment

    3. Support the creation of a portfolio of quantified services


      1. All of the above

      2. 1 and 3 only

      3. 1 and 2 only

      4. 2 and 3 only


        Answer: A


        QUESTION: 129

        Which of the following would be examined by a major problem review?

        1. Things that were done correctly

        2. Things that were done incorrectly

        3. How to prevent recurrence

        4. What could be done better in the future


          1. 1 only

          2. 2 and 3 only

          3. 1, 2 and 4 only

          4. All of the above


Answer: D


QUESTION: 130

Which one of the following is the BEST description of a relationship in service asset and configuration management?


  1. Describes the topography of the hardware

  2. Describes how the configuration items (CIs) work together to deliver the services

  3. Defines which software should be installed on a particular piece of hardware

  4. Defines how version numbers should be used in a release


    Answer: B


    QUESTION: 131

    Which of the following are sources of best practice?

    1. Academic research

    2. Internal experience

    3. Industry practices


      1. All of the above

      2. 1 and 3 only

      3. 1 and 2 only

      4. 2 and 3 only


Answer: A


PEOPLECERT PC0-001 Exam (ITIL 2011 Foundation) Detailed Information

What are the PEOPLECERT Professional Certifications
To meet today’s need for professionals to prove their competence against independent, globally recognized standards, PEOPLECERT offers a portfolio of certifications that assess professionals' know-how and competence at different levels.
Certification schemes have been developed by a team of experts, focusing on the globally recognized ISO standards and verified by industry leaders in each field.
PEOPLECERT Professional Certifications include
ACCESSIBILITY Certifications for Professionals
Professional Certifications in Management Systems
Professional Valuers
About PEOPLECERT
Having delivered millions of exams in over 150 countries, PEOPLECERT is today one of the leading players in the global certification industry, partnering with multi-national organisations and government bodies for the development & management of globally recognised certification schemes and the delivery of their related standardized exams.
PEOPLECERT today maintains certification programmes on behalf of a wide range of organisations, including the ECDL Foundation, City & Guilds, AXELOS (joint venture between the UK Cabinet Office and Capita plc.) for the Global Best Practice portfolio (including ITIL® and PRINCE2®) and others.
PEOPLECERT has also developed qualifications for Management Systems Professionals (including ISO 9001, ISO 20000 and ISO 27000), Accessibility certifications for the hospitality industry and Professional Valuers certifications (Certification Scheme recognised by TEGoVA, The European Group of Valuers' Associations).
For the development & management of the certification schemes, PEOPLECERT has:
Innovative exam administration solutions that offer a hassle free and secure exam process for its partners, from exam development booking & registration, to exam delivery and certificate issue.
A suite of online services for a simple and user friendly candidate exam experience, including online proctored exams, online exam booking and payment, e-certificates and online certificate verification.
Today, PEOPLECERT certifications are offered globally, through an extensive network of training organisations, corporations, and test centres worldwide.
PEOPLECERT Highlights
Millions of exams delivered across over 150 countries
Over 10,000 examination locations worldwide
A network of over 1,000 subject matter experts, associates and invigilators
Online & paper-based exams in 24 languages
Award winning online proctoring solution (received the Innovation award at the Business IT Excellence Awards)
Award winning Instant Scan & Mark testing solution (received the ICT Solutions for Professionals silver award at the Business IT Excellence Awards)
24/7/365 multi-lingual customer support through toll free numbers, e-mail and chat
EN ISO/IEC 17024 Accredited as a Personnel Certification Body by the Hellenic Accreditation Body (E.S.Y.D) (Accr. No. 833-2)
EN ISO/IEC 17065 Accredited for the Certification of products, processes and services by the Hellenic Accreditation Body (ESYD) (Accr. No. 992).
Certified for ISO 9001, ISO 10002, ISO 14001, ISO 27001, ISO 23988 - ensuring quality, security and integrity.
Certified for ISO 22301, ensuring business continuity.
Certified by the National Organisation for the Certification of Qualifications and Vocational Guidance of Greece (since 2006)
Member of the Association of Test Publishers (ATP)
Member of the European Group of Valuers’ Associations (TEGoVA)
ITIL® Foundation Certification & ITIL Foundation Exam
ITIL Foundation is suitable for individuals who require a basic understanding of the ITIL framework and how it may be used to enhance the quality of IT service management within an organization. The ITIL Foundation Certification also applies to IT professionals who work within an organization that has adopted ITIL and so need to be aware of and contribute to the overall service improvement programme.
ITIL® V3 Foundation Level - PEOPLECERT
Upon successful completion of the education and examination components related to ITIL Foundation certification, including the ITIL Foundation exam, candidates gain knowledge and understanding in the following areas:
Service Management as a practice
Service Lifecycle
Key Principles and Models
Generic Concepts
Selected Processes
Selected Roles
Selected Functions
Technology and Architecture

PEOPLECERT ">PC0-001 Tests

ExamCollection PREMIUM

Get Unlimited Access to all ExamCollection's PREMIUM files!

  • ExamCollection Certified Safe Files
  • Guaranteed to have ACTUAL Exam Questions
  • Up-to-Date Exam Study Material - Verified by Experts
  • Instant Downloads
  • Enter Your Email Address to Receive Your 30% Off Discount Code

    Please enter a correct email to Get your Discount Code

    Download Free Demo of VCEExam Simulator

    Experience Avanset VCE Exam Simulator for yourself.

    Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports
  • PEOPLECERT ">PC0-001 Certification Preparation - ITIL 2011 Foundation

    issuu company logo
  • Explore
  • Arts & Entertainment
  • Style & Fashion
  • Home & Garden
  • Business
  • Travel
  • Education
  • Sports
  • Health & Fitness
  • Hobbies
  • Food & Drink
  • Technology
  • Science
  • Vehicles
  • Society
  • Religion & Spirituality
  • Pets
  • Family & Parenting
  • Feminism
  • Go explore
  • Plans
  • Cancel Sign up Sign in Sign in
  • SQL Azure Federation – Features & Usage

    This is the second post about SQL Azure Federation. In my first post I described a little bit about the theory of data partitioning, included the different between the horizontal partitioning and the vertical partitioning. I also talked about the features need to be done when we implemented the horizontal partitioning. And finally, I described some basic concept about SQL Azure Federation.

    In this post, I will demonstrate how to use SQL Azure Federation in the SQL Server Management Studio (SSMS). I will also demonstrate the benefit of using SQL Azure Federation to build the multi-tenant data solution.

    Create Federation and Tables

    SQL Azure Federation is officially available for every Windows Azure data centers. There no additional register or sign up process. When we create a new server or database in SQL Azure, we can use SQL Azure Federation. For example, I had created a new database in my SQL Azure server which located in East Asia data center. Then I can open my SSMS and connect to this SQL Azure server and use SQL Azure Federation.

    Do not forget to set the SQL Azure firewall before you connect to the server from local tools such as SSMS.

    In this post I would like to take a very simple scenario as the example. Assuming we have a multi-tenant CRM system which contains accounts, contacts for each tenants. We also have some lookup data such as countries and titles. We also have one table contains some metadata for each tenants. So the database diagram would be like this.

    In SQL Azure Federation, if we decided to split some tables we must have the federation ready, then create the tables that wanted to be federated based on the federation. There is no way in SQL Azure Federation to switch tables between the federated and non-federated or reference. So before we start to create the tables we need to firstly define the federation.

    Since we decided to have the tenant ID as the key when splitting the database, the federation distribution should be INT type, which is the same as the type of TenantID in the tables.

    In order to create the federation, in SSMS connect to the database and execute the T-SQL below.

    1: CREATE FEDERATION Tenant_Fed (TID INT RANGE) 2: GO

    There’s nothing special happened after we executed this T-SQL in SSMS. But in SQL Azure fabric, it created a database which represent our first federation member. The federation member database name was specified by SQL Azure which was a GUID with “system-” prefixed. And the original database, which we created and are connecting now, became the root database.

    After that, all tables in our system should be in one of these three types.

    Table Type Description Where Federated Table Tables that will be split based on the federation and their federation columns. Federation Members Reference Table Tables that will not be split, but should be referred by the federated table. These tables will be copied across all federation members. Federation Members Centre Table Tables that will not be split, and very rarely join-select with the tables in federation members. Federation Root

    For the federated table and reference table, we need to create them in a federation member, so that when we split this member, SQL Azure Federation will help us to create them in the new member. In order to connect to a federation member we need to execute the T-SQL below.

    1: USE FEDERATION Tenant_Fed (TID = 0) WITH RESET, FILTERING = OFF 2: GO

    If you are familiar with SQL Azure you should be already know that the USE keyword doesn’t work in SQL Azure. But if we specify the FEDERATION keyword and the federation name it will switch our connection to the federation member database, which contains the distribution key value we specified here (TID = 0). And if we connected to this federation member we can retrieve the database name by using the db_name() function. As you can see in my workstation my first federation member database name was “system-06d60081-6737-413e-85b1-df65cb55f1c9”.

    Now we have been connecting to the federation member and the next step is to create the federated tables. Based on our design the Account and table should be partitioning by their TenantID column so let’s create them by the following T-SQL.

    1: CREATE TABLE [dbo].[Account]( 2: [ID] [int] NOT NULL, 3: [TenantID] [int] NOT NULL, 4: [Name] [varchar](50) NOT NULL, 5: [CountryID] [int] NOT NULL, 6: CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED 7: ( 8: [ID] ASC 9: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 10: ) 11: FEDERATED ON (TID = TenantID) 12: GO

    In the T-SQL above we are going to create the Account table with fields and primary key. And at the end of the statement we defined that the TenantID column is the federated column of this table. This means, when SQL Azure Federation split the table it will look up the value of TenantID, decided which rows should be in which member.

    But when we executed we will get an error that the primary key index could not be created since the index doesn’t contain the federated column.

    This is a limitation in SQL Azure Federation. The federated column in a federated table must be the clustered index, or be in the clustered index. Since we defined the ID as the primary key of the Account table, to satisfied this limitation we must include the TenantID as the primary key as well. So our T-SQL should be like this.

    1: CREATE TABLE [dbo].[Account]( 2: [ID] [int] NOT NULL, 3: [TenantID] [int] NOT NULL, 4: [Name] [varchar](50) NOT NULL, 5: [CountryID] [int] NOT NULL, 6: CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED 7: ( 8: [ID] ASC, 9: [TenantID] ASC 10: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 11: ) 12: FEDERATED ON (TID = TenantID) 13: GO

    And similarly, in table we also need to add the TenantID column as the primary key. We also need to amend the foreign keys as well. The T-SQL should be like this.

    There is no constraint that the federation column name should be the same in each federated tables. We can specify the federation key to the different columns that has different names in each federated tables when created the tables. For example in Account table we link TID = TenantID while in table we link TID = Tenant_ID or TID = T_ID, etc..

    1: CREATE TABLE [dbo].[]( 2: [ID] [int] NOT NULL, 3: [TenantID] [int] NOT NULL, 4: [AccountID] [int] NOT NULL, 5: [Name] [varchar](50) NOT NULL, 6: [TitleID] [int] NOT NULL, 7: CONSTRAINT [PK_] PRIMARY KEY CLUSTERED 8: ( 9: [ID] ASC, 10: [TenantID] ASC 11: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 12: ) 13: FEDERATED ON (TID = [TenantID]) 14: GO 15: 16: ALTER TABLE [dbo].[Account] WITH CHECK ADD CONSTRAINT [FK_Account_Country] FOREIGN KEY([CountryID]) 17: REFERENCES [dbo].[Country] ([ID]) 18: GO 19: ALTER TABLE [dbo].[Account] CHECK CONSTRAINT [FK_Account_Country] 20: GO 21: ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__Account] FOREIGN KEY([AccountID], [TenantID]) 22: REFERENCES [dbo].[Account] ([ID], [TenantID]) 23: GO 24: ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__Account] 25: GO 26: ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__Title] FOREIGN KEY([TitleID]) 27: REFERENCES [dbo].[Title] ([ID]) 28: GO 29: ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__Title] 30: GO

    Now we have the federated tables created in our first federation member. Next let’s create the reference tables. In this case the reference tables are County and Title. They don’t have the column related with the federation distribution key, which is the tenant ID in our example. But they need to be selected alone with the federated tables. For example we might need to retrieve the account information for a tenant with the country name. So they need to be added as reference tables.

    To create a reference table in a federation member would be the same as what we did on a normal database, no need to specify the federated column in the CREATE TABLE statement.

    1: CREATE TABLE [dbo].[Title]( 2: [ID] [int] NOT NULL, 3: [Title] [varchar](50) NOT NULL, 4: CONSTRAINT [PK_Title] PRIMARY KEY CLUSTERED 5: ( 6: [ID] ASC 7: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 8: ) 9: GO 10: 11: CREATE TABLE [dbo].[Country]( 12: [ID] [int] NOT NULL, 13: [Country] [varchar](50) NOT NULL, 14: CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED 15: ( 16: [ID] ASC 17: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 18: ) 19: GO 20: 21: ALTER TABLE [dbo].[Account] WITH CHECK ADD CONSTRAINT [FK_Account_Country] FOREIGN KEY([CountryID]) 22: REFERENCES [dbo].[Country] ([ID]) 23: GO 24: ALTER TABLE [dbo].[Account] CHECK CONSTRAINT [FK_Account_Country] 25: GO 26: 27: ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__Title] FOREIGN KEY([TitleID]) 28: REFERENCES [dbo].[Title] ([ID]) 29: GO 30: ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__Title] 31: GO

    And in the T-SQL above we also added the foreign keys between the reference tables and federated tables. It’s possible to add the foreign keys between the federated tables, like what we added between the Account and . It’s possible to add the foreign key from the federated table to reference table, like the key between Account and Country. But it’s not allowed to add the foreign key from a non-federated table to a federated table. For example we cannot add a foreign key between the Account to a table in the federation root.

    Now we have all tables and keys ready in our first federation member. Let’s add some sample data.

    1: INSERT INTO Country VALUES (1, 'China') 2: INSERT INTO Country VALUES (2, 'US') 3: INSERT INTO Country VALUES (3, 'UK') 4: 5: INSERT INTO Title VALUES (1, 'Mr') 6: INSERT INTO Title VALUES (2, 'Ms') 7: 8: INSERT INTO Account VALUES (1, 1, 'Tenant 1 - Account 1', 1) 9: INSERT INTO Account VALUES (2, 1, 'Tenant 1 - Account 2', 2) 10: INSERT INTO Account VALUES (3, 2, 'Tenant 2 - Account 3', 3) 11: INSERT INTO Account VALUES (4, 2, 'Tenant 2 - Account 4', 1) 12: INSERT INTO Account VALUES (5, 3, 'Tenant 3 - Account 5', 2) 13: INSERT INTO Account VALUES (6, 3, 'Tenant 3 - Account 6', 3) 14: INSERT INTO Account VALUES (7, 4, 'Tenant 4 - Account 7', 1) 15: INSERT INTO Account VALUES (8, 4, 'Tenant 4 - Account 8', 2) 16: INSERT INTO Account VALUES (9, 5, 'Tenant 5 - Account 9', 3) 17: INSERT INTO Account VALUES (10, 5, 'Tenant 5 - Account 10', 1) 18: 19: 20: INSERT INTO VALUES (1, 1, 1, 'Tenant 1 - Account 1 - 1', 1) 21: INSERT INTO VALUES (2, 1, 1, 'Tenant 1 - Account 1 - 2', 2) 22: INSERT INTO VALUES (3, 1, 1, 'Tenant 1 - Account 1 - 3', 1) 23: INSERT INTO VALUES (4, 1, 2, 'Tenant 1 - Account 2 - 4', 2) 24: INSERT INTO VALUES (5, 1, 2, 'Tenant 1 - Account 2 - 5', 1) 25: INSERT INTO VALUES (6, 1, 2, 'Tenant 1 - Account 2 - 6', 2) 26: INSERT INTO VALUES (7, 2, 3, 'Tenant 2 - Account 3 - 7', 1) 27: INSERT INTO VALUES (8, 2, 3, 'Tenant 2 - Account 3 - 8', 2) 28: INSERT INTO VALUES (9, 2, 3, 'Tenant 2 - Account 3 - 9', 1) 29: INSERT INTO VALUES (10, 2, 4, 'Tenant 2 - Account 4 - 10', 2) 30: INSERT INTO VALUES (11, 2, 4, 'Tenant 2 - Account 4 - 11', 1) 31: INSERT INTO VALUES (12, 2, 4, 'Tenant 2 - Account 4 - 12', 2) 32: INSERT INTO VALUES (13, 3, 5, 'Tenant 3 - Account 5 - 13', 1) 33: INSERT INTO VALUES (14, 3, 5, 'Tenant 3 - Account 5 - 14', 2) 34: INSERT INTO VALUES (15, 3, 5, 'Tenant 3 - Account 5 - 15', 1) 35: INSERT INTO VALUES (16, 3, 6, 'Tenant 3 - Account 6 - 16', 2) 36: INSERT INTO VALUES (17, 3, 6, 'Tenant 3 - Account 6 - 17', 1) 37: INSERT INTO VALUES (18, 3, 6, 'Tenant 3 - Account 6 - 18', 2) 38: INSERT INTO VALUES (19, 4, 7, 'Tenant 4 - Account 7 - 19', 1) 39: INSERT INTO VALUES (20, 4, 7, 'Tenant 4 - Account 7 - 20', 2) 40: INSERT INTO VALUES (21, 4, 7, 'Tenant 4 - Account 7 - 21', 1) 41: INSERT INTO VALUES (22, 4, 8, 'Tenant 4 - Account 8 - 22', 2) 42: INSERT INTO VALUES (23, 4, 8, 'Tenant 4 - Account 8 - 23', 1) 43: INSERT INTO VALUES (24, 4, 8, 'Tenant 4 - Account 8 - 24', 2) 44: INSERT INTO VALUES (25, 5, 9, 'Tenant 5 - Account 9 - 25', 1) 45: INSERT INTO VALUES (26, 5, 9, 'Tenant 5 - Account 9 - 26', 2) 46: INSERT INTO VALUES (27, 5, 9, 'Tenant 5 - Account 9 - 27', 1) 47: INSERT INTO VALUES (28, 5, 10, 'Tenant 5 - Account 10 - 28', 2) 48: INSERT INTO VALUES (29, 5, 10, 'Tenant 5 - Account 10 - 29', 1) 49: INSERT INTO VALUES (30, 5, 10, 'Tenant 5 - Account 10 - 30', 2)

    After executed these T-SQL we had put all data in our first federation member. It contains two references tables (Country, Title) and two federated tables (Account, ), and some foreign keys between the reference table and federated table.

    And we can select the data in this federation member with the tables joining, for example the T-SQL below will list all accounts and contacts information.

    1: SELECT Account.Name, Country.Country, .Name, Title.Title FROM 2: LEFT JOIN Account ON AccountID = Account.ID 3: LEFT JOIN Country ON Account.CountryID = Country.ID 4: LEFT JOIN Title ON .TitleID = Title.ID Split Federation Member

    The key feature of SQL Azure Federation is to split a federation member into two based on the federated value specified without any downtime. Since we have inserted some data in our first federation member, let’s split it into two.

    Split a federation member is very easy. We use the ALTER FEDERATION command and specify from what value of the distribution key to split. For example, since the federation distribution key is the TID (tenant ID), we will split all federated tables based on their federated column value at 3. This means all data that the tenant ID is less than 3 will be in the federation member 1 while others will be in the federation member 2.

    In order to split the federation we need to firstly connect to the federation root, and then execute the ALTER FEDERATION command specifying the boundary value.

    1: USE FEDERATION ROOT WITH RESET 2: GO 3: 4: ALTER FEDERATION Tenant_Fed SPLIT AT (TID = 3) 5: GO

    When execute this command the SQL Azure engine will perform the operations listed below.

  • First, it will configure the federation metadata information on the federation root, to indicate that the federation should be split.
  • Then it will create two databases for the new federation members. Please note that even though we have had a federation member already when executing the split command, SQL Azure Federation will NOT use this member in the future. It will create two new members.
  • SQL Azure will create the tables, keys and constraints, etc. from the current federation member to the new members.
  • It will copy the records in the reference tables to new members.
  • It will copy the records in the federated tables to new members based on the boundary value specified. Records with the federation column value less than the boundary value will be put into the low member while those equals or more than the boundary value will be put into the high member.
  • Finally, SQL Azure will re-map the connections from the original federation member to the new members and drop the original member.
  • After the split command finished we can connect one federation member by using the USE FEDERATION command. In SQL Azure Federation we cannot connect to a member database by specifying its database name, instead we need to tell the SQL Azure Federation the value of the distribution key we want to us, then SQL Azure Federation will rout us to that member database. For example, we split our data at tenant ID = 3, then if we want to read the data of tenant 4 we can use the T-SQL below.

    1: USE FEDERATION Tenant_Fed (TID = 4) WITH RESET, FILTERING = OFF 2: GO

    Then execute the command we had just preformed before to see the data in this federation member.

    1: SELECT Account.Name, Country.Country, .Name, Title.Title 2: FROM 3: LEFT JOIN Account ON AccountID = Account.ID 4: LEFT JOIN Country ON Account.CountryID = Country.ID 5: LEFT JOIN Title ON .TitleID = Title.ID

    And as you can see, the SSMS returned the data that the tenant ID is equal or more than 4.

    And if we want to see the data in the first member, we can just specify the TID = 0, 1 or 2, any value less than the boundary value of that federation member.

    Connect to Atomic Unit

    When we connected to a federation member we use the USE FEDERATION command. There’s a clause in this T-SQL statement which is FILTERING = OFF. In the example above we can select all data in the federation member unless we didn’t put any criteria in WHERE clause in SELECT command. This is because we utilized FILTERING = OFF. It will make the connection scope set to the full range covered by the federation member containing the specified key value. The connection behaves the same if it were connected to the member through its physical federation member name (the database name).

    SQL Azure Federation provides another valuable feature that can force the connection scope set to the federation key instance (federation key value) in a federation member rather than to the full range of federation member, by using FILTERING = ON clause.

    So let’s have a try and to see what will happen if we set the FILTERING = ON. At this time we still specify the SSMS to use federation where the key equals to 2 but specify the FILTERING = ON, and select the data without any criteria.

    1: USE FEDERATION Tenant_Fed (TID = 2) WITH RESET, FILTERING = ON 2: GO 3: 4: SELECT Account.Name, Country.Country, .Name, Title.Title 5: FROM 6: LEFT JOIN Account ON AccountID = Account.ID 7: LEFT JOIN Country ON Account.CountryID = Country.ID 8: LEFT JOIN Title ON .TitleID = Title.ID

    Now we can see that only the records that the TenantID = 2 were returned. We didn’t provide anything in the WHERE clause in SELECT command but it worked as if we specified WHERE TenantID = 2. This is the benefit that using the FILTERING = ON in the USE FEDERATION command.

    We mentioned in the previous post, in SQL Azure Federation all records that related with the same federation key value in a federation member is called an Atomic Unit. In the case above we connected to the federation member’s atomic unit which the value is TenantID = 2, by using the FILTERING = ON clause.

    This feature is very useful especially when we need to migrate a single tenant application to multi-tenant style. As you know we might need to add the tenant identity column in the tables that tenant-award when migrating, but this might lead us to rewrite all related SQL scripts. For example if we have a SQL script that retrieves all data in table Order, it might look like this in single tenant application.

    1: SELECT Order.ID, Order.Name FROM Order

    But if we implemented the multi-tenant feature we have to add the TenantID column in this table to indicate which tenant the order is. And accordingly we have to rewrite the SQL script if a participant tenant user is currently logging on.

    1: SELECT Order.ID, Order.Name FROM Order 2: WHERE Order.TenantID = UserTenentID

    Assuming that we have 50 tables that are tenant-award and 10 scripts for each table. Then we need to amend 50 * 10 = 500 SQL scripts. And almost all changes are very similar.

    But if we are using SQL Azure Federation we can make the tenant ID as the federation distribution key and let the tables split based on their TenantID column. Then if we have an user logged in under a tenant, we can invoke the USE FEDERATION statement specifying the TenantID value with FILTERING = ON before any data command, then all following SQL scripts will no need to be changed since the SQL Azure Federation helped us to filter the connection scope to this tenant. This can be done very easily by using AOP.

    Summary

    In this post I demonstrated how to use SQL Azure Federation. We talked about how to create federation, federation members and tables. And we demonstrated how to split a federation member, which is horizontal data partitioning without any downtime.

    I also talked about the feature of FILTERING = ON in USE FEDERATION statement and the benefit in multi-tenant solution.

    SQL Azure Federation is a very powerful tool for us to build scale-out andor multi-tenant application. In the coming few posts I would like to discuss the metadata system of the federation, the pricing and how to split the federation members based on the data size or record count.

    And I would like to introduce on how to implement our own horizontal partitioning data access layer without SQL Azure Federation available.

    Hope this helps,

    Shaun

    All documents and related graphics, codes are provided "AS IS" without warranty of any kind. Shaun Ziyan Xu. This work is licensed under the Creative Commons License.

  • ITIL 2011 Foundation

    ITIL 2011 Foundation.">PC0-001.v9-8.2016-04-04.1e.131q.exam 259 Kb Apr 12, 2016 ITIL 2011 Foundation.">PC0-001.v9-8.2015-08-21.1e.131q.exam 104 Kb Aug 27, 2015 ITIL 2011 Foundation.">PC0-001.v9-8.2015-07-19.1e.131q.exam 104 Kb Aug 02, 2015


    References:


    Download Hottest Pass4sure Certification Exams - CSCPK
    Complete Pass4Sure Collection of Exams - BDlisting
    Latest Exam Questions and Answers - Ewerton.me
    Pass your exam at first attempt with Pass4Sure Questions and Answers - bolink.org
    Here you will find Real Exam Questions and Answers of every exam - dinhvihaiphong.net
    Hottest Pass4sure Exam at escueladenegociosbhdleon.com
    Download Hottest Pass4sure Exam at ada.esy
    Pass4sure Exam Download from aia.nu
    Pass4sure Exam Download from airesturismo
    Practice questions and Cheat Sheets for Certification Exams at linuselfberg
    Study Guides, Practice questions and Cheat Sheets for Certification Exams at brondby
    Study Guides, Study Tools and Cheat Sheets for Certification Exams at assilksel.com
    Study Guides, Study Tools and Cheat Sheets for Certification Exams at brainsandgames