Microsoft 70-443 Exam - Certifysky.com
1. BACKGROUND Company Overview A. Datum Corporation is an independent software vendor that has a worldwide customer base.The company sells its software through a combination of an ecommerce Web site and a telephonebased ordering system. Planned Changes The company plans to upgrade all of
its database servers to SQL Server 2005.The BusinessDats database will be redesigned to improve manageability,and a new database named MarketionAnalysis will be created to allow marketing analysts to generate reports from sales data.The most common report that will be generated will retrieve the names of products that are sold and the cities where the customers live. Problem Statements The company wants to improve the security of its data and wants to minimize the risk of unauthorized data access or malicious attack. On several occasions,customers were unable to place an order because the database server was unavailable for na extended period of time. EXISTING DATA ENVIRONMENT Databases The HRData database contains employee data,including sensitive information such as salary and employee reviews The BusinessData database contains product and data.Analysis indicates that each user typically accesses only a subset of the tables in the database.This subset is related to the department in which the works. Business analysis indicates that approximately 4,000 new records are added to the BusinessData database each day,and that 90 percent of records are not modified after they are entered. No managed objects currently exist in any database. Database Servers The company currently has a single default instance of SQL Server 2000 in which the HRData database and the BusinessData database are stored.The SQL Server instance is installed on a server named SQL1. Written company policy to deploy a hardware RAID solution in the next six months.However,no disk redundancy solution is currently implemented. Database Client Computers Data in the HRData database
is accessed through an ASP.NET application.The application runs in the security context of a Windows user named HRApp and uses Windows Authentication to connect to SQL Server. The BusinessData database is accessed by users in the sales department,who use Windows Authentication to connect to SQL Server.In addition ,users in the software development team need to access the BusinessData database from client computers that run either a Microsoft windows operatingsystem or another operating system Users on client computers that do not run Windows use SQL Server Authentication to connect to SQL Server. All client applications are configured to connect to the SQL Server instance.Terefore,users do
not need to browse for a server. EXISTING INFRASTRUCTURE Network Infrastructure All computers are connected to a TCP/IPbased network.The network is configured as shown in the following diagram(The diagram can also be viewed by clicking the Case Study Exhibit button)
2.You need to implement a highavailability solution for the CRM database to fulfill the availability requirements. Which highavailability technology should you use?
A. database mirroring
B. database snapshot
C. replication
D. log shipping
Answer: A
3.You are planning the backup strategy for the BusinessData database. You need to include a strategy for backup redundancy. Which backup redundancy strategy should you include?
A. Back up the database to a disk backup device, and then back up the database to a tape device.
B. Use different backup devices for full backups and transaction log backups.
C. Back up only the filegroups that are not stored in a RAID disk array.
D. Use a mirrored media set to back up the database to multiple backup devices of the same type.
Answer: D
4.You are designing a data archival strategy for order data. The placements of data and partitions for the Sales.Orders table at the end of July are shown in the following display. On which filegroup should you locate partition 2 of the Sales.OrderArchive table?
A. FG1
B. FG2
C. FG3
D. FG4
Answer: B
5. You need to implement the HTTP endpoint for the Sales.AddOrder and Sales.GetOrderDetails stored procedures while minimizing the risk of unauthorized access to data and the risk of execution of unauthorized TransactSQL code. Which action or actions should you perform? (Choose all that apply.)
A. Specify that the endpoint must support BATCHES.
B. Specify that the endpoint must use Secure Sockets Layer (SSL) ports.
C. Grant CONNECT permission on the endpoint to the logins in the sales department.
D. Grant EXECUTE permission on the Sales.AddOrder and Sales.GetOrderDetails stored procedures to the users in the sales department.
E. Specify that the endpoint must use clear ports.
Answer: B, C, D
6. For the MarketingAnalysis database, you are adding functionality that sends the results of a query in an email message to the marketing supervisors when new sales data has been entered. You need to implement a method that fulfills this requirement and minimizes the security risks. Which method should you use?
A. Database Mail
B. SQL Mail
C. a managed stored procedure
D. a command line program that is called by xp_cmdshell
Answer: A
7. You are planning the configuration of the SQL Server 2005 instance where the BusinessData database
will be stored. As a security precaution, you need to ensure that Windows services that are not essential are disabled. Which Windows service or services should be disabled? (Choose all that apply.)
A. SQL Browser
B. SQL Server
C. SQL Server Analysis Services
D. SQL Writer
E. SQL Server Integration Services
F. SQL Server Agent
Answer: A, C, D
8. You need to ensure that the companys standard password policy is enforced for all logins that are used to access SQL Server 2005. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Set the appropriate local password policies for all computers on which SQL Server is installed.
B. Set the server authentication mode of all SQL Server instances to Windows Authentication mode.
C. Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.
D. Create SQL Server logins that have CHECK_POLICY enabled.
Answer: C, D
9. You are designing the backup strategy for the BusinessData database. You need to ensure that the backup strategy fulfills the business requirements for minimizing data loss and database downtime. Which three backup methods should your strategy include? (Each correct answer presents part of the solution. Choose three.)
A. differential backup every three hours
B. full database backup once per day
C. transaction log backup every three hours
D. transaction log backup every 30 minutes E.full database backup every 30 minutes F.differential backup once per day
Answer: A, B, D
10. You are designing the interim disk availability solution for SQL1. You plan to use Windows RAID functionality. You need to identify the most appropriate RAID configuration to fulfill the availability requirements. Which RAID configuration should you use?
A. Create a mirrored volume for the system files and database logs, and a stripe set with parity for the data files.
B. Create a mirrored volume for the system files and database logs, and a stripe set without parity for the data files.
C. Create a mirrored volume for the system files, database logs, and data files.
D. Create a stripe set with parity for the system files, database logs, and data files.
Answer: A
11. You want to implement database mirroring to ensure the availability of the BusinessData database. You specify SQL1 as the principal server and SQL2 as the mirror server. You need to ensure that the database mirroring solution fulfills the business requirements. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Configure SQL3 as a monitor server.
B. Configure SQL3 as a witness server.
C. Create a database snapshot of the BusinessData database.
D. Configure the mirror session to use a synchronous operating mode.
Answer: B, D
12. BACKGROUND Company Overview Proseware,Inc.,is a technical content development company that creates documentation and training materials for various software vendors.The company currently has 26 fulltime employees at its central office in Seattle,and uses more than 100 external contract writers who work from home in various locations around the would. Planned Changes The company plans to implement a new,Web servicebased solution that will facilitate the process by which remote contract writers submit work. Currently,all work is submitted by email as Microsoft Word document attachments,and it is stored in file shares on a file server named FP2.The new solution will allow work to
be submitted to a Web service in WordML format and then stored in an xml column in a new database named proseware_projects. The Web service will be hosted on an existing Web server in the perimeter network,and it will use impersonation to access the database server.A design for the new application solution is shown in the following diagram.(The diagram can also be viewed by clicking the Case Study Exhibits button.)
13. There are currently no permissions set on the following four objects in the proseware_biz database: Sales.Customersa table containing customer dataSales.CustomerContactsa table containing customer contact dataSales.ContactLista view that retrieves customer data from the Sales.Customers and Sales.CustomerContacts tablesSales.GetContacta stored procedure that retrieves data from the Sales.ContactList view You need to permit the sales_employee database role to retrieve data by using the Sales.GetContact stored procedure. Which action or actions should you perform? (Choose all that apply.)
A. Grant the SELECT permission on the Sales.Customers object to the sales_employee role.
B. Grant the SELECT permission on the Sales.CustomerContacts object to the sales_employee role.
C. Grant the SELECT permission on the Sales.ContactList object to the sales_employee role.
D. Grant the EXECUTE permission on the Sales.GetContact object to the sales_employee role.
Answer: D
14. You are creating a management plan for the proseware_biz database. You need to specify the steps that must be performed to fail over to the secondary server in order to take the primary server offline for planned maintenance. The primary server will resume its role after the maintenance task has been completed. Which step or steps should you specify? (Choose all that apply.)
A. Create a full database backup of the database on the primary server.
B. Back up the active transaction log on the primary server.
C. Restore the database on the secondary server from the most recent full backup that was taken on the primary server.
D. Apply, in sequence, existing unapplied transaction log backups to the secondary server.
Answer: B, D
15. You need to design a highavailability strategy for the proseware_projects database. Your design must fulfill all business and technical requirements. Which strategy should you use?
A. log shipping
B. failover clustering
C. database mirroring
D. replication
Answer: C
16. You are creating a management plan for the proseware_biz database. You need to specify the action that must be taken before manually inserting data through a bulk load process. Your plan must fulfill the availability and recoverability business requirements, and it also must require minimal administrative effort. Which action should you specify?
A. Create a full backup.
B. Create a differential backup.
C. Configure replication.
D. Create a database snapshot.
Answer: D
17.You need to specify the changes to the existing firewall configuration settings that are required by the HTTP endpoint that will be used by the proseware_projects database. What should you do?
A. Create a Web publishing rule on ISA2 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
B. Create a Web publishing rule on ISA1 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
C. Create a Web publishing rule on ISA2 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.
D. Create a Web publishing rule on ISA1 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.
Answer: D
18. You plan to use a managed assembly in the proseware_projects database that includes a method to save the contents of an xml column as a local file. You need to import the assembly without granting it unnecessary permissions. Which permission level should you assign to the assembly? A. EXTERNAL_ACCESS
B. the default permission level
C. SAFE
D. UNSAFE
Answer: A
19.You are designing the data archiving strategy for the proseware_projects database. You need to identify the data that should be archived when a project is completed. Your design must ensure that minimal storage space is used, and it must fulfill the business requirements for the solution. What should you do?
A. Archive all versions of all documents that belong to the completed project.
B. Archive the earliest version of all documents that belong to the completed project.
C. Archive the most recent version of all documents that belong to the completed project.
D. Archive the earliest and most recent versions of the documents that belong to the completed project.
Answer: C
20. BACKGROUND Company Overview Coho Vineyard & Winery began as a small business that supplied wine to local tetailers and restaurants.The company has grown substantially,and it now sells wine to customers all over the world. The company is based in California.The main office is located in San Francisco,and the vineyard is 60 miles to the north. Users at the vineyard access th Sales database by using an ASP.NET Web application.Customers order acses of wine by mailing or faxing a sales order form,and the details are entered manually into the database. Planned Changes The accompany recently decided to create a customer relationship management (CRM) application that will use a SQL Server
2005 database.Customer data that is currently held in the Sales database will moved to the new CRM database ,and a stored procedure will be added to the Sales database to retrieve customer data from the CRM database by using the security credentials of the original caller. The CRM database will be to all company operations.The most frequently accessed table will be the CustomerData.Customers table. The definition of this table is shown in the following code statement. CREATE TABLE CustomerData.Customers ( Customer ID int PRIMARY KEY CLUSTERED, FirstName nvarchar (25) NOT NULL, LastName nvarchar (25) NULL, MiddleName nvarchar???¨?25??NULL ) During the company??s growth,small deparemental databases have been created to store specific kinds of data.the company plans to migrate these databases to SQL Server 2005 and centralize them into a single data center that
will include the Sales and CRM databases. The company recently created a central ITdepartment,The IT department has deployed a Windows Server Update Services(WSUS) server named WSUS1 to keep all computers in the main office uptodate with the latest service packs and patches.All computers in the main office will be configured to download from this server. Problem statements The company uses log shipping to provide a redundant copy of the Sales database on second server.This secondary server must be configured to allow the swapping of log shipping roles.The two servers have not previously swapped log shipping server roles. EXISTING DATA ENVIRONMENT Databases The Sales database is configured for log shipping.The risk of minor data loss in the event of server failure is tolerable because sales orders can be manually reentered rom the paper forms. There are three smail departmental databases.Each of these databases has only a small number of users.These databases are described in the following table.
21. You plan to create a unique nonclustered index on the CustomerID, LastName, and FirstName columns of the CustomerData.Customers table in the CRM database. To aid in estimating the space requirements for the index, you identify the following variables: Estimated number of rowsClustered index key Number of columns in the indexFixed data sizeNumber of variablelength columnsAverage variablelength data size You need to identify the most significant additional variable that will increase the estimated index size. Which additional variable should you identify?
A. current number of rows
B. null bitmap
C. fill factor
D. automatically generated uniqueifier value
Answer: C
22. You design the view through which users can retrieve and update active orders in the Sales database as shown in the following code segment. CREATE VIEW OrderData.ActiveOrdersASSELECT OrderID, OrderDate, CustomerID, StatusFROM OrdersWHERE Status IN (1, 2, 3) You need to modify the view definition to enforce the business requirements for updating order status. What should you do?
A. Add a WITH ENCRYPTION clause.
B. Add a WITH SCHEMABINDING clause.
C. Add a WITH VIEW_METADATA clause.
D. Add a WITH CHECK OPTION clause.
Answer: D
23. You need to configure the Sales database to fulfill the backup requirements. Which TransactSQL statement should you use?
A. ALTER DATABASE Sales SET RECOVERY SIMPLE
B. EXEC sp_dboption 'autoclose', 1
C. ALTER DATABASE Sales SET RECOVERY FULL
D. EXEC sp_dboption 'trunc. log on chkpt.', 1
Answer: C
24. You are planning the configuration of SQL1. You need to use the most appropriate Windows account for the SQL Server service. Which account should you use?
A. a domain user account
B. a local user account
C. the NETWORK SERVICE account
D. the LOCAL SYSTEM account
Answer: A
25. You need to identify the most appropriate archiving strategy for the SalesData.Orders table in the Sales database. The archiving strategy must have the minimum impact on performance. What should you do?
A. Create a table named ArchivedData.Orders. Partition the SalesData.Orders table and its indexes, and use MERGE, SPLIT, and SWITCH functions every three months to move old order data into ArchivedData.Orders.
B. Create a table named ArchivedData.Orders. Every three months use an INSERT statement to copy
data from the SalesData.Orders table into ArchivedData.Orders, and then use a DELETE statement to remove archived data from SalesData.Orders.
C. Create a database snapshot of the Sales database every three months, and then use a DELETE
statement to remove archived data from the SalesData.Orders table.
D. Back up the Sales database to tape every three months, and then use a DELETE statement to remove archived data from the SalesData.Orders table.
Answer: A
26. You are configuring SQL1 so that the distributed query in the Sales database can access data in the CRM database on SQL2. You create a linked server for SQL2, and you create a linked server login that uses impersonation. Now, you need to ask the network administrator to configure SQL1. Which two tasks should you ask the administrator to perform? (Each correct answer presents part of the solution. Choose two.)
A. Add the user account that is used by the SQL Server service to the local Administrators group.
B. Enable the Do not trust this user for delegation Active Domain property for the user account that is used
by the SQL Server service.
C. Create a Service Principal Name (SPN) for the user account that is used by the SQL Server service.
D. Enable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server service.
Answer: C, D
Click here for more 070-443 exam questions
70-443 Exam Prep
Learn what you need to know to pass the 70-443 exam easily
Guarantee your
CertifySky offers free demo for 70-443 exam. You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products. If you want to try 70-443 Exam Prep Demo, Click the "Try Demo" button.
70-443 Certification Exam and Study Guide
There are many online resources for preparing for the
CertifySky is the online Certification Expert recognized by a worldwide audience of IT professionals and executives alike as the definitive source of training materials for the candidate seeking insight, updates and resources for vendor certifications.
70-443 Practice Test Questions, Printable PDF Braindumps
We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our 70-443 Preparation Exam Material provides you everything you will need to take a certification examination. Details are researched and produced by Certification Experts who are constantly using industry experience to produce precise, logical and verified explanations for the answers. You may get questions from different web sites or books, but logic is the key.
Our
Furthermore, we are constantly updating our 70-443 Exam. These 70-443 Exam updates are supplied free of charge to Certify Sky.com customers- hereby becoming an investment rather than a disposable product. Our clients receive the most reliable and up-to-date information when they decide to take the exam, just contact us. Our candidates walk into the Testing Room as confident as a Certification Administrator.
Like actual certification exams our 70-443 Exam is in multiple-choice questions (MCQs). After purchasing our products you are just a step away from testing for certification. Still not convinced? Try our free samples or choose to buy your 70-443 Practice Exam now!
Our 70-443 practice exams and study questions are composed by current and active Information Technology experts, who use their experience in preparing you for your future in IT.
Commitment to Your Success:
At Certifysky.com we are committed to you ongoing success. Our exams and questions are constantly being updated and compared to industry standards.
You are not about to purchase a disposable product. 70-443 practice exam updates are supplied free of charge. Regardless of how soon you decide to take the actual
The CertifySky 70-443 study guide is guaranteed to be 100% braindump free. We value the quality of training you receive through the 70-443 study guide and will never support 70-443 braindumps, or any 70-443 brain dump site. 70-443 braindump sites cannot compare to the understanding, learning and comprehension you will gain from a non-70-443 braindumps site, based on facts and case studies, like Certify Sky.
When selecting the CertifySky 70-443 exam study preparation materials, you are purchasing the highest quality CertifySky 70-443 products available through the web today. The 70-443 CertifySky practice exams and study guides are current and updated monthly, providing you with the highest 70-443 Certify Sky ROI. Start you road to 70-443 CertifySky success today, buy purchasing the CertifySky 70-443 training materials today!
