Get a complete hold on 70-464 exam syllabus through Lead2pass training and boost up your skills. No need to hassle if you are stuck in exam difficulties, Lead2pass will assist you right through exam specific preparation material. Lead2pass delivers the most comprehensive preparation material, covering each and every aspect of 70-464 exam curriculum.
QUESTION 151
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 152
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 153
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
QUESTION 154
You have a SQL Server 2012 database named Database1.
You execute the following code:
You insert 3 million rows into Sales.
You need to reduce the amount of time it takes to execute Proc1.
What should you do?
A. Run the following: ALTER TABLE Sales ALTER COLUMN OrderDate datetime NOT NULL;
B. Change the WHERE clause to the following: WHERE OrderDate BETWEEN CAST(@date1,char(10))AND CAST(@date2,char(10))
C. Remove the ORDER BY clause from the stored procedure.
D. Run the following:DROP INDEX IX_Sales_OrderDate;GO CREATE INDEX IX_Sales_OrderDate ON Sales(OrderDate); GO
Answer: C
QUESTION 155
Your network contains a server that has SQL Server 2012 installed.
You create a table by using the following script:
You need to recommend a solution to ensure that each combination of ProductName and ProductManufacturer is not duplicated.
What should you recommend creating?
A. A UNIQUE constraint
B. A CHECK constraint
C. A filtered index
D. A column store index
Answer: A
QUESTION 156
You need to monitor the health of your tables and indexes in order to implement the required index maintenance strategy.
What should you do?
A. Query system DMVs to monitor avg_chain_length and max_chain_length. Create alerts to notify you when these values converge.
B. Create a SQL Agent alert when the File Table: Avg time per file I/O request value is increasing.
C. Query system DMVs to monitor total_bucket_count. Create alerts to notify you when this value increases.
D. Query system DMVs to monitor total_bucket_count. Create alerts to notify you when this value decreases.
Answer: A
QUESTION 157
Drag and Drop Question
You need to design the UserActivity table.
Which three steps should you perform in sequence? To answer, move the appropriate three actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
QUESTION 158
You need to implement security for the restore and audit process.
What should you do?
A. Grant the COFFECORP\Auditors group ALTER ANY CONNECTION and SELECT ALL USER SECURABLES permissions. Grant the COFFECORP\StoreAgent group ALTER ANY CONNECTION and IMPERSONATE ANY LOGIN permissions.
B. Grant the COFFECORP\Auditors group CONNECT ANY DATABASE and IMPERSONATE ANY LOGIN permissions. Grant the COFFECORP\StoreAgent groupCONNECT ANY DATABASE and SELECT ALL USER SECURABLES permissions.
C. Grant the COFFECORP\Auditors group ALTER ANY CONNECTION and IMPERSONATE ANY LOGIN permissions. Grant the COFFECORP\StoreAgent group ALTER ANY CONNECTION and SELECT ALL USER SECURABLES permissions.
D. Grant the COFFECORP\Auditors group CONNECT ANY DATABASE and SELECT ALL USER SECURABLES permissions. Grant the COFFECORP\StoreAgent group CONNECT ANY DATABASE and IMPERSONATE ANY LOGIN permissions.
Answer: A
QUESTION 159
Drag and Drop Question
You need to create the usp.AssignUser stored procedure.
Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks.
Answer:
QUESTION 160
Drag and Drop Question
You need to implement a new version of usp_AddMobileLocation. Develop the solution by selecting and arranging the required code blocks in the correct order.
You may not need all of the code blocks.
Answer:
70-464 exam is worth challenging task but you should not feel hesitant against the confronting difficulties. Get a complete hold on 70-464 exam syllabus through Lead2pass training and boost up your skills. No need to hassle if you are stuck in exam difficulties, Lead2pass will assist you right through exam specific preparation material. Lead2pass delivers the most comprehensive preparation material, covering each and every aspect of 70-464 exam curriculum.