70-469 Exam
Finding Leading 70-469 free samples
Exam Code: 70-469 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Recertification for MCSE: Data Platform
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 70-469 Exam.
Q111. You need to recommend a solution that addresses the file storage requirements.
What should you include in the recommendation?
A. FileStream
B. FileTable
C. The varbinary data type
D. The image data type
Answer: B
Q112. You have a database that uses the following management views:
Sys.dm_os_volume_stats
Sys.dm_db_partition_stats
Sys.dm_db_file_space_usage
Sys.fulltext_indexes
You plan to migrate the database to Microsoft SQL Azure.
You need to identify which view can be used in SQL Azure.
Which view should you identify?
A. sys.fulltext_indexes
B. sys.dm_db_file_space_usage
C. sys.dm_os_volume_stats
D. sys.dm_db_partition_stats
Answer: D
Q113. You have a database hosted on SQL Azure.
You are developing a script to create a view that will be used to update the data in a table.
The following is the relevant portion of the script. (Line numbers are included for reference only.)
You need to ensure that the view can update the data in the table, except for the data in Column1.
Which code segment should you add at line 06?
A. WITH CHECK OPTION
B. WITH VIEW_METADATA
C. WITH ENCRYPTION
D. WITH SCHEMABINDING
Answer: A
Q114. You need to recommend a disaster recovery solution for the Dev database.
What should you include in the recommendation?
A. The simple recovery model and full backups
B. The bulk-logged recovery model and full backups
C. The full recovery model, full backups, and differential backups
D. The full recovery model, full backups, and transaction log backups
Answer: A
Q115. You have a SQL Server 2012 database named DB1. You have a backup device named Device1.
You discover that the log file for the database is full.
You need to ensure that DB1 can complete transactions. The solution must not affect the chain of log sequence numbers (LSNs).
Which code segment should you execute?
A. BACKUP LOG DB1 TO Device1 WITH COPY_ONLY
B. BACKUP LOG DB1 TO Device1 WITH NORECOVERY
C. BACKUP LOG DB1 TO Device1 WITH TRUNCATE_ONLY
D. BACKUP LOG DB1 TO Device1
Answer: D
Q116. 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. Scan for Startup Procs
B. Enable Contained Databases
C. Optimize for Ad hoc Workloads
D. Allow Triggers to Fire Others
Answer: C
Q117. You need to modify usp_GetOrdersAndItems to ensure that an order is NOT retrieved by usp_GetOrdersAndItems while the order is being updated.
What should you add to usp_GetOrdersAndItems?
A. Add SET TRANSACTION ISOLATION LEVEL SERIALIZABLE to line 03.
B. Add SET TRANSACTION ISOLATION LEVEL SNAPSHOT to line 03.
C. Add (UPDLOCK) to the end of line 06.
D. Add (READPAST) to the end of line 06.
Answer: D
Q118. You are creating a table named Orders.
You need to ensure that every time a new row is added to the Orders table, a user-defined function is called to validate the row before the row is added to the table.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
A. A data manipulation language (DML) trigger
B. A DEFAULT constraint
C. A Data Definition Language (DDL) trigger
D. A CHECK constraint
E. A FOREIGN KEY constraint
Answer: D
Q119. You use SQL Server 2014. The physical server is a dedicated database server that has 120GB of RAM available. There is approximately 50GB of storage space available on a slow local disk.
You create a new stored procedure. You decide you need to temporarily hold approximately 300,000 rows from two tables, from which you will compute two complex business scores.
The stored procedure will use temporary storage defined as follows: The code will make several passes through the data, applying complex calculations before writing the data to a permanent disk-based table in the same database from which it reads the data.
For this stored procedure, you need to deal with temporary data in the most efficient way to minimize physical disk pressure.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q120. You create a table named Customers by using the following code segment:
You create a non-clustered index named IX_Name on the name column.
You write the following query to retrieve all of the customers that have a name that starts with the letters SMI:
You discover that the query performs a table scan.
You need to ensure that the query uses the index.
What should you do?
A. Replace LEFT(name,3) = 'smi' by using name like 'smi%'
B. Replace LEFT(name,3) = 'smi' by using substring(name,l,3) = 'smi'
C. Recreate IX_Name as a unique index
D. Recreate IX Name as a clustered index
Answer: A