Questions & Answers PDF Page 1
Microsoft SQL
70-464 Exam
Developing Microsoft SQL Server 2012 Databases
https://www.examstrainer.com/
, Questions & Answers PDF Page 2
Version: 17.0
Case Study: 1
Scenario 1
Application Information
Your company receives invoices in XML format from customers. Currently, the invoices are
stored as files and processed by a desktop application. The application has several performance
and security issues. The application is being migrated to a SQL Server-based solution. A schema
named InvoiceSchema has been created for the invoices xml.
The data in the invoices is sometimes incomplete. The incomplete data must be stored and
processed as-is. Users cannot filter the data provided through views.
You are designing a SQL Server database named DB1 that will be used to receive, process, and
securely store the invoice data. A third-party Microsoft .NET Framework component will be
purchased to perform tax calculations. The third-party tax component will be provided as a DLL
file named Treytax.dll and a source code file named Amortize.cs. The component will expose a
class named TreyResearch and a method named Amortize(). The files are located in c:\temp\.
The following graphic shows the planned tables:
You have a sequence named Accounting.InvoiceID_Seq.
You plan to create two certificates named CERT1 and CERT2. You will create CERT1 in master.
You will create CERT2 in DB1.
You have a legacy application that requires the ability to generate dynamic T-SQL statements
against DB1. A sample of the queries generated by the legacy application appears in Legacy.sql.
Application Requirements
The planned database has the following requirements:
All stored procedures must be signed.
The original XML invoices must be stored in the database.
An XML schema must be used to validate the invoice data.
Dynamic T-SQL statements must be converted to stored procedures.
Access to the .NET Framework tax components must be available to T-SQL objects.
https://www.examstrainer.com/
Microsoft SQL
70-464 Exam
Developing Microsoft SQL Server 2012 Databases
https://www.examstrainer.com/
, Questions & Answers PDF Page 2
Version: 17.0
Case Study: 1
Scenario 1
Application Information
Your company receives invoices in XML format from customers. Currently, the invoices are
stored as files and processed by a desktop application. The application has several performance
and security issues. The application is being migrated to a SQL Server-based solution. A schema
named InvoiceSchema has been created for the invoices xml.
The data in the invoices is sometimes incomplete. The incomplete data must be stored and
processed as-is. Users cannot filter the data provided through views.
You are designing a SQL Server database named DB1 that will be used to receive, process, and
securely store the invoice data. A third-party Microsoft .NET Framework component will be
purchased to perform tax calculations. The third-party tax component will be provided as a DLL
file named Treytax.dll and a source code file named Amortize.cs. The component will expose a
class named TreyResearch and a method named Amortize(). The files are located in c:\temp\.
The following graphic shows the planned tables:
You have a sequence named Accounting.InvoiceID_Seq.
You plan to create two certificates named CERT1 and CERT2. You will create CERT1 in master.
You will create CERT2 in DB1.
You have a legacy application that requires the ability to generate dynamic T-SQL statements
against DB1. A sample of the queries generated by the legacy application appears in Legacy.sql.
Application Requirements
The planned database has the following requirements:
All stored procedures must be signed.
The original XML invoices must be stored in the database.
An XML schema must be used to validate the invoice data.
Dynamic T-SQL statements must be converted to stored procedures.
Access to the .NET Framework tax components must be available to T-SQL objects.
https://www.examstrainer.com/
