View Full Databricks Certified Data Engineer Professional Exam Dumps and Practice Test Dumps   Question 281. Which Spark SQL function can create an array containing multiple expressions? 1) array() 2) createArray() 3) make_array_column() 4) array_create() Answer: 1) array() Explanation: The array() function creates an array from multiple expressions or columns. It is useful when several […]

View Full Databricks Certified Data Engineer Professional Exam Dumps and Practice Test Dumps   Question 301. Which function can generate a unique numeric identifier for rows in a Spark DataFrame without requiring a global sequential sequence? 1) monotonically_increasing_id() 2) row_number() 3) dense_rank() 4) zipWithIndex() Answer: 1) monotonically_increasing_id() Explanation: The monotonically_increasing_id() function generates 64-bit integer values […]

View Full Databricks Certified Data Engineer Professional Exam Dumps and Practice Test Dumps   Question 321. Which Spark SQL function returns the number of characters in a string? 1) char_length() 2) string_size() 3) text_length() 4) count_chars() Answer: 1) char_length() Explanation: The char_length() function returns the number of characters contained in a string. It is useful […]

View Full Databricks Certified Data Engineer Professional Exam Dumps and Practice Test Dumps   Question 341. Which Spark SQL function splits a string into an array using a specified delimiter? 1) split() 2) string_split() 3) split_string() 4) tokenize() Answer: 1) split() Explanation: The split() function divides a string into an array based on a specified […]

View Full Databricks Certified Data Engineer Professional Exam Dumps and Practice Test Dumps   Question 361. Which function sorts the elements of an array in ascending order in Spark SQL? 1) array_sort() 2) array_join() 3) array_except() 4) arrays_zip() Answer: 1) array_sort() Explanation: The array_sort() function sorts the elements within an array and returns a new […]

View Full Databricks Certified Data Engineer Professional Exam Dumps and Practice Test Dumps   Question 381. Which Spark SQL function returns the position of the first occurrence of a substring within a string? 1) instr() 2) substring() 3) locate() 4) regexp_extract() Answer: 1) instr() Explanation: The instr() function searches for a specified substring within a […]

View Full Microsoft AB-100 Exam Dumps and Practice Test Dumps.   Question 1 A company wants to automate a repetitive business process using AI. Which factor should an architect assess first when determining whether an agent is appropriate? The number of employees using Microsoft Teams The business task, decision points, and level of automation required […]

View Full Microsoft AB-100 Exam Dumps and Practice Test Dumps.   Question 21 What is a key benefit of using a small language model for a focused business task? It always provides better results than every larger model It eliminates the need for business data It can provide efficient performance for a specific use case […]

View Full Microsoft AB-100 Exam Dumps and Practice Test Dumps.   Question 41 Which Microsoft service can help developers build generative AI applications? Microsoft Intune Microsoft Defender Microsoft Foundry Microsoft Entra ID Correct Answer: 3 Explanation Microsoft Foundry provides capabilities for building and managing AI applications and agentic solutions. It supports working with models, agents, […]

View Full Microsoft AB-100 Exam Dumps and Practice Test Dumps.   Question 61 Which component helps an agent decide which tool to use? Agent orchestration File compression DNS Firewall rules Correct Answer: 1 Explanation Agent orchestration coordinates the steps an agent takes to complete a task. It can help determine which tools, knowledge sources, or […]

View Full Microsoft AB-100 Exam Dumps and Practice Test Dumps.   Question 81 Which capability allows an AI agent to work with information from multiple sources? Screen sharing Knowledge grounding File renaming Printer management Correct Answer: 2 Explanation Knowledge grounding allows an AI agent to use information from relevant sources when generating responses. These sources […]

View Full Microsoft AB-100 Exam Dumps and Practice Test Dumps.   Question 101 What is the primary purpose of agent memory in an AI solution? To increase network bandwidth To replace authentication To remove all prompts To retain relevant information across interactions Correct Answer: 4 Explanation Agent memory allows an AI agent to retain relevant […]

View Full Microsoft AB-100 Exam Dumps and Practice Test Dumps.   Question 121 What is the main purpose of defining an agent’s goal? To specify the outcome the agent is expected to achieve To increase storage capacity To remove security controls To disable tool usage Correct Answer: 1 Explanation An agent goal defines the outcome […]

View Full Microsoft AB-100 Exam Dumps and Practice Test Dumps.   Question 141 What is the primary purpose of agent planning? To define the steps needed to achieve a goal To increase storage capacity To remove security controls To disable model evaluation Correct Answer: 1 Explanation Agent planning helps an AI system determine the steps […]

View Full Microsoft AB-100 Exam Dumps and Practice Test Dumps.   Question 161 What is the purpose of agent orchestration? To coordinate tasks, tools, and agents toward a goal To increase database storage To remove all user authentication To disable monitoring Correct Answer: 1 Explanation Agent orchestration coordinates different tasks, agents, tools, and workflows so […]