70-464 Exam
examcollection 70-464 (81 to 90)
Examcollection?¡¥s Microsoft Microsoft exam practice demos contain the key words with the real analyze. Questions and answers are designed from the Microsoft IT specialists around the earth. They have got rich encounter in the compiling the particular Microsoft 70-464 exam practice materials. Weve full confidence that individuals promise a person 100% passing guarantee. Since our Microsoft Microsoft exam demos are comprised of the past and latest necessary contents reflected from the real exam. The experts are dedicated for you to search essentially the most technical and comprehensive materials for the Microsoft certification exam. The actual Microsoft 70-464 prep package has attracted numerous people together with its higher standard of good quality and accuracy.
2021 Aug training kit (exam 70-464) pdf:
Q81. You have an index for a table in a SQL Azure database. The database is used for Online
Transaction Processing (OLTP).
You discover that the index consumes more physical disk space than necessary.
You need to minimize the amount of disk space that the index consumes.
What should you set from the index options?
A. STATISTICS_NORECOMPUTE = OFF
B. FILLFACTOR = 80
C. FILLFACTOR = 0
D. STATISTICS_NORECOMPUTE = ON
Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ms177459.aspx http://msdn.microsoft.com/en-us/library/ms188783.aspx
Q82. You have a Microsoft SQL Azure database named DBAzurel. DBAzurel contains a table named Orders that stores sales data.
Each order has a sales total that can only be discovered by querying multiple tables.
You need to ensure that the value of the sales total is returned by executing a query on Orders.
What should you create?
A. A calculated column that uses a scalar function
B. A trigger that uses a table-valued function
C. A calculated column that uses a table-valued function
D. A trigger that uses a ranking function
Answer: C
Explanation: A table-valued parameter is scoped to the stored procedure, function, or
dynamic Transact-SQL text, exactly like other parameters. Similarly, a variable of table type
has scope like any other local variable that is created by using a DECLARE statement. You
can declare table-valued variables within dynamic Transact-SQL statements and pass
these variables as table-valued parameters to stored procedures and functions.
Table-valued parameters offer more flexibility and in some cases better performance than
temporary tables or other ways to pass a list of parameters.
Incorrect:
Not A: A scalar function would only be able to use other columns from the same table.
Q83. You need to implement a solution that meets the security requirements. Which statement should you execute?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q84. You need to create the object used by the parameter of usp_InsertSessions.
Which statement should you use?
A. CREATE SCHEMA SessionDataTable
B. CREATE TYPE SessionDataTable AS Table
C. CREATE TABLE SessionDataTable
D. CREATE XML SCHEMA COLLECTION SessionDataTable
Answer: A
Q85. You have a database that contains a table named Department. Department contains the names and locations of each department.
You have a table-valued function named ProjectList() that returns a list of all the projects assigned to a department. The name of the department is passed as an argument to the ProjectList() function.
You need to create a query that returns a list of all the department names and the project names. The solution must return only departments that are associated to projects.
What should you add to the query?
A. OUTER APPLY
B. OUTER JOIN
C. CROSS JOIN
D. CROSS APPLY
Answer: D
Replace training kit 70-464:
Q86. Topic 7)
You need to optimize the index and table structures for POSTransaction.
Which task should you use with each maintenance step? To answer, drag the appropriate tasks to the correct maintenance steps. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Answer:
Q87. Your network contains a server that has SQL Server 2014 installed. You create a table by using the following script:
You need to recommend a solution to ensure that each combination of ProductName and ProductManufacturer is not duplicated.
What should you recommend creating?
A. A UNIQUE constraint
B. A filtered index
C. A columnstore index
D. A CHECK constraint
Answer: A
Q88. Topic 8)
You have a table named Table1 that contains 1 million rows. Table1 contains a column named Column1 that stores sensitive information. Column1 uses the nvarchar (16) data type.
You have a certificate named Cert1.
You need to replace Column1 with a new encrypted column named Column2 that uses one-way hashing.
Which code segment should you execute before you remove Column1?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
Answer:
Q89. You need to implement a solution that resolves the salary query issue. Which statement should you execute on DB1?
A. Option A B. Option B
C. Option C
D. Option D
Answer: A
Q90. You need to provide referential integrity between the Offices table and Employees table.
Which code segment or segments should you add at line 27 of Tables.sql? (Each correct answer presents part of the solution. Choose all that apply.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C,D
Explanation:
http://msdn.microsoft.com/en-us/library/ms189049.aspx
Topic 4, Scenario 4
Application Information
You are a database administrator for a manufacturing company.
You have an application that stores product data. The data will be converted to technical diagrams for the manufacturing process.
The product details are stored in XML format. Each XML must contain only one product that has a root element named Product. A schema named Production.ProductSchema has been created for the products xml.
You develop a Microsoft .NET Framework assembly named ProcessProducts.dll that will be used to convert the XML files to diagrams. The diagrams will be stored in the database as images. ProcessProducts.dll contains one class named ProcessProduct that has a method name of Convert(). ProcessProducts.dll was created by using a source code file named ProcessProduct.cs.
All of the files are located in C:\Products\.
The application has several performance and security issues.
You will create a new database named ProductsDB on a new server that has SQL Server
2012 installed. ProductsDB will support the application.
The following graphic shows the planned tables for ProductsDB:
You will also add a sequence named Production.ProductID_Seq.
You plan to create two certificates named DBCert and ProductsCert. You will create ProductsCert in master. You will create DBCert in ProductsDB.
You have an application that executes dynamic T-SQL statements against ProductsDB. A sample of the queries generated by the application appears in Dynamic.sql.
Application Requirements
The planned database has the following requirements: All stored procedures must be signed. The amount of disk space must be minimized. Administrative effort must be minimized at all times. The original product details must be stored in the database. An XML schema must be used to validate the product details. The assembly must be accessible by using T-SQL commands. A table-valued function will be created to search products by type. Backups must be protected by using the highest level of encryption. Dynamic T-SQL statements must be converted to stored procedures. Indexes must be optimized periodically based on their fragmentation. Manufacturing steps stored in the ManufacturingSteps table must refer to a product by the same identifier used by the Products table.
ProductDetails_Insert.sql
...........
Product, xml
All product types are 11 digits. The first five digits of the product id reference the category of the product and the remaining six digits are the subcategory of the product.
The following is a sample customer invoice in XML format:
ProductsByProductType.sql
Dynamic.sql
Category FromType.sql
IndexManagement.sql
30. An administrator provides a digital certificate named ServerCert.
You need to implement Transparent Data Encryption (TDE) on ProductsDB.
Which code segment should you use?
A. USE PRODUCTSDB; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY ENCRYPTION BY SERVER CERTIFICATE DBCERT; GO ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON; GO B. USE PRODUCTSDB; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT; GO ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON; GO
C. USE PRODUCTSDB; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT; GO ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON; GO
D. USE PRODUCTSDB; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE DBCERT; GO ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON; GO
Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/bb934049.aspx