Looking for PC0-001 exam dumps that works in real exam?
Real PC0-001 questions and brain dumps! It justify the price.
PC0-001 online exam | PC0-001 exam test | PC0-001 free practice tests | PC0-001 test prep | PC0-001 boot camp - bigdiscountsales.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 20, 2017 |
| PDF Download Mirror | : | PC0-001 Brain Dump |
| Get Full Version | : | Pass4sure PC0-001 Full Version |
Pass4sure PC0-001 real question bank
Quality and Value for the PC0-001 Exam : killexams.com Practice Exams for PEOPLECERT PC0-001 are composed to the most elevated norms of specialized precision, utilizing just confirmed topic specialists and distributed creators for improvement.
100% Guarantee to Pass Your PC0-001 Exam : If you don't pass the PEOPLECERT PC0-001 exam utilizing our killexams.com testing software and PDF, we will give you a FULL REFUND of your buying charge.
Downloadable, Interactive PC0-001 Testing Software : Our PEOPLECERT PC0-001 Preparation Material gives you all that you should take PEOPLECERT PC0-001 examination. Subtle elements are looked into and created by PEOPLECERT Certification Experts who are continually utilizing industry experience to deliver exact, and legitimate.
- Comprehensive questions and answers about PC0-001 exam - PC0-001 exam questions joined by displays - Verified Answers by Experts and very nearly 100% right - PC0-001 exam questions updated on general premise - PC0-001 exam planning is in various decision questions (MCQs). - Tested by different circumstances previously distributing - Try free PC0-001 exam demo before you choose to get it in killexams.com
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
PC0-001 Discount Coupon, PC0-001 Promo Code, 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
PC0-001 questions and answers that works in the real test.
It ended up being a frail department of know-how to plot. I required a book that may kingdom question and solution and that i absolutely allude it. killexams.com Questions & answers are singularly in charge of each ultimate one in all credit. much obliged killexams.com for giving high quality conclusion. I had endeavored the examination PC0-001 examination for 3years constantly however couldnt make it to passing rating. I understood my hollow in knowledge the difficulty of makinga consultation room.Right place to get PC0-001 Latest Brain dump paper.
I would recommend this question bank as a must have to anyone who is preparing for the PC0-001 exam. It was very helpful in getting an idea as to what sort of questions were coming and which areas to focus. The practice test provided was also great in getting a feeling of what to expect on exam day. As for the answers keys provided, it was of great help in recollecting what I had learnt and the explanations provided were easy to understand and definately added value to my concept on the subject.It is really great experience to have PC0-001 braindumps.
Felt very proud to complete answering all questions for the duration of my PC0-001 exam. Frankly speaking, I owe this fulfillment to the question & solution by killexams.com The material covered all of the associated questions to eachsubject matter and provided the answers in brief and specific way. understanding the contents have become easy and memorizing became no difficulty in any respect. i used to be also fortunate enough to get maximum of the questions from the guide. happy to pass satisfactorily. superb killexamsSurprised to see PC0-001 latest questions in little price.
I have passed the PC0-001 exam with this! This is the first time I used Killexams, but now I know its not gonna be the last one! With the practice exams and real questions, taking this exam was surprisingly easy. This is a great way to get certified - which are nothing like anything else. If youve been through any of their exams, youll know what I mean. PC0-001 is hard, but Killexams is a blessing!Questions have been precisely same as I got!
It is not the first time I am using killexamsfor my PC0-001 exam, I have tried their materials for a few vendors examinations, and havent failed once. I fully rely on this preparation. This time, I also had some technical problems with my computer, so I had to contact their customer support to double check something. Theyve been great and have helped me sort things out, although the problem was on my end, not their software.discovered an genuine source for actual PC0-001 exam questions.
I would potentially propose it to my partners and accomplices. I got 360 of imprints. I used to be enchanted with the results I got with the help study guide PC0-001 examination course material. I normally thought true and intensive studies were the reaction to all or any exams, till I took the assistance of killexams.com brain dump to pass my examination PC0-001. Extremely fulfill.it's miles excellent best to put together PC0-001 exam with real Questions.
It isn't always the first time i am the usage of killexamsfor my PC0-001 exam, i have tried their materials for a few vendors examinations, and havent failed once. I absolutely rely upon this guidance. This time, I also had a few technical issues with my pc, so I needed to touch their customer service to double take a look at some thing. Theyve been high-quality and have helped me sort matters out, even though the hassle changed into on my give up, no longer their software program.Found an accurate source for real PC0-001 Actual Questions.
Subsequently it used to be troublesome for me to center upon PC0-001 exam. I used killexams.com Questions & Answers for a time of two weeks and figured out how to solved 95% questions in the exam. Today I am an Instructor in the preparation business and all credits goes to killexams.com. Planning for the PC0-001 exam for me was at the very least a bad dream. Dealing with my studies alongside low maintenance employment used to expend practically all my time. Much appreciated killexams.try those actual take a look at questions for PC0-001 examination.
I must admit, I was at my wits end and knew after failing the PC0-001 test the first time that I was on my own. Until I searched the web for my test. Many sites had the sample help exams and some for around $200. I found this site and it was the lowest price around and I really could not afford it but bit the bullet and purchased it here. I know I sound like a Salesman for this company but I cannot believe that I passed my cert exam with a 98!!!!!! I opened the exam only to see almost every question on it was covered in this sample! You guys rock big time! If you need me, call me for a testimonial cuz this works folks!"it is splendid to have PC0-001 modern-day Braindumps.
I have been using the killexams.com for a while to all my exams. Last week, I passed with a great score in the PC0-001 exam by using the Q&A study resources. I had some doubts on topics, but the material cleared all my doubts. I have easily found the solution for all my doubts and issues. Thanks for providing me the solid and reliable material. It is the best product as I know.See more PEOPLECERT dumps
CMS7 | 150-230 | PC0-006 | PC0-001 |Latest Exams added on bigdiscountsales
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 bigdiscountsales
6401-1 | 000-M83 | 212-065 | 1Z0-043 | HH0-230 | HP0-390 | 000-233 | HP0-M51 | C2090-930 | HP2-H20 | 3200-1 | 98-375 | PMBOK-5th | 650-281 | HP0-Y21 | A2180-178 | 700-104 | HP0-J29 | 000-513 | 1T6-530 | 1Z0-963 | 132-s-712-2 | 000-019 | CAS-002 | HP2-Z14 | NS0-511 | HP0-D13 | 251-312 | MA0-103 | 190-612 | NS0-120 | C2150-537 | EE0-501 | PMI-SP | HP2-K34 | CLSSYB | BCP-811 | 1Z0-335 | JN0-140 | 132-S-100 | HP2-B22 | HP0-719 | 000-M88 | ST0-097 | HP2-E62 | 132-S-708-1 | E10-110 | HP0-Y15 | C2090-619 | HP0-438 |PC0-001 Questions and Answers
Answer: D
QUESTION: 119
The remediation plan should be evaluated at what point in the change lifecycle?
- Before the change is approved
- Immediately after the change has failed and needs to be backed out
- After implementation but before the post implementation review
- 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?
- Only changes that introduce new services
- It is mandatory that all changes are subject to design coordination activity
- Only changes to business critical systems
- 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?
- Service catalogue management
- Service portfolio management
- Service desk
- Business relationship management
Answer: D
QUESTION: 122
Which one of the following is NOT an aim of the change management process?
- To ensure the impact of changes are understood
- To ensure that changes are recorded and evaluated
- To ensure that all changes to configuration items (CIs) are recorded in the configuration management system (CMS)
- 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?
- Strategic customers
- External customers
- Valued customers
- Internal customers
Answer: D
QUESTION: 124
Access management is closely related to which other process?
- Capacity management only
- 3rd line support
- Information security management
- 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?
- Service strategy
- Service design
- Service transition
- Service operation
Answer: B
QUESTION: 126
Which of the following is the BEST reason for categorizing incidents?
- To establish trends for use in problem management and other IT service management (ITSM) activities
- To ensure service levels are met and breaches of agreements are avoided
- To enable the incident management database to be partitioned for greater efficiency
- 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?
- Yes: for information purposes, a known error record can be created at any time it is prudent to do so
- No: the Known Error should be created before the problem is logged
- No: a known error record is created when the original incident is raised
- 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?- Enabling the service provider to have a clear understanding of what levels of service will make their customers successful
- Enabling the service provider to respond quickly and effectively to changes in the business environment
- Support the creation of a portfolio of quantified services
- All of the above
- 1 and 3 only
- 1 and 2 only
- 2 and 3 only
Answer: A
QUESTION: 129
Which of the following would be examined by a major problem review?- Things that were done correctly
- Things that were done incorrectly
- How to prevent recurrence
- What could be done better in the future
- 1 only
- 2 and 3 only
- 1, 2 and 4 only
- 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?
- Describes the topography of the hardware
- Describes how the configuration items (CIs) work together to deliver the services
- Defines which software should be installed on a particular piece of hardware
- Defines how version numbers should be used in a release
Answer: B
QUESTION: 131
Which of the following are sources of best practice?- Academic research
- Internal experience
- Industry practices
- All of the above
- 1 and 3 only
- 1 and 2 only
- 2 and 3 only
Answer: A
PEOPLECERT PC0-001 Exam (ITIL 2011 Foundation) Detailed Information
What are the PEOPLECERT Professional CertificationsTo 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!
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.
PEOPLECERT ">PC0-001 Certification Preparation - ITIL 2011 Foundation
issuu company logoSQL 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.
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, 2015References:
Pass4sure Certification Exam Questions and Answers - www.founco.com
Killexams Exam Study Notes | study guides - www.founco.com
Pass4sure Certification Exam Questions and Answers - st.edu.ge
Killexams Exam Study Notes | study guides - st.edu.ge
Pass4sure Certification Exam Questions and Answers - www.jabbat.com
Killexams Exam Study Notes | study guides - www.jabbat.com
Pass4sure Certification Exam Questions and Answers - www.jorgefrazao.esy.es
Killexams Exam Study Notes | study guides - www.jorgefrazao.esy.es
Pass4sure Certification Exam Questions and Answers and Study Notes - www.makkesoft.com
Killexams Exam Study Notes | study guides | QA - www.makkesoft.com
Pass4sure Exam Study Notes - maipu.gob.ar
Pass4sure Certification Exam Study Notes - idprod.esy.es
Download Hottest Pass4sure Certification Exams - cscpk.org
Killexams Study Guides and Exam Simulator - www.simepe.com.br
Comprehensive Questions and Answers for Certification Exams - www.ynb.no
Exam Questions and Answers | Brain Dumps - www.4seasonrentacar.com
Certification Training Questions and Answers - www.interactiveforum.com.mx
Pass4sure Training Questions and Answers - www.menchinidesign.com
Real exam Questions and Answers with Exam Simulators - www.pastoriaborgofuro.it
Real Questions and accurate answers for exam - playmagem.com.br
Certification Questions and Answers | Exam Simulator | Study Guides - www.rafflesdesignltd.com
Kill exams certification Training Exams - www.sitespin.co.za
Latest Certification Exams with Exam Simulator - www.philreeve.com
Latest and Updated Certification Exams with Exam Simulator - www.tmicon.com.au
Pass you exam at first attempt with Pass4sure Questions and Answers - tractaricurteadearges.ro
Latest Certification Exams with Exam Simulator - addscrave.net
Pass you exam at first attempt with Pass4sure Questions and Answers - alessaconsulting.com
Get Great Success with Pass4sure Exam Questions/Answers - alchemiawellness.com
Best Exam Simulator and brain dumps for the exam - andracarmina.com
Real exam Questions and Answers with Exam Simulators - empoweredbeliefs.com
Real Questions and accurate answers for exam - www.alexanndre.com
Certification Questions and Answers | Exam Simulator | Study Guides - allsoulsholidayclub.co.uk
Comments
Post a Comment