70-464 Exam
how to use sql server 2012 exam 70-464
Exam Code: 70-464 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Developing Microsoft SQL Server 2012 Databases
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 70-464 Exam.
2021 Nov 70-464 pdf:
Q1. Topic 8)
You have a SQL Server 2012 database named Database1. Database1 has a data file named
database1_data.mdf and a transaction log file named database1_Log.ldf. Database1_Data.mdf is
1.5 GB.
Database1_Log.ldf is 1.5 terabytes. A full backup of Database1 is performed every day.
You need to reduce the size of the log file. The solution must ensure that you can perform
transaction log backups in the future. Which code segment should you execute? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
Answer:
Q2. Topic 8)
You have a table named Table1. Table1 has 1 million rows.
Table1 has a columnstore index for a column named Column1.
You need to import data to Table1. The solution must minimize the amount of time it takes
to import the data.
What should you do?
To answer, move the appropriate actions from the list of actions to the answer area and
arrange them in the correct order.
Answer:
Q3. You need to implement a solution that meets the job application requirements. What should you do?
A. Create a one-to-one relationship between the Openings table and the Applications table.
B. Create a one-to-one relationship between the Candidates table and the Applications table.
C. Add a UNIQUE constraint to the Applications table on the ApplicationID column and CandidateID column.
D. Add a UNIQUE constraint to the Applications table on the OpeningID column and the CandidateID column.
Answer: D
Q4. You need to add a new column named Confirmed to the Attendees table.
The solution must meet the following requirements:
. Have a default value of false.
. Minimize the amount of disk space used.
Which code block should you use?
A. ALTER TABLE Attendees
ADD Confirmed bit DEFAULT 0;
B. ALTER TABLE Attendees
ADD Confirmed char(l) DEFAULT '1'
C. ALTER TABLE Attendees
ADD Confirmed bit DEFAULT 1;
D. ALTER TABLE Attendees
ADD Confirmed char(l) DEFAULT ‘1’;
Answer: A
Explanation:
http://msdn.microsoft.com/en-us/library/ms177603.aspx
Q5. You execute the following code: You need to select the task that has an IsFinished value of true from the Project that has an Id value of 1.
Which code segment should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: B
Update exam 70-464 ebook:
Q6. You have an application that uses a view to access data from multiple tables.
You need to ensure that you can insert rows into the underlying tables by using the view.
What should you do?
A. Create an INSTEAD OF trigger on the view.
B. Define the view by using the SCHEMABINDING option.
C. Define the view by using the CHECK option.
D. Materialize the view.
Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ms180800.aspx http://msdn.microsoft.com/en-us/library/ms187956.aspx
Q7. You need to implement a solution that meets the data recovery requirements. You update each stored procedure to accept a parameter named @transactionID. What should you add next to the beginning of each stored procedure?
A. SAVE TRANSACTION WITH MARK @transactionID
B. ROLLBACK DISTRIBUTED TRANSACTION @transactionID
C. BEGIN TRANSACTION WITH MARK @transactionID
D. COMMIT TRANSACTION @transactionID
Answer: C
Q8. You administer an instance of SQL Server 2014.
You are tasked with tuning a common set of queries. You have the results of several test executions, along with query plans. The schema and the data for all database object(s) used remain unchanged between executions. The QueryTime column is defined as a computed column that uses the GETDATE() system function. The query plans and results are shown below: You need to make an initial diagnosis of the situation, based solely on this input
Which two statements can you make about the performance characteristics of this query? Each correct answer presents a complete solution. Choose two.
A. The queries would perform better if the index named AccountNumber included the Name and QueryTime column.
B. The queries would perform worse if the index named AccountNumber included the NameColumn.
C. The queries would perform better if the index named AccountNumber included the Name column.
D. The object Account is a table, with an index having a leading column of AccountNumber and a Clustered Index named PKAccount.
E. The object Account is an indexed view, with an index having a leading column of AccountNumber and a Clustered Index named PKAccount.
F. The object Account is a view, joining the Account-AccountNumber and Account.PKAccount objects together.
Answer: B,D
Q9. ...
You have a SQL Server 2012 instance named SQL\Instance1. Instance1 contains a database named Database1.
You need to recommend an index defragmentation solution for an index named ContentIndex. ContentIndex must meet the following requirements:
Remain online during the defragmentation.
Update distribution statistics.
Perform defragmentation as quickly as possible.
Which type of index defragmentation solution should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.
A. DBCC DBREINDEX
B. REORGANIZE
C. REBUILD
D. DBCC INDEXDEFRAG
Answer: B
Q10. You execute IndexManagement.sql and you receive the following error message: "Msg 512, Level 16, State 1, Line 12
Subquery returned more than 1 value. This is not permitted when the subquery follows =, != ,<, <= , >, > = or when the subquery is used as an expression."
You need to ensure that IndexManagement.sql executes properly.
Which WHILE statement should you use at line 18?
A. WHILE SUM(@RowNumber) < (SELECT @counter FROM @indextable)
B. WHILE @counter < (SELECT SUM(RowNumber) FROM @indextable)
C. WHILE COUNT(@RowNumber) < (SELECT @counter FROM @indextable)
D. WHILE @counter < (SELECT COUNT(RowNumber) FROM @indextable)
Answer: D