Microsoft 70-469 Actual Free Exam Questions & Community Discussion

DRAG DROP
You use SQL Server 2014.
You need to create a single object that inserts a provided value into Table1, and then returns a count of the records in Table1.
Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks.

DRAG DROP
You are designing a database for a university. The database will contain two tables named
Classes and StudentGrades that have the following specifications:
- Classes will store brochures in the XPS format. - The brochures must be structured in folders and must be accessible byusing UNC paths. - StudentGrades must be backed up on a separate schedule than the rest ofthe database.
You need to identify which SQL Server technology meets the specifications of each table. Which technologies should you identify? To answer, drag the appropriate technology to the correct table in the answer area.

DRAG DROP
You need to recommend a backup process for data warehouse database.
The solution must meet the following requirements:
- Ensure that if a hardware failure occurs, you can bring the database online without
losing more than 24 hours of transactions. - Minimize the amount of administrative effort required to restore any lost data. - Minimize the space used by transaction logs.
What should you include in the recommendation?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You use SQL Server 2012 to maintain the data used by the applications at your company.
You plan to create a table named Table1 by using the following statement. (Line numbers are included for reference only.)

---
You need to ensure that Table1 contains a column named UserName. The UserName column will:
Store string values in any language.
Accept a maximum of 200 characters.
Be case-insensitive and accent-insensitive.
Which code segment should you add at line 03?

You deploy a database by using SQL Server 2014. The database contains a table named Table1.
You need to recommend a solution to track all of the deletions executed on Table1. The solution must minimize the amount of custom code required.
What should you recommend?

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?

You have a SQL Server 2012 environment that contains two servers. The servers are configured as shown in the following table.

After the failover is complete, a user receives the following error message when connecting to DB1 on Server2:
"Msg 916, Level 14, State 1, Line 1 The server principal "Account1" is not able to access the database "DB1" under the current security context."
You verify that there is a server login for Account1 on Server2.
You need to ensure that Account1 can connect to DB1.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

You need to convert the functionality of Legacy.sql to use a stored procedure. Which code segment should the stored procedure contain?

You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows.
You need to recommend a repeatable method to migrate the database to SQL Azure.
Which method should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You need to recommend a solution that resolves the missing data issue. The solution must minimize the amount of development effort.
What should you recommend?

You plan to create a database that has multiple tables. The tables will contain product information. Each product has a stock-keeping unit (SKU).
You need to recommend a solution to ensure that each SKU starts with the letters "ADV" and is followed by 10 digits.
The solution must minimize the amount of development effort required.
What should you include in the recommendation?

DRAG DROP
You plan to deploy a database by using SQL Server 2014.
Your company identifies the following requirements for the database: - The name of all stored procedures must start with "usp_"always. - All distribution statistics must be updated daily. You need to identify which feature must be used to meet each database requirement.
Which features should you identify?
To answer, drag the appropriate feature to the correct database requirement in the answer
area.