Free Download Microsoft 70-464 PDF Full Version Now (11-20)

QUESTION 11
You have a text file that contains an XML Schema Definition (XSD). You have a table named Schemal.Table1. You have a stored procedure named Schemal.Proc1 that accepts an XML parameter named Param1. You need to store validated XML data in Schemal.Table1. The solution must ensure that only valid XML data is accepted by Param1. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

A.    Define an XML column in Table1 by using an XML schema collection.
B.    Create an XML schema collection in the database from the text file.
C.    Declare Param1 var1 as type XML and associate the variable to the XML schema collection.
D.    use the modify method to insert the XML schema into each row of the XML column in Table1.

Answer: ABD
Explanation:
http://msdn.microsoft.com/en-us/library/bb510420.aspx http://msdn.microsoft.com/en-us/library/ms187856.aspx
http://msdn.microsoft.com/en-us/library/ms176009.aspx http://msdn.microsoft.com/en-us/library/hh403385.aspx http://msdn.microsoft.com/en-us/library/ms184277.aspx

QUESTION 12
You have an index for a table in a SQL Azure database. The database is used for Online Transaction Processing (OLTP). You discover that many page splits occur when records are inserted or updated in the table. You need to minimize the number of page splits. What should you set from the index options?

A.    STATISTICS_NORECOMPUTE = ON
B.    FILLFACTOR = 0
C.    STATISTICS_NORECOMPUTE = OFF
D.    FILLFACTOR = 80

Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/ms188783.aspx http://msdn.microsoft.com/en-us/library/ms177459.aspx

QUESTION 13
You have a SQL Azure database. You execute the following script:
CREATE TABLE dbo.Table1
(
Column1 int PRIMARY KEY,
Colunm2 varchar(50) SPARSE NULL )
You add 1 million rows to Table1. Approximately 85 percent of all the rows have a null value for Column2. You plan to deploy an application that will search Column2. You need to create an index on Table1 to support the planned deployment. The solution must minimize the storage requirements. Which code segment should you execute?

A.    CREATE INDEX IX_Table1 ON Table1 (Column2)
WITH FILLFACTOR-0
B.    CREATE INDEX IX_Table1 OK Table1 (Column1)
INCLUDE (Column2)
C.    CREATE INDEX IX_Table1 ON Table1 (Column2)
WHERE Column2 IS NULL
D.    CREATE INDEX IX_Table1 ON Table1 (Column2)
WHERE Column2 IS NOT NOLL

Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/ms188783.aspx http://msdn.microsoft.com/en-us/library/cc280372.aspx

QUESTION 14
You are creating a table named Orders. You need to ensure that every time a new row is added to the Orders table, a table that is used for auditing is updated. What should you use? More than one answer choice may achieve the goal. Select the BEST answer.

A.    a CHECK constraint
B.    a FOREIGN KEY constraint
C.    a DEFAULT constraint
D.    a data manipulation language (DML) trigger
E.    a Data Definition Language (DDL) trigger

Answer: D
Explanation:
http://www.techrepublic.com/blog/programming-and-development/comparing-sql-server- constraints-and-dmltriggers/402
http://msdn.microsoft.com/en-us/library/ms178110.aspx

QUESTION 15
You have a SQL Azure database. You need to identify which keyword must be used to create a view that will be indexed. Which keyword should you identify?

A.    VIEW_METADATA
B.    SCHEMABINDING
C.    DEFAULT
D.    DISTINCT

Answer: B
Explanation:
http://msdn.microsoft.com/en-us/library/ms187956.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx

QUESTION 16
You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain user-created stored procedures or user-created functions. You need to minimize the amount of memory used for query plan caching. Which advanced server option should you modify?

A.    Enable Contained Databases
B.    Allow Triggers to Fire Others
C.    Optimize for Ad hoc Workloads
D.    Scan for Startup Procs

Answer: C

QUESTION 17
You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/Server01 is the primary replica. You have multiple queries that read data and produce reports from the database. You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica. What should you do?

A.    Set the Availability Mode property of HA/Server02 to Asynchronous commit.
B.    Set the Readable Secondary property of HA/Server02 to Read-intent only.
C.    Set the Connections in Primary Role property of HA/Server01 to Allow read/write connections.
D.    Set the Availability Mode property of HA/Server01 to Asynchronous commit.

Answer: B

QUESTION 18
You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain. You plan to configure database mirroring. You need to be able to create database mirroring endpoints on both servers. What should you do?

A.    Configure the SQL Server service account to use Network Service.
B.    Use a server certificate.
C.    Use a database certificate.
D.    Configure the SQL Server service account to use Local System.

Answer: B

QUESTION 19
You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.

A.    Disable FILESTREAM on the Database.
B.    Enable FILESTREAM on the Server Instance.
C.    Configure the Database for Partial Containment.
D.    Create a non-empty FILESTREAM file group.
E.    Enable Contained Databases on the Server Instance.
F.    Set the FILESTREAM directory name on the Database.

Answer: BDF

QUESTION 20
You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?

A.    Configure the application as data-tiered.
B.    Open port 1433 on the Windows firewall on the server.
C.    Configure the named SQL Server instance to use an account that is a member of the Domain Admins group.
D.    Start the SQL Server Browser Service.

Answer: D

If you want to pass Microsoft 70-464 successfully, donot missing to read latest lead2pass Microsoft 70-464 practice exams.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/70-464.html

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back