Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Microsoft 70-459 Exam - Cheat-Test.com

Free 70-459 Sample Questions:

Q: 1
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012.
A database named CorpDB1 has many tables containing historical data about customers, products and sales. CorpDB1 is 200GB in size.
You are creating a script that uses the CREATE VIEW statement to create a view. Data in a table in CorpDB1 will be updated using the view. You need to ensure that the view can update all data in the table except the data in a column specified in a SELECT statement in the view.
How can you achieve this?
A. By including WITH SCHEMABINDING in the script.
B. By including WITH CHECK OPTION in the script.
C. By including WITH DEFAULT in the script.
D. By including WITH VIEW_METADATA in the script.
E. By including WITH ENCRYPTION in the script.
Answer: B

Q: 2
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012.
A server named ABC-SQL1 hosts an Online Transaction Processing (OLTP) database named
ABC-DB1. A table in ABC-DB1 has an index. You discover a high level of page splits when data is updated in the table or when new rows are inserted.
You plan to recreate the index on the table.
What should you do first to reduce the number of page splits?
A. Configure a FILLFACTOR value of 60 in the index options.
B. Configure a FILLFACTOR value of 100 in the index options.
C. Configure STATISTICS_NORECOMPUTE = ON in the index options.
D. Configure STATISTICS_NORECOMPUTE = OFF in the index options.
Answer: A

Q: 3
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012.
You create a table named Orders in a database named SalesDB1. The table includes a column named Date which has the NULL and SPARSE options configured.
You populate the Orders table with 1 million rows of order data. More than 800,000 rows do not have a value in the Date column.
You need to create an index for the Orders table.
You need to optimize the index so that the storage space used by the index is minimized.
Which of the following statements should you use to create the index?
A. CREATE INDEX IX_Orders ON Orders (Date)
WITH FILLFACTOR=0
B. CREATE INDEX IX_Orders ON Orders (Date)
WITH FILLFACTOR=80
C. CREATE INDEX IX_Orders ON Orders (Date)
WHERE Date IS NULL
D. CREATE INDEX IX_Orders ON Orders (Date)
WHERE Date IS NOT NULL
Answer: D

Q: 4
You work as a Database Administrator (DBA) for a company named ABC.com. The company has a Windows Azure subscription. The company uses a cloud-based SQL Server environment hosted on SQL Azure.
You have a database named ABC-DB1. The database contains a table named Entries and a table named Updates. The Updates table is used for auditing purposes.
You want the Updates table to be automatically updated every time a new row is added to the Entries table.
What is the best way to achieve this?
A. By configuring a NOT NULL constraint.
B. By configuring a CHECK constraint.
C. By configuring a Data Manipulation Language (DML) trigger
D. By configuring a Data Definition Language (DDL) trigger
Answer: C

Q: 5
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012.
You create a table using the following statement:
CREATE TABLE Orders
(
OrderID int NOT NULL PRIMARY KEY,
CustomerID int NOT NULL,
OrderDate date NOT NULL
);
You intended the table to be created in a schema named Sales. However the table was created in a schema named Purchasing.
You want to move the Orders table from the Purchasing schema to the Sales schema.
Which statement should you run?
A. ALTER TABLE Purchasing.Orders TRANSFER Sales.Orders
B. ALTER TABLE Sales.Orders TRANSFER Purchasing.Orders
C. ALTER SCHEMA Purchasing TRANSFER Sales.Orders
D. ALTER SCHEMA Sales TRANSFER Purchasing.Orders
Answer: D


© 2014 Cheat-Test.com, All Rights Reserved