70-457 試験問題を無料オンラインアクセス

You administer a single Microsoft SQL Server instance on a two-node failover cluster that has nodes named Node A and Node B.
The instance is currently running on Node A.
You want to patch both Node A and Node B by using the most recent SQL Server Service Pack. You need to ensure that the following requirements are met:
Both nodes receive the update.
Downtime is minimized.
No data is lost.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the
list of actions to the answer area and arrange them in the correct order.)
Build List and Reorder:

正解：

Explanation:
--Burgos - YES (I dont remember if was with NodeA or NodeB active)
Reference: http://technet.microsoft.com/en-us/library/ms191009.aspx Reference: http://technet.microsoft.com/en-us/library/ms191295.aspx

You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?

• A.ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE
• B.CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP EXISTING
• C.ALTER INDEX ALL ON OrderDetail REBUILD
• D.ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD

You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the database. You need to ensure that the following requirements are met:
No more than 5 minutes worth of transactions are lost.
Data can be recovered by using the minimum amount of administrative effort.
What should you do? Choose all that apply.

• A.Create a DIFFERENTIAL database backup every 24 hours.
• B.Configure the database to use the FULL recovery model.
• C.Create a DIFFERENTIAL database backup every 4 hours.
• D.Create a LOG backup every 5 minutes.
• E.Configure the database to use the SIMPLE recovery model.
• F.Create a FULL database backup every 24 hours.

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics:
A data file of 2 terabytes is located on a dedicated LUN (drive D).
A transaction log of 10 GB is located on a dedicated LUN (drive E).
Drive D has 1 terabyte of free disk space.
Drive E has 5 GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday between
09:00
hours and 17:00 hours. Five percent of the existing data is modified each day. The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database. These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours. You need to ensure that the minimum amount of data is lost. Which recovery model should the database use?

• A.CHECKSUM
• B.NO_CHECKSUM
• C.RESTART
• D.Differential
• E.Transaction log
• F.STANDBY
• G.DBO_ONLY
• H.CONTINUE_AFTER_ERROR
• I.SIMPLE
• J.BULK_LOGGED
• K.NORECOVERY
• L.FULL
• M.SKIP
• N.COPY_ONLY

You are a database developer of a Microsoft SQL Server 2012 database. The database contains a table named Customers that has the following definition:

You need to ensure that the CustomerId column in the Orders table contains only values that exist in the CustomerId column of the Customer table. Which Transact-SQL statement should you use?

• A.ALTER TABLE Orders ADD CONSTRAINT PK_Orders_CustomerID PRIMARY KEY (CustomerID)
• B.ALTER TABLE Customer ADD OrderID INT NOT NULL;
  ALTER TABLE Customer ADD CONSTRAINT FK_Customer_OrderID FOREIGN KEY (OrderID) REFERENCES Orders (OrderID);
• C.ALTER TABLE Orders ADD CONSTRAINT FK_Orders_CustomerID FOREIGN KEY (CustomerID) REFERENCES Customer (CustomerID)
• D.ALTER TABLE Orders ADD CONSTRAINT CK_Orders_CustomerID CHECK (CustomerID IN (SELECT CustomerId FROM Customer))
• E.ALTER TABLE Customer ADD CONSTRAINT FK_Customer_CustomerID FOREIGN KEY (CustomerID) REFERENCES
  Orders (CustomerID)