The 70-464 exam is meant to be taken by database professionals who build and implement databases across the organization, while ensuring high levels of data availability. You should be about the perform tasks including creating database files, create data types, tables, plan create and optimize indexes, Implement data integrity, Implement views, stored procedures and functions, manage transactions and locks. Microsoft states that the exam is meant to be taken by those whose primary responsibilities may include:
Optimize and tune queries.
Create and alter stored procedures.
Create and alter indexes.
Maintain database integrity.
Optimize indexing strategies.
Create and alter tables.
Maintain indexes.
Create and modify constraints.
Create and alter views.
Create and alter user-defined functions (UDFs).
Control execution plans.
Work with XML Data
Implement full-text search.
Troubleshoot security.
Write automation scripts.
Troubleshoot performance issues.
After passing the Developing Microsoft SQL Server 2012 Databases (70-464) exam, you complete the requirements for the MCSE: Data Platform certification.
*** This course does not content the study material. This course contains 148 questions ***