单项选择题
You need to design the retrieval of advertising statistics without compromising security. What should you do?（）
A.Design a Notification Services solution that sends the advertising statistics to specified subscribers by e-mail.
B.Design a SQL Server Web service that runs a stored procedure to return the statistics on a call from the advertisers application.
C.Design a Database Mail solution that sends the advertising statistics to e-mail addresses that are specified in a table.
D.Design a stored procedure to return the statistics on a call from the advertisers application.
E.Design a user-defined function to return the statistics on a call from the advertisers application.
相关考题
-
单项选择题
You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）
A.one that uses an internal SQL Server Web service endpoint
B.one that runs a SQL Server Integration Services （SSIS） package
C.one that uses Service Broker
D.one that runs a user-defined function -
多项选择题
YouneedtoensurethatthestoredprocedurethatinsertsnewloanrequestscanaccessdataintablesthatarestoredinanotherdatabaseonthesameSQLServerinstance.Whichtwoactionsshouldyouperform?（）
A.Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.
B.Ensure that the stored procedure and the tables are owned by the same database user.
C.Ensure that the stored procedure and the tables use the same database schema.
D.Configure the multiuser database option on both databases.
E.Configure the cross-database ownership chaining option on both databases. -
单项选择题
YouneedtodesignthestorageoftheapplicationtextsforUIelementstofulfilltherequirements.Whichtableandcolumndesignshouldyouuse?（）
A.Languages (LanguageID, Name)Elements (ElementID, Description)ElementLanguages (ElementID, LanguageID, Text)
B.Languages (LanguageID, Name)Elements (ElementID, LanguageID, Description, Text)
C.Languages (LanguageID, Name)ElementTexts (LanguageID, Text)ElementDescriptions (ElementID, Description)
D.Languages (LanguageID, Name)Elements (ElementID, Description, Text)
