Login / Register
Sharpen Your Knowledge with Microsoft (70-461) Certification Sample Questions
CertsTime has provided you with a sample question set to elevate your knowledge about the Microsoft Querying Microsoft SQL Server 2012/2014 exam. With these updated sample questions, you can become quite familiar with the difficulty level and format of the real 70-461 certification test. Try our sample Microsoft Querying Microsoft SQL Server 2012/2014 certification practice exam to get a feel for the real exam environment. Our sample practice exam gives you a sense of reality and an idea of the questions on the actual Microsoft MCSA: SQL Server 2012/2014 certification exam.
Our sample questions are similar to the Real Microsoft 70-461 exam questions. The premium Microsoft Querying Microsoft SQL Server 2012/2014 certification practice exam gives you a golden opportunity to evaluate and strengthen your preparation with real-time scenario-based questions. Plus, by practicing real-time scenario-based questions, you will run into a variety of challenges that will push you to enhance your knowledge and skills.
Microsoft 70-461 Sample Questions:
You administer a Microsoft SQL Server instance that will support several databases.
You need to ensure that the organization serial numbers can be stored in every new database created. You
also need to ensure that the serial numbers are six alphanumeric characters and have the same structure
across every database.
What should you do?
You use a Microsoft Azure SQL Database instance. The instance contains a table named Products that has columns named Code, Name, and IsPerishable.
You need to create a view named VwPerishableProducts that:
* returns rows from Products that have a value of True in the IsPerishable column;
* does not allow columns to be altered or dropped in the underlying table.
Which Transact-SQL statement should you run?
You administer a Microsoft SQL Server database named Orders.
The database contains a table named Customer that has the following definition:
You add a new data source to the application that inserts records into the Customer table. An example of a query that the application executes is shown below.
Users report that these new records are not displayed correctly. You review data in the table and observe that records from the new data source are displayed as shown below.
You need to change the database schema to support the characters coming in from this new data source. You need to achieve this goal without losing existing customer records.
Which Transact-SQL statement should you run?
You develop a Microsoft SQL Server database. You design a table to store product information. The table is defined as follows:
You need to meet the following requirements:
* If a product has a product category value "REGULAR", the product should have a sub-category with a length of two characters.
* If a product has the product category other than "REGULAR", the product may or may not have a sub-category.
Which Transact-SQL statement should you use?
You have a SQL Server database that contains all of the sales data for your company.
You need to create a query that returns the customers who represent the top five percent of the total actual sales.
Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it.
Note: If there is any error in our Microsoft 70-461 certification exam sample questions, please update us via email at support@certstime.com.
Try Before You Buy!