70-469 Exam
Top 10 testing bible 70-469 for IT engineers (21 to 30)
It is impossible to pass Microsoft 70-469 exam without any help in the short term. Come to Testking soon and find the most advanced, correct and guaranteed Microsoft 70-469 practice questions. You will get a surprising result by our Up to date Recertification for MCSE: Data Platform practice guides.
2021 Dec 70-469 practice question
Q21. You have a SQL Server instance on a server named Server1.
You need to recommend a solution to perform the following tasks every week:
Rebuild the indexes by using a new fill factor.
Run a custom T-SQL command.
Back up the databases.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A. A trigger
B. An alert
C. A maintenance plan
D. Windows PowerShell
E. A system policy
Answer: C
Q22. You need to implement a solution that meets the site requirements.
What should you implement?
A. A non-indexed view on Server1
B. A non-indexed view on Server2
C. A distributed view on Server1
D. A distributed view on Server2
Answer: C
Q23. Which code segment should you use to define the ProductDetails column?
A. ProductDetails xml (DOCUMENT Production.ProductDetailsSchema) NULL
B. ProductDetails xml NULL
C. ProductDetails xml (CONTENT Production.ProductDetailsSchema) NULL
D. ProductDetails varchar(MAX) NULL
Answer: D
Q24. You have a SQL Server 2014 environment That contains 20 servers.
The corporate security policy states that all SQL Server 2014 instances must meet specific security standards.
You need to recommend a management strategy for the SQL Server 2014 servers.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
A. Multi server jobs
B. Policy-Based Management
C. Common criteria compliance
D. Maintenance plans
Answer: B
Q25. You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application.
What should you recommend changing?
A. The collation of the Products table
B. The index on the ProductName column
C. The collation of the ProductName column
D. The data type of the ProductName column
Answer: C
Abreast of the times 70-469 exam cram:
Q26. You administer a SQL Server 2014 instance.
Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could be causing issues.
You want to write a query of the system views that will report the following:
Number of users that have a connection to the server
Whether a user's connection is active
Whether any connections are blocked
What queries are being executed
Whether the database restore is still executing and, if it is, what percentage of the restore is complete.
Which system objects should you use in your query to best achieve this task?
A. sys.dm_exec_requests, sys.dm_exec_sessions, sys.objects
B. sys.dm_exec_sessions, sys.dm_exec_query_stats, sys.dm_exec_query_text,sys.objects
C. sys.sysprocesses, sys.dm_exec_query_text, sys.objects
D. sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_query_text
Answer: D
Q27. You need to implement a backup strategy to support the requirements.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.
A. Create a credential called MyCredential on SQL Server by using a Windows domain account and password.
B. Schedule a full backup by using the command BACKUP DATABASE ProdDB TO DISK...
C. Create a share on your Windows Azure site by using your Windows Azure storage account information, and grant permission to the SQL Server service login.
D. Schedule a full backup by using the command BACKUP DATABASE ProdDB TO URL ... WTTH CREDENTIAL=N'MyCredential'
E. Create a share on the hot standby site and grant permission to the SQL Server service login.
F. Create a credential called MyCredential on SQL Server, using MyStorageAccount for the storage account name and StorageAccountKey for the access key.
G. Schedule a full backup by using the command BACKUP DATABASE ProdDB TO SHARE ... WITH CREDENTIAL=N' MyCredential'
Answer: CD
Q28. Which data type should you use for CustomerID?
A. varchar(11)
B. bigint
C. nvarchar(11)
D. char(11)
Answer: D
Q29. You need to modify the stored procedure usp_LookupConcurrentUsers.
What should you do?
A. Use the summary table as an in-memory optimized table with a non-hash clustered index.
B. Use the summary table as an in-memory optimized table with a non-hash nonclustered index.
C. Use a type variable instead of the summary table.
D. Add a clustered index to the summary table.
Answer: A
Q30. 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: CD