You are 1 of 75 consultants employed by an IT services company named Contoso.com. As part of your job，you and other team members provide network support for over 150 businesses in your city. Your company is about to implement a business process in which c

第1题：

第2题：

How to Start Your Own Business I have recently started a business and have learned some crucial lessons in the process that I feel privileged to share with you. 1. Identify your motivation. __1__ To have more time? To make more money? To be your own boss? To have creative control over what you love to do? Write out all of your motivating factors and prioritize them. When you see them listed, you might see a pattern in that you're just unhappy at your current job and starting your own business isn't the answer. 2. Identify your passion. What do you love to do? What skills and knowledge do you uniquely bring to the table? What gets you excited about your work? __2__ If you keep your passion in plain sight, you will stay focused on the purpose of your business and not solely on the logistics. 3. Identify your market. If you are starting your business locally, research your competitors. Determine if there is room in the market for your business. What will you do differently to draw in customers? What niche market are the other businesses missing? __3__ Your business cannot survive without customers, so do enough research on the front end to determine if there are enough potential clients to keep your business alive. 4. Identify your finances. __4__ You have to buy furniture, trash cans, a garage door opener, light fixtures and landscaping equipment, and before you know it, you've far exceeded your financial boundaries. That can happen just as easily in a business. Do exhaustive financial planning. Meet with a financial advisor or someone at your bank to examine the financial viability of your business and the process of getting it up and running. __5__ Be prepared for financial loss and get advice on how to alleviate that burden in the future. ___1___内应为（）

• A、Plan wisely and do not assume the best about your business.
• B、Why do you want to start your own business?
• C、The tragic reality is that when business fail, the passion often dies with it.
• D、Keep that passion at the forefront of your business plan, your marketing strategies, and your daily routine.
• E、If you have ever purchased a new home, you know that the financial obligations extend beyond the down payment and the mortage.
• F、If you are starting an Internet company, research the requirements for your own unique Web presence.

第3题：

第4题：

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance of your company is managed by you. There is a team of database administrators in your company. SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared project by a team of application developers. A fixed cache file is required by one of the packages. The company will deploy the packages to the production server on completion of development. The production server is available only to the database administrators.  Since you are the technical support, you need to confirm that the project can be deployed successfully to the production server by the application developers.    Which action will you perform to achieve the goal?（）

• A、To achieve the goal, the Import and Export Wizard should be utilized to save packages.
• B、To achieve the goal, a direct package configuration should be created for each package.
• C、To achieve the goal, a deployment utility should be created for the SSIS project. 
• D、To achieve the goal, an indirect package configuration should be created for all packages.

第5题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster.  Which action should be performed to finish the task？（）

• A、To finish the task，the Products database should be backed up.
• B、To finish the task，your server should be set to utilize the full recovery model.
• C、To finish the task，your server should be set to utilize the bulk-logged recovery model.
• D、To finish the task， the msdb database should be backed up.

第6题：

How to Start Your Own Business I have recently started a business and have learned some crucial lessons in the process that I feel privileged to share with you. 1. Identify your motivation. __1__ To have more time? To make more money? To be your own boss? To have creative control over what you love to do? Write out all of your motivating factors and prioritize them. When you see them listed, you might see a pattern in that you're just unhappy at your current job and starting your own business isn't the answer. 2. Identify your passion. What do you love to do? What skills and knowledge do you uniquely bring to the table? What gets you excited about your work? __2__ If you keep your passion in plain sight, you will stay focused on the purpose of your business and not solely on the logistics. 3. Identify your market. If you are starting your business locally, research your competitors. Determine if there is room in the market for your business. What will you do differently to draw in customers? What niche market are the other businesses missing? __3__ Your business cannot survive without customers, so do enough research on the front end to determine if there are enough potential clients to keep your business alive. 4. Identify your finances. __4__ You have to buy furniture, trash cans, a garage door opener, light fixtures and landscaping equipment, and before you know it, you've far exceeded your financial boundaries. That can happen just as easily in a business. Do exhaustive financial planning. Meet with a financial advisor or someone at your bank to examine the financial viability of your business and the process of getting it up and running. __5__ Be prepared for financial loss and get advice on how to alleviate that burden in the future. __4__内应为（）

• A、Plan wisely and do not assume the best about your business.
• B、Why do you want to start your own business?
• C、The tragic reality is that when business fail, the passion often dies with it.
• D、Keep that passion at the forefront of your business plan, your marketing strategies, and your daily routine.
• E、If you have ever purchased a new home, you know that the financial obligations extend beyond the down payment and the mortage.
• F、If you are starting an Internet company, research the requirements for your own unique Web presence.

第7题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

• A、You should use local Service account
• B、You should use network Service account
• C、You should use domain account
• D、You should use local System account

第8题：

第9题：

You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers，configuring Windows Server 2008 Terminal services and network application services， and configuring aweb services infrastructure. There is an Active Directory domain in your company. The company runsTerminal Services. All Terminal Services accounts are configured to allow session takeover without permission. A user has used an account named User1 to log on to a server named S02. The session ID forUser1 is 1337. You need to perform a session takeover for session ID 1337. Which commands should you run？（）

• A、You should run Tsdiscon 1337， and then Tscon 1337
• B、You should run Chgusr 1337 /disable， and then Tscon 1337
• C、You should run Takeown /U User1 1337， and then Tscon 1337
• D、You should run Tsdiscon 1337， and then Chgport /U User1 1337

第10题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least.  Which action should you perform？（）

• A、First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.
• B、First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.
• C、First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.
• D、You should place a unique index on the PartNum column.