DRAG DROP
You plan to create a custom aggregation function named Median.
You plan to deploy Median to a SQL Server 2014 server named Server1.
You need to ensure that Median can access a web service named WebApp1. The solution
must minimize the number of changes made to the database.
You create a Microsoft .NET Framework class that contains the definition of Median.
You upload a certificate to Server1.
What three tasks should you perform next?
To answer, move the appropriate actions from the list of actions to the answer area and
arrange them in the correct order.
Answer: See the explanation.
Explanation:
Box 1: Execute the CREATE ASSEMBLY statement.
Box 2: Use the certificate to add a digital signature to the assembly.
Box 3: Execute the CREATE AGGREGATE statement.Note:
* CREATE AGGREGATE
Creates a user-defined aggregate function whose implementation is defined in a class of an
assembly in the .NET Framework. For the Database Engine to bind the aggregate function
to its implementation, the .NET Framework assembly that contains the implementation must
first be uploaded into an instance of SQL Server by using a CREATE ASSEMBLY
statement.
Box 1: Use the certificate to add a digital signature to the assembly.
Box 2: Execute the CREATE ASSEMBLY statement.
Box 3: Execute the CREATE AGGREGATE statement.
We should use
alter database {database name} set trustworthy on;
Box 2: Execute the CREATE ASSEMBLY statement.
Box 3: Execute the CREATE AGGREGATE statement.
**The solution must minimize the number of changes made to the database**
**You upload a certificate to Server1**
As we already have a server certificate, we wouldn’t be compelled to set ‘Database Trustworthy = ON’
Hence, @dadas is very correct.